Re: [HACKERS] DROPping tables with SERIALs - Mailing list pgsql-hackers

From Zeugswetter Andreas IZ5
Subject Re: [HACKERS] DROPping tables with SERIALs
Date
Msg-id 219F68D65015D011A8E000006F8590C60180FAAB@sdexcsrv1.sd.spardat.at
Whole thread Raw
List pgsql-hackers
>> You can specify a nonzero value for a serial column 
>> (as long as it does not duplicate any existing value in that column), ...
>>  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>> 
>> ?!!!

>You can assign a value to a serial column, as long as it is unique.

Only an explicitly created unique index will enforce behavior this in
Informix.
(I tested this just to be sure)

Andreas


pgsql-hackers by date:

Previous
From: Horak Daniel
Date:
Subject: RE: [HACKERS] NT port
Next
From: Horak Daniel
Date:
Subject: RE: [HACKERS] NT port