BUG #2733: pg_get_serial_sequence error (addition: may be tsearch2 related)

Started by Basil Evseenkoover 19 years ago1 messagesbugs
Jump to latest
#1Basil Evseenko
evseenko@sysoft.ru

The following bug has been logged online:

Bug reference: 2733
Logged by: Basil Evseenko
Email address: evseenko@sysoft.ru
PostgreSQL version: 8.2beta2
Operating system: Linux 2.6
Description: pg_get_serial_sequence error (addition: may be tsearch2
related)
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 (with contrib/tsearch2)

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

This bug seems only affected tables, that have
tsearch2 columns/indexes installed.