Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-www by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group