2 or more columns of type 'serial' in a table

Поиск
Список
Период
Сортировка
От Aggarwal , Ajay
Тема 2 or more columns of type 'serial' in a table
Дата
Msg-id 913D1DA53416D411835000508BC244C2227D99@cbsvr1.crossbeamsys.com
обсуждение исходный текст
Ответы Re: 2 or more columns of type 'serial' in a table
Список 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 по дате отправления:

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: Backends dying due to memory exhaustion--I'm stonkered
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Backends dying due to memory exhaustion--I'm stonkered