From: | Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | SERIAL problems? |
Date: | 2006-06-06 21:19:08 |
Message-ID: | 4485F14C.3000105@dunaweb.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I just saw these in the TODO list:
o %Disallow changing DEFAULT expression of a SERIAL column?
This should be done only if the existing SERIAL problems cannot be
fixed.
o %Disallow ALTER SEQUENCE changes for SERIAL sequences
because pg_dump does not dump the changes
What are the "existing problems"?
I am asking because I am experimenting to implement
the SQL2003 compliant form for the serial type
to be able specify the underlying sequence
parameters:
SERIAL [ GENERATED [ ALWAYS | BY DEFAULT ]
AS IDENTITY (
[ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | NO MINVALUE ]
[ MAXVALUE maxvalue | NO MAXVALUE ]
[ START [ WITH ] start ]
[ CACHE cache ]
[ [ NO ] CYCLE ]
) ]
Best regards,
Zoltán Böszörményi
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-06-06 21:24:14 | Re: That EXPLAIN ANALYZE patch still needs work |
Previous Message | Tom Lane | 2006-06-06 21:17:19 | Re: That EXPLAIN ANALYZE patch still needs work |