SQL standard for TRUNCATE

Поиск
Список
Период
Сортировка
От Thom Brown
Тема SQL standard for TRUNCATE
Дата
Msg-id CAA-aLv5RAvL+=9tgj=+PjhspREVM-fZ+pmATEULpUPYScbn4Pg@mail.gmail.com
обсуждение исходный текст
Ответы Re: SQL standard for TRUNCATE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
According to http://www.postgresql.org/docs/9.1/static/unsupported-features-sql-standard.html, PostgreSQL doesn't support identity column restart for TRUNCATE.  This might strictly be true because PostgreSQL doesn't implement identity columns as such, but it does support RESTART IDENTITY and CONTINUE IDENTITY, which will apply to sequences, and those are equivalent.  If it's going to say F202 is unsupported, shouldn't there at least be a note acknowledging this feature is supported for sequences, but otherwise it doesn't apply?  Some attempt to implement this has been made.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

В списке pgsql-docs по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Fwd: Re: Fwd: Link to PAM pages broken
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SQL standard for TRUNCATE