Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCHES] TRUNCATE TABLE with IDENTITY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] TRUNCATE TABLE with IDENTITY
Date
Msg-id 17769.1210989001@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] TRUNCATE TABLE with IDENTITY  (Neil Conway <neilc@samurai.com>)
Responses Re: [PATCHES] TRUNCATE TABLE with IDENTITY
List pgsql-hackers
Tree view 
Neil Conway <neilc@samurai.com> writes:
> Ugh. The fact that the RESTART IDENTITY part of TRUNCATE is
> non-transactional is a pretty unsightly wort.

Actually, I agree.  Shall we just revert that feature?  The ALTER
SEQUENCE part of this patch is clean and useful, but I'm less than
enamored of the TRUNCATE part.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: [PATCHES] TRUNCATE TABLE with IDENTITY
Next
From: Tom Lane
Date:
Subject: Re: missing $PostgreSQL:$