All pastes #32572 Raw Edit

Someone

public text v1 · immutable
#32572 ·published 2005-12-05 21:05 UTC
rendered paste body
CREATE TABLE countries
(
  id serial NOT NULL,
  country_code varchar(5) NOT NULL,
  country varchar NOT NULL,
  "language" varchar(3),
  CONSTRAINT countries_pkey PRIMARY KEY (id)
) 

INSERT INTO "countries" ("country_code", "country", "language") VALUES ('AFG', 'Afghanistan', 'lt')
ERROR:  duplicate key violates unique constraint "countries_pkey"

However, if I manually set "id" it works. Any clues??