The following bug has been logged online:

Bug reference: 2773
Logged by: Amelio
Email address: ameliocf (AT) yahoo (DOT) com.br
PostgreSQL version: 8.2 beta 2
Operating system: Windows XP
Description: Problem pg_get_serial_sequence
Details:

The pg_get_serial_sequence function is returning the name of the index on
the referenced column.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Amelio wrote:
Can you provide a reproducible test case? It looks OK to me:

test=> CREATE TABLE test (x SERIAL);
NOTICE: CREATE TABLE will create implicit sequence "test_x_seq" for
serial column "test.x"
CREATE TABLE

test=> SELECT pg_get_serial_sequence('test', 'x');
pg_get_serial_sequence
------------------------
public.test_x_seq
(1 row)

test=> CREATE INDEX i_test ON test(x);
CREATE INDEX

test=> SELECT pg_get_serial_sequence('test', 'x');
pg_get_serial_sequence
------------------------
public.test_x_seq
(1 row)

--
Bruce Momjian bruce (AT) momjian (DOT) us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Bruce Momjian <bruce (AT) momjian (DOT) us> writes:
That's because it's been fixed...
http://archives.postgresql.org/pgsql...1/msg00074.php

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Amelio wrote:
Thanks for the report but this is is already fixed in the current codebase:

http://archives.postgresql.org/pgsql...1/msg00074.php


Stefan

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend