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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-patches by date

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