Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: null value in column "id" violates not-null constraint - Mailing list pgsql-sql

From Robert Paulsen
Subject Re: ERROR: null value in column "id" violates not-null constraint
Date
Msg-id 200910101405.26853.robert@paulsenonline.net
Whole thread Raw
In response to Re: ERROR: null value in column "id" violates not-null constraint  (Robert Paulsen <robert@paulsenonline.net>)
Responses Re: ERROR: null value in column "id" violates not-null constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
On Saturday 10 October 2009 2:00 pm, Robert Paulsen wrote:
>
> So no default for id. What should it be?
>
> Something like one of this?
>
>     default nextval('vault_id_seq')
>

Should have tried that before posting last message -- it worked. Thanks!

pgsql-sql by date:

Previous
From: Robert Paulsen
Date:
Subject: Re: ERROR: null value in column "id" violates not-null constraint
Next
From: Tom Lane
Date:
Subject: Re: ERROR: null value in column "id" violates not-null constraint