Bug report

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

Responses

Browse pgadmin-support by date

  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