Skip site navigation (1) Skip section navigation (2)

Re: ON COMMIT and foreign keys

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ON COMMIT and foreign keys
Date: 2004-11-06 05:43:51
Message-ID: 26357.1099719831@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> Incidentally ("collateral damage"), the patch modifies the TRUNCATE
> command so that it can work on multiple tables.  In particular, if
> foreign key references are all internal to the group that's being
> truncated, the command is allowed.

I think this is a feature addition that you've cleverly managed to
present as a bug fix ;-).  While I like the feature, I've got very
mixed emotions about applying it this late in beta.  The "bug" exists
in 7.4 but has yet to be reported in the field, which says to me that
we could leave it unfixed in 8.0 as well.  Conservatism would suggest
holding the change for 8.1.  OTOH, multiple TRUNCATE would be a useful
feature --- it came up just the other day.

Comments anyone?

			regards, tom lane

In response to

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-11-06 05:49:56
Subject: Re: [PATCHES] psql \! WIN32 cleanup
Previous:From: Tom LaneDate: 2004-11-06 05:30:55
Subject: Re: psql \! WIN32 cleanup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group