From: | "Basil Evseenko" <evseenko(at)sysoft(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2733: pg_get_serial_sequence error (addition: may be tsearch2 related) |
Date: | 2006-11-03 14:36:59 |
Message-ID: | 200611031436.kA3Eaxj0094133@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2733
Logged by: Basil Evseenko
Email address: evseenko(at)sysoft(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-11-03 14:40:38 | Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio |
Previous Message | Andreas Lange | 2006-11-03 14:32:54 | Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio |