Re: [PATCHES] New version of GENERATED/IDENTITY, was Re: parser dilemma

2007-04-26 Thread Zoltan Boszormenyi
Thanks. But actually it didn't showed up at that page. For that matter, neither patch showed up on either pgpatches or pgpatches_hold that you indicated yesterday. Best regards, Zoltán Böszörményi Bruce Momjian írta: Your patch has been added to the PostgreSQL unapplied patches list at:

Re: [PATCHES] updated SORT/LIMIT patch

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Gr

Re: [PATCHES] [HACKERS] autovacuum does not start in HEAD

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- IT

[PATCHES] Re: actualised forgotten Magnus's patch for plpgsql MOVE statement

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Pa

Re: [PATCHES] HOT + MVCC-safe cluster conflict fix

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- He

Re: [PATCHES] CREATE TABLE LIKE INCLUDING INDEXES support

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Tr

Re: [PATCHES] UPDATE using sub selects

2007-04-26 Thread Bruce Momjian
This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- NikhilS wrote: > Hi, > > As per discussion on -hackers, a patch which allows updates to use > subselects is attached

Re: [PATCHES] [HACKERS] CIC and deadlocks

2007-04-26 Thread Bruce Momjian
This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Pavan Deolasee wrote: > On 4/11/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > > > > [ itch... ] The problem is with t

Re: [PATCHES] non-recursive WITH clause support

2007-04-26 Thread Bruce Momjian
This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Gregory Stark wrote: > "David Fetter" <[EMAIL PROTECTED]> writes: > > > On Mon, Apr 09, 2007 at 06:43:08PM -0400, To

Re: [PATCHES] Reviewers Guide to Deferred Transactions/TransactionGuarantee

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- IT

Re: [PATCHES] Reviewers Guide to Deferred Transactions/TransactionGuarantee

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Si

Re: [PATCHES] [HACKERS] Full page writes improvement, code update

2007-04-26 Thread Koichi Suzuki
Josh, Josh Berkus wrote: Koichi, Andreas, 1) To deal with partial/inconsisitent write to the data file at crash recovery, we need full page writes at the first modification to pages after each checkpoint. It consumes much of WAL space. We need to find a way around this someday. Other DBs

Re: [PATCHES] Reviewers Guide to Deferred Transactions/Transaction Guarantee

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Si

Re: [PATCHES] [GENERAL] dropping role w/dependent objects

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Ed

Re: [PATCHES] Re: [HACKERS] [COMMITTERS] pgsql: Add GUC temp_tablespaces to provide a default location for

2007-04-26 Thread Bruce Momjian
I think we will have to wait for 8.4 for this. --- Jaime Casanova wrote: > On 4/2/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > This has been saved for the 8.4 release: > > > >http://momjian.postgresql.org/cgi

Re: [PATCHES] Preliminary GSSAPI Patches

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- He

Re: [PATCHES] Auto Partitioning Patch - WIP version 1

2007-04-26 Thread Bruce Momjian
This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- NikhilS wrote: > Hi, > > Please find attached the WIP version 1 of the auto partitioning patch. There > was discussi

Re: [PATCHES] [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-26 Thread Tom Lane
Attached is the complete patch against HEAD to prevent hashtable bucket splits during hash_seq_search. Any comments before I start back-porting? I suppose we had better patch this all the way back, even though AtPrepare_Locks() is the only known trouble spot. regards, tom

Re: [PATCHES] New version of GENERATED/IDENTITY, was Re: parser dilemma

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Zo

Re: [PATCHES] New version of GENERATED/IDENTITY, was Re: parser dilemma

2007-04-26 Thread Zoltan Boszormenyi
Hi, some last changes. Really. :-) I made ALTER TABLE symmetric with CREATE TABLE so the grammar now has: ALTER TABLE tabname ALTER colname SET GENERATED { ALWAYS | BY DEFAULT} AS IDENTITY [ ( sequence options )] This works intuitively the same as in CREATE TABLE, i.e. - it creates an OWNED

Re: [PATCHES] New version of GENERATED/IDENTITY, was Re: parser dilemma

2007-04-26 Thread Zoltan Boszormenyi
And here it is attached. Sorry. Zoltan Boszormenyi írta: Hi, here's the patch with the modifications suggested by Tom Lane. The postfix rule was deleted from b_expr and the reverse parsing in ruleutils.c::get_oper_expr() always puts parentheses around postfix operators. Other changes: - OVERRI

[PATCHES] New version of GENERATED/IDENTITY, was Re: parser dilemma

2007-04-26 Thread Zoltan Boszormenyi
Hi, here's the patch with the modifications suggested by Tom Lane. The postfix rule was deleted from b_expr and the reverse parsing in ruleutils.c::get_oper_expr() always puts parentheses around postfix operators. Other changes: - OVERRIDING SYSTEM VALUE in COPY can appear at any place in the