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 20:16:30
Message-ID: 20765.1255205790@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:
> 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

In response to

Responses

Browse pgsql-sql by date

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