Re: ERROR: null value in column "id" violates not-null constraint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Paulsen <robert(at)paulsenonline(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ERROR: null value in column "id" violates not-null constraint
Date: 2009-10-10 21:12:31
Message-ID: 22204.1255209151@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Robert Paulsen <robert(at)paulsenonline(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robert Paulsen 2009-10-10 22:36:46 Re: ERROR: null value in column "id" violates not-null constraint
Previous Message Robert Paulsen 2009-10-10 20:29:15 Re: ERROR: null value in column "id" violates not-null constraint