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