*PGadmin version 1.6.3 release 6112 on windows from the binary zip file from postgres8.2.5*
Creating a sequence by means of the graphical interface works, though a subsequent select nextval() claims he can't find the sequence
the script that is created: -- Sequence: "Uqn7" -- DROP SEQUENCE "Uqn7"; CREATE SEQUENCE "Uqn7" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 3 CACHE 1 CYCLE; ALTER TABLE "Uqn7" OWNER TO live; If I create the sequence without the double quotes -- Sequence: "Uqn7" -- DROP SEQUENCE "Uqn7"; CREATE SEQUENCE Uqn7 INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 3 CACHE 1 CYCLE; ALTER TABLE Uqn7 OWNER TO live; The sequence is created and works ! Pascal Van Puymbroeck ZENON productions bvba BELGIUM