Tom,
Thanks for the response.
The tables were created from the output from the previous release
pg_dump program, which omitted the double quotes in the DEFAULT
nextval() clause. I have tested the new version of pg_dump which
includes them if the sequence name contain mixed case characters.
Regards,
Brian
Tom Lane wrote:
>Brian Harris <brian@harris-piper.freeserve.co.uk> writes:
>
>
>> id | integer | not null default nextval('T_Joint_id_seq'::text)
>>
>>
>
>This default is wrong --- it should be
> nextval('"T_Joint_id_seq"'::text)
>Note the quotes.
>
> regards, tom lane
>
>
>