INSERT Issues

CREATE TABLE junk ( col SERIAL PRIMARY KEY
);

INSERT INTO junk (col) DEFAULT VALUES;

INSERT INTO junk DEFAULT VALUES:


Second insert works, first one fails.

INSERT INTO table [ ( column [, ...] ) ]   { DEFAULT VALUES | VALUES ( expression [, ...] ) | SELECT query }


The column list should just be ignored correct?

--
Rod Taylor

There are always four sides to every story: your side, their side, the
truth, and what really happened.