sei sicuro che su il campo serial serva nextval?

codice:
CREATE TABLE people (
first_name VARCHAR(30),
last_name VARCHAR(30),
id SERIAL,

primary key(id));

insert the data:
INSERT INTO people VALUES ('joe', 'doe');