Re: TRUNCATE TABLE with IDENTITY - Mailing list pgsql-hackers

From Tom Lane
Subject Re: TRUNCATE TABLE with IDENTITY
Date
Msg-id 21634.1206460128@sss.pgh.pa.us
Whole thread Raw
In response to TRUNCATE TABLE with IDENTITY  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: TRUNCATE TABLE with IDENTITY  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> SQL200n specifies a new qualifier on a TRUNCATE command
> TRUNCATE TABLE foo
>     [ CONTINUE IDENTITY | RESTART IDENTITY ]

> CONTINUE IDENTITY is the default and does nothing, like now.

> RESTART IDENTITY will reset the SERIAL sequences back to the original
> start value.

> Seems like a % project for the TODO list

Seems like copying syntax from a *draft* standard is a bit premature,
especially when the amount of functionality added is nil.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: FETCH FIRST
Next
From: Tom Lane
Date:
Subject: Re: [pgsql-www] New email list for emergency communications