Re: BUG #1356: pg_get_serial_sequence can not find a table that existing.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kamp Kaibo Huang" <Kamp_kbh(at)hotmail(dot)com>
Cc: pgsql-www(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1356: pg_get_serial_sequence can not find a table that existing.
Date: 2004-12-23 15:30:25
Message-ID: 28605.1103815825@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-www

"Kamp Kaibo Huang" <Kamp_kbh(at)hotmail(dot)com> writes:
> select pg_get_serial_sequence('tTestTableAnother','FId')
> ERROR: relation "ttesttableanother" does not exist

I think you need

select pg_get_serial_sequence('"tTestTableAnother"','"FId"');

regards, tom lane

[ could we please get the bug form fixed to route bugs to the right list? ]

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2004-12-23 15:34:09 Re: BUG #1356: pg_get_serial_sequence can not find a table that existing.
Previous Message Tom Lane 2004-12-23 15:27:38 Re: BUG #1354: psql.exe won't start on NTFS partition under some circumstances

Browse pgsql-www by date

  From Date Subject
Next Message Dave Page 2004-12-23 15:31:27 Re: Changing the developers page
Previous Message Tom Lane 2004-12-23 15:27:38 Re: BUG #1354: psql.exe won't start on NTFS partition under some circumstances