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

Поиск
Список
Период
Сортировка
Искать

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

От:
"Kamp Kaibo Huang" <Kamp_kbh@hotmail.com>
Дата:

The following bug has been logged online:

Bug reference:      1356
Logged by:          Kamp Kaibo Huang
Email address:      Kamp_kbh@hotmail.com
PostgreSQL version: 8.0
Operating system:   Microsoft Windows 2003
Description:        pg_get_serial_sequence can not find a table that
existing.
Details: 

I created one table via sql command like this:
CREATE TABLE tTestTable {
FId bigint NOT NULL DEFAULT(-1),
CONSTRAINT tTestTable_pkey PRIMARY KEY (FId)
);
And then I created another table via pgAdminIII 1.2 that installed with
PostgreSQL 8.0 rc1. sql like:
CREATE TABLE tTestTableAnother {
FId bigint NOT NULL DEFAULT
nextval('public."tTestTableAnother_FId_seq"'::text),
CONSTRAINT tTestTableAnother_pkey PRIMARY KEY (FId)
);

I type the following sqls:
>>select pg_get_serial_sequence('tTestTable','FId')
result is null, as I expected.

>>select pg_get_serial_sequence('ttesttable','fid')
result is null, as I expected.

>>select pg_get_serial_sequence('tTestTableAnother','FId')
ERROR:  relation "ttesttableanother" does not exist

>>select pg_get_serial_sequence('ttesttableanother','fid')
ERROR:  relation "ttesttableanother" does not exist

Open the pg_class, found 'tTestTableAnother' existing.
Caution, not 'ttesttableanother'.
And more, no table like 'tTestTable' existing while 'ttesttable'
appearance.

I guess PostgreSQL 8.0 does not offer a unique interface for creating a
table. Or pgAdminIII 1.2.0 calling the old function to create a table? But
no matter how, PostgreSQL should offer a unique way. over.

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

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Kamp Kaibo Huang"  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? ]

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

От:
"Dave Page" <dpage@vale-housing.co.uk>
Дата:
 

> -----Original Message-----
> From: pgsql-www-owner@postgresql.org 
> [mailto:pgsql-www-owner@postgresql.org] On Behalf Of Tom Lane
> Sent: 23 December 2004 15:30
> To: Kamp Kaibo Huang
> Cc: pgsql-www@postgresql.org; pgsql-bugs@postgresql.org
> Subject: Re: [pgsql-www] BUG #1356: pg_get_serial_sequence 
> can not find a table that existing. 
> 
> [ could we please get the bug form fixed to route bugs to the 
> right list? ]

I did that first thing this morning - please let me know if anyone spots
any further problems.

Regards, Dave
FAQ