two serial fields within one table?

From: "amy cheng" <amycq(at)hotmail(dot)com>
To: pgsql-general(at)hub(dot)org
Subject: two serial fields within one table?
Date: 1999-10-12 12:31:13
Message-ID: 19991012193113.36602.qmail@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi, there,

I use two serial type fields within one table, seems psql does not
like it: it override the first one with the second one! Why? (seems to me
quite often if I do not want to normize it too much) or
something else?

here is the table:

create table tmpschedule
(
schedid serial,
addtime datetime,
eventid serial,
eventaddtime datetime,
poll int
);

thanks in advance!!!

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message greg 1999-10-12 13:06:57 Unrecognized variable client_encoding...
Previous Message greg 1999-10-12 10:56:38 How to read system variables like datestyle, etc...