Hubert Hafner ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Datatype SERIAL incorrectly interpreted
Long Description
If you create a table with more than 1 SERIAL, only for the last a sequence is created
by PostgreSQL. The other fields only set to INTEGER, but there is no sequence for.
Sample Code
CREATE TABLE Example (Field1 SERIAL, Field2 SERIAL);
PostgreSQL would generate:
Table Example:
Field1 as INTEGER NOT NULL DEFAULT nextval(Field1_Example_seq)
Field2 as INTEGER NOT NULL DEFAULT nextval(Field2_Example_seq)
But only Field2_Example_seq really exits!
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
