From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thom Brown <thom@linux.com>
Cc: pgsql-docs <pgsql-docs@postgresql.org>
Subject: Re: SQL standard for TRUNCATE
Date: Mon, 14 Nov 2011 11:12:26 -0500
Message-ID: <27231.1321287146@sss.pgh.pa.us> (raw)
In-Reply-To: <CAA-aLv5RAvL+=9tgj=+PjhspREVM-fZ+pmATEULpUPYScbn4Pg@mail.gmail.com>
References: <CAA-aLv5RAvL+=9tgj=+PjhspREVM-fZ+pmATEULpUPYScbn4Pg@mail.gmail.com>
Thom Brown <thom@linux.com> writes:
> 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.
According to the reference page for TRUNCATE, the behaviors of those
clauses are not exactly compatible with the standard, which is why we
don't claim conformance.
> 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.
The features table doesn't really have room to put more than a "yes" or
"no" entry, and I don't think a pile of footnotes at the bottom would be
a helpful way to present additional info. Generally the best place for
any discussion of why a feature is spec-compatible or not is the
Compatibility section of the relevant reference page.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, thom@linux.com
Subject: Re: SQL standard for TRUNCATE
In-Reply-To: <27231.1321287146@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox