Joshua Tolley weote:
On Sat, Jul 25, 2009 at 08:41:12PM -0400, Robert Haas wrote:
On Sat, Jul 25, 2009 at 8:39 PM, Joshua Tolleyeggyk...@gmail.com wrote:
Immediately after concluding I was done with my review, I realized I'd
completely forgotten to look at the docs. I've made a few
On Sun, Jul 26, 2009 at 01:42:32PM +0900, KaiGai Kohei wrote:
Robert Haas wrote:
Sam Mason wrote:
The traditional approach would be to maintain multiple physically
separate databases; in this setup it's obvious that when you perform a
backup of one of these databases you're only seeing a
On Sun, Jul 26, 2009 at 12:27:12PM +0900, KaiGai Kohei wrote:
Indeed, the draft used the term of security context with minimum
introductions, but not enough friendliness for database folks.
The purpose of security context is an identifier of any subject and
object to describe them in the
KaiGai Kohei wrote:
The SELinux provides a certain process privilege to make backups and
restore them. In the (currect) default policy, it is called unconfined.
However, it is also *possible* to define a new special process privilege
for backup and restore tools. For example, it can access
Hello
new patch add new contrib transformations with three modules
anotation, decode and json.
These modules are ported from my older work.
Before applying this patch, please use named-fixed patch too. The hook
doesn't need it, but modules anotation and json depend on it.
Regards
Pavel Stehule
Hello
note about SQL:201x
http://blogs.mysql.com/peterg/2009/06/07/soothsaying-sql-standardization-stuff/
regards
Pavel Stehule
2009/7/26 Pavel Stehule pavel.steh...@gmail.com:
Hello
new patch add new contrib transformations with three modules
anotation, decode and json.
These modules are
Sam Mason wrote:
On Sun, Jul 26, 2009 at 12:27:12PM +0900, KaiGai Kohei wrote:
Indeed, the draft used the term of security context with minimum
introductions, but not enough friendliness for database folks.
The purpose of security context is an identifier of any subject and
object to describe
Andrew Dunstan wrote:
KaiGai Kohei wrote:
The SELinux provides a certain process privilege to make backups and
restore them. In the (currect) default policy, it is called unconfined.
However, it is also *possible* to define a new special process privilege
for backup and restore tools. For
KaiGai Kohei wrote:
Andrew Dunstan wrote:
KaiGai Kohei wrote:
The SELinux provides a certain process privilege to make backups and
restore them. In the (currect) default policy, it is called
unconfined.
However, it is also *possible* to define a new special process
privilege
for
Robert Haas robertmh...@gmail.com writes:
On Sat, Jul 25, 2009 at 6:40 PM, Tom Lanet...@sss.pgh.pa.us wrote:
I'm not nearly as excited about migrating all or even most of, say,
the pg_proc DATA lines into SQL.
I think it would actually buy you quite a bit to migrate them to SQL,
because in
Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
On Sat, Jul 25, 2009 at 6:40 PM, Tom Lanet...@sss.pgh.pa.us wrote:
I'm not nearly as excited about migrating all or even most of, say,
the pg_proc DATA lines into SQL.
I think it would actually buy you quite a bit
Robert Haas robertmh...@gmail.com writes:
... One thing I have belatedly realized about this
CommitFest is that we (or at least, I) did not think about asking the
committers about their schedules, and it turns out that three of them
- Heikki, Michael Meskes, Joe Conway - are away at the
I wrote:
... So maybe we could split the current bootstrap phase
into three phases:
* create core catalogs and load DATA commands, using bki
* create operator classes, using sql script
* create indexes, using bki
* proceed on as before
I experimented with that a
Robert Haas wrote:
If you want to store intelligence data about the war in Iraq and
intelligence data about the war in Afghanistan, it might not be too
bad to store them in separate databases, though storing them in the
same database might also make things simpler for users who have access
to
On Sun, Jul 26, 2009 at 5:48 PM, Tom Lanet...@sss.pgh.pa.us wrote:
In the spirit of not inventing single-purpose solutions, I suggest
that the BKI representation for this might be something like
BKI_EXECUTE( any old SQL command );
where the bootstrap.c code just passes the given string to
Fujii Masao masao.fu...@gmail.com writes:
I updated the patch to solve two problems which you pointed.
Here is the changes:
* Prevented the obsolete flag to being set to a new process, by using
newly-introduced spinlock.
* Used the index of AuxiliaryProcs instead of auxType, to assign
Sam Mason s...@samason.me.uk wrote:
I've not read much of his writings, any canonical references for
this sort of discussion?
I think this is the one, although it's been a while since I read it,
and I might be getting it confused with something else he wrote:
Codd, E.F. (1990). The
Greg Stark gsst...@mit.edu writes:
AFAICT the only opclasses that need to be in the bootstrap set are
int2_ops, int4_ops, name_ops, oid_ops, and oidvector_ops.
Maybe so, but the first two are part of the integer_ops family. If
we have to continue implementing all of that through DATA
Hello,
I try to write GiST support for one custom type and I am not sure
about compress function. I don't understand where I can specify size
of returned compressed key. 8.1 and older had 6. parameter for size,
but this parameter is missing in new versions.
Can somebody explain, where pg take
On Sun, Jul 26, 2009 at 11:31 AM, Tom Lanet...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Sat, Jul 25, 2009 at 6:40 PM, Tom Lanet...@sss.pgh.pa.us wrote:
I'm not nearly as excited about migrating all or even most of, say,
the pg_proc DATA lines into SQL.
I think it
On Sun, Jul 26, 2009 at 1:58 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Greg Stark gsst...@mit.edu writes:
AFAICT the only opclasses that need to be in the bootstrap set are
int2_ops, int4_ops, name_ops, oid_ops, and oidvector_ops.
Maybe so, but the first two are part of the integer_ops family.
On Sun, Jul 26, 2009 at 12:07 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
... One thing I have belatedly realized about this
CommitFest is that we (or at least, I) did not think about asking the
committers about their schedules, and it turns out that three
Robert Haas wrote:
I think Joe is back in the next week, but I'm not sure about Michael or
Heikki.
I'll be back on Monday 3rd of August.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make
Andrew Dunstan wrote:
KaiGai Kohei wrote:
Andrew Dunstan wrote:
KaiGai Kohei wrote:
The SELinux provides a certain process privilege to make backups and
restore them. In the (currect) default policy, it is called
unconfined.
However, it is also *possible* to define a new special
On Sun, Jul 26, 2009 at 6:49 PM, Kevin
Grittnerkevin.gritt...@wicourts.gov wrote:
Also, the
requirement that, to be considered a relational database, it must be
impossible to write two queries which can be shown to be logically
equivalent but which optimize to different access plans to be,
On Sun, Jul 26, 2009 at 12:49:32PM -0500, Kevin Grittner wrote:
Codd, E.F. (1990). The Relational Model for Database Management
(Version 2 ed.). Addison Wesley Publishing Company.
ISBN 0-201-14192-2.
Looks as though I've got some reading to do then--somewhat annoying that
only second hand
On Jul 25, 2009, at 4:41 PM, David E. Wheeler wrote:
Useless perhaps, but it's gonna happen, and someone may even have a
reason for it. Until such time as NULLs are killed off, we need to
be able to deal with SQL's pathologies.
And something I'd like to be able to handle in a while loop,
On Sun, Jul 26, 2009 at 03:46:19PM -0700, David E. Wheeler wrote:
And something I'd like to be able to handle in a while loop, as I'm
actually fetching one row at a time from two cursors and need to be
able to tell when I've reached the end of a cursor.
I'm sure I'm missing something
On Jul 26, 2009, at 6:46 PM, David E. Wheeler wrote:
Is there some way to get using_while() to properly return all the
records?
I'm just a random lurker, but FOUND seems to work just fine (I suppose
it's PG-specific?).
Robert Haas robertmh...@gmail.com writes:
Here's the update. There are a few things that I'm not entirely happy
with here, but not quite sure what to do about either.
Committed with a few editorializations.
- ExplainPrintPlan() is now almost trivial. It seems like there
should be some way
Robert Haas robertmh...@gmail.com writes:
Introducing defaults for DATA() would bring some benefits because it
would mostly avoid the need to change every row in the file when
adding a new column. But a preprocessing script can do much more
sophisticated transformations, like computing a
Robert Haas robertmh...@gmail.com writes:
On Sun, Jul 26, 2009 at 1:58 PM, Tom Lanet...@sss.pgh.pa.us wrote:
I think we need to try to get *all* of the operator
classes out of the hand-maintained-DATA-entries collection.
Is this mostly a forward-reference problem?
No, I don't see that as
Tom Lane escribió:
I experimented with that a little bit and found it doesn't seem to be
tremendously easy. A non-bootstrap-mode backend will PANIC immediately
on startup if it doesn't find the critical system indexes, so the second
step has issues. Also, there is no provision for resuming
On Sun, Jul 26, 2009 at 7:40 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
Here's the update. There are a few things that I'm not entirely happy
with here, but not quite sure what to do about either.
Committed with a few editorializations.
Thanks.
-
Tom Lane t...@sss.pgh.pa.us wrote:
We should call [Read dumpfile] routine only once even on Windows.
Seems to me that you should simply do the load only when found is false.
Here is a patch to fix pg_stat_statements on Windows.
I see we don't need any locks because initialization is done in
On Sun, Jul 26, 2009 at 8:46 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
Introducing defaults for DATA() would bring some benefits because it
would mostly avoid the need to change every row in the file when
adding a new column. But a preprocessing script
Gregory Stark st...@enterprisedb.com writes:
Here's a copy of the merge-append patch that I sent months ago merged up to
head. I haven't really added any additional functionality since then.
I looked at the planner part of this a little bit. I think that it's
confusing an append that produces
Itagaki Takahiro escribió:
Tom Lane t...@sss.pgh.pa.us wrote:
We should call [Read dumpfile] routine only once even on Windows.
Seems to me that you should simply do the load only when found is false.
Here is a patch to fix pg_stat_statements on Windows.
Hmm, it seems the comment
Itagaki Takahiro itagaki.takah...@oss.ntt.co.jp writes:
Here is a patch to fix pg_stat_statements on Windows.
Yeah, that looks about right to me. Committed.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
Alvaro Herrera alvhe...@commandprompt.com writes:
Itagaki Takahiro escribió:
Here is a patch to fix pg_stat_statements on Windows.
Hmm, it seems the comment just above the patched line needs to be fixed.
I looked at that and decided it was OK as-is. How do you want to
change it?
Tom Lane escribió:
Alvaro Herrera alvhe...@commandprompt.com writes:
Itagaki Takahiro escribi�:
Here is a patch to fix pg_stat_statements on Windows.
Hmm, it seems the comment just above the patched line needs to be fixed.
I looked at that and decided it was OK as-is. How do you want
Alvaro Herrera alvhe...@commandprompt.com writes:
Tom Lane escribió:
I looked at that and decided it was OK as-is. How do you want to
change it?
The reason that it doesn't need locks is not that there's no other
process running, but that it was already initialized, in the case when
found
42 matches
Mail list logo