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

On Saturday 10 October 2009 1:46 pm, Tom Lane wrote:
> Robert Paulsen <robert(at)paulsenonline(dot)net> writes:
> > I have a database with a sequence field as a primary key in a table and
> > can no longer insert data into it as it gets the subject error message.
>
> Does the table actually have a default for id anymore? (Try looking
> at it with psql's \d command.)

pwvault=# \d vault
Table "public.vault"
Column | Type | Modifiers
----------+-------------------------+---------------
id | integer | not null
archived | boolean | default false
service | character varying(256) | not null
category | character varying(16) |
userid | character varying(256) | not null
passwd | character varying(256) | not null
url | character varying(4096) |
notes | text |
Indexes:
"vault_pkey" PRIMARY KEY, btree (id)

So no default for id. What should it be?

Something like one of this?

default nextval('vault_id_seq')

pwvault=# \d vault_id_seq
Sequence "public.vault_id_seq"
Column | Type
---------------+---------
sequence_name | name
last_value | bigint
increment_by | bigint
max_value | bigint
min_value | bigint
cache_value | bigint
log_cnt | bigint
is_cycled | boolean
is_called | boolean