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 22204.1255209151@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:
> I do have a question, though, I fixed things as indicated above: 
>     id integer DEFAULT nextval('vault_id_seq') NOT NULL,
> Dump gave back
>     id integer DEFAULT nextval('vault_id_seq'::text) NOT NULL,
> That "text" seems odd. Should I change it?

That's all there is in 8.0 ...
        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