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 <[EMAIL PROTECTED]> 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