two serial fields within one table? - Mailing list 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