Kindly Cc your responses to ajay(at)crossbeamsys(dot)com as well..
I am having a problem, while trying to CREATE a table with more than one
column of type 'serial'. Apparently only one sequence gets created and that
is for the last 'serial' type column in the table. The CREATE command seems
to succeed though ....
The table I am trying to create looks like this:
CREATE TABLE my_table (
charId serial,
charName varchar (32) PRIMARY KEY,
index serial,
index2 serial,
value int
);
I am working with postgres version 7.0.3-2
Ajay