Re: TRUNCATE TABLE with IDENTITY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: TRUNCATE TABLE with IDENTITY
Дата
Msg-id 21634.1206460128@sss.pgh.pa.us
обсуждение исходный текст
Ответ на TRUNCATE TABLE with IDENTITY  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: TRUNCATE TABLE with IDENTITY  (Simon Riggs <simon@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: FETCH FIRST
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [pgsql-www] New email list for emergency communications