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

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

On Saturday 10 October 2009 4:12 pm, Tom Lane wrote:
> 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

Thanks!

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitriy Igrishin 2009-10-11 08:32:05 Re: ERROR: null value in column "id" violates not-null constraint
Previous Message Tom Lane 2009-10-10 21:12:31 Re: ERROR: null value in column "id" violates not-null constraint