*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





Reply via email to