On Mon, 2005-09-26 at 11:54 +1000, Warren Toomey wrote: > I replaced this with the following column definition: > > id serial PRIMARY KEY, > > This allowed read access to the table, but the insertion of new records > failed. After changing the column definition to: > > id serial NOT NULL PRIMARY KEY, > > everything seems to work, including edits and insertions. > I hope this is of some use. > Cheers, > Warren
That's strange since in the documentation "a primary key constraint is simply a combination of a unique constraint and a not-null constraint"[1]. [1] http://www.postgresql.org/docs/7.4/static/ddl-constraints.html#AEN1975 -- Paulo Silva <[EMAIL PROTECTED]> Eurotux Informática, S. A.
signature.asc
Description: This is a digitally signed message part
