IDENTITY/GENERATED v31

From: Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu>
To: pgsql-patches(at)postgresql(dot)org
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: IDENTITY/GENERATED v31
Date: 2007-02-25 23:23:24
Message-ID: 45E21A6C.3090404@dunaweb.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi,

here comes the next version. Changes:
* Implemented ALTER TABLE ... DROP IDENTITY
and SET GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY
* Extended documentation and testcase for the above.
* pg_dump now dumps the proper ALTER for such columns.
Reintroduced the pg_dump feature to dump
OVERRIDING SYSTEM VALUE for INSERT and
COPY statements if the table schema contains any
GENERATED ALWAYS column.
* There can be only one IDENTITY column in a table at any time.
This is checked on CREATE, ALTER TABLE ADD and
ALTER TABLE SET ... IDENTITY and required for SQL:2003
compliance.
* On update, the GENERATED columns' late generation
of DEFAULT value is also implemented. The GENERATED
ALWAYS AS ( expr ) still only deals within the same
limits as regular DEFAULT.
* Implemented a check so CHECK constraints cannot
reference IDENTITY/GENERATED columns.
It is checked on CREATE AND ALTER TABLE
ADD CONSTRAINT and ALTER TABLE ADD COLUMN.
It makes sense because IDENTITY and GENERATED
columns has to be assigned after all other columns were
assigned with values and validated via constraints.

I hereby declare the IDENTITY part feature complete.
Please review.

Best regards,
Zoltán Böszörményi

Attachment Content-Type Size
psql-serial-31.diff.gz application/x-tar 31.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-02-25 23:28:20 Re: [Monotone-devel] Re: SCMS question
Previous Message Neil Conway 2007-02-25 23:06:57 Re: SCMS question

Browse pgsql-patches by date

  From Date Subject
Next Message Matteo Beccati 2007-02-26 08:42:00 Re: Small patch to compile on IRIX 6.5 with gcc
Previous Message Andrew Dunstan 2007-02-25 14:17:47 Re: Small patch to compile on IRIX 6.5 with gcc