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.