2 or more columns of type 'serial' in a table - Mailing list pgsql-general

From Aggarwal , Ajay
Subject 2 or more columns of type 'serial' in a table
Date
Msg-id 913D1DA53416D411835000508BC244C2227D99@cbsvr1.crossbeamsys.com
Whole thread Raw
Responses Re: 2 or more columns of type 'serial' in a table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Kindly Cc your responses to ajay@crossbeamsys.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


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Backends dying due to memory exhaustion--I'm stonkered
Next
From: Tom Lane
Date:
Subject: Re: Backends dying due to memory exhaustion--I'm stonkered