Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: ERROR: null value in column "id" violates not-null constraint
Date
Msg-id 20765.1255205790@sss.pgh.pa.us
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  (Robert Paulsen <robert@paulsenonline.net>)
List pgsql-sql
Tree view 
Robert Paulsen <robert@paulsenonline.net> writes:
> On Saturday 10 October 2009 2:00 pm, Robert Paulsen wrote:
>> So no default for id. What should it be?
>> default nextval('vault_id_seq')

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

So the next question is just what happened and whether you're missing
anything else from the original database state ...
        regards, tom lane

pgsql-sql by date:

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