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

Robert Paulsen <robert@paulsenonline.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