From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Pascal Van Puymbroeck <pascal(dot)vanpuymbroeck(at)zenonproductions(dot)be> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Bug report |
Date: | 2007-09-26 08:19:05 |
Message-ID: | 46FA15F9.7020206@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Dave Page wrote:
> Pascal Van Puymbroeck wrote:
>> *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
>>
>
> ...
>
>> If I create the sequence without the double quotes
>
>> CREATE SEQUENCE Uqn7
>
> ...
>
>> The sequence is created and works !
The name gets folded to lower case without the quote so I suspect what
is happening is that you are not quoting the name in the nextval call
correctly. This works:
SELECT nextval('"Uqn7"');
To avoid having to use the double quotes at all, stick to names that
aren't keywords, and are lower case only, optionally including numbers or _
Regards Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-09-26 08:32:29 | Re: SSL problem in pgAdmin3 1.8.0 beta 5 |
Previous Message | Alejandro Gasca | 2007-09-26 05:17:57 | SSL problem in pgAdmin3 1.8.0 beta 5 |