Skip site navigation (1) Skip section navigation (2)

SQL standard for TRUNCATE

From: Thom Brown <thom(at)linux(dot)com>
To: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: SQL standard for TRUNCATE
Date: 2011-11-14 15:24:22
Message-ID: CAA-aLv5RAvL+=9tgj=+PjhspREVM-fZ+pmATEULpUPYScbn4Pg@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2011-11-14 16:12:26
Subject: Re: SQL standard for TRUNCATE
Previous:From: Alvaro HerreraDate: 2011-11-10 19:40:55
Subject: Fwd: Re: Fwd: Link to PAM pages broken

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group