From: | Pascal Van Puymbroeck <pascal(dot)vanpuymbroeck(at)zenonproductions(dot)be> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Bug report |
Date: | 2007-09-25 19:31:22 |
Message-ID: | 46F9620A.5030004@zenonproductions.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
*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
From | Date | Subject | |
---|---|---|---|
Next Message | Alejandro Gasca | 2007-09-26 05:17:57 | SSL problem in pgAdmin3 1.8.0 beta 5 |
Previous Message | Dave Page | 2007-09-24 08:04:11 | Re: 1.8-Beta5 Bug: sequence properties dialog produces wrong sql statement order |