Postgres Pro
Downloads
Home   >   mailing lists

BUG #2732: pg_get_serial_sequence error - Mailing list pgsql-bugs

From Basil Evseenko
Subject BUG #2732: pg_get_serial_sequence error
Date
Msg-id 200611031427.kA3ERqij093772@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2732: pg_get_serial_sequence error
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      2732
Logged by:          Basil Evseenko
Email address:      evseenko@sysoft.ru
PostgreSQL version: 8.2beta2
Operating system:   Linux 2.6
Description:        pg_get_serial_sequence error
Details:

On 8.1.5:
 select pg_catalog.pg_get_serial_sequence('album', 'id');
    pg_get_serial_sequence
------------------------------
 tables.album_id_seq

On 8.2beta2

select pg_catalog.pg_get_serial_sequence('album', 'id');
         pg_get_serial_sequence
----------------------------------------
 tables.album_title_lower2_idx

So pg_catalog.pg_get_serial_sequence return garbage: index name vs sequence
name

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio
Next
From: "Basil Evseenko"
Date:
Subject: BUG #2733: pg_get_serial_sequence error (addition: may be tsearch2 related)