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 19:05:26
Message-ID: 200910101405.26853.robert@paulsenonline.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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!

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2009-10-10 20:16:30 Re: ERROR: null value in column "id" violates not-null constraint
Previous Message Robert Paulsen 2009-10-10 19:00:46 Re: ERROR: null value in column "id" violates not-null constraint