Re: BUG #2773: Problem pg_get_serial_sequence

Amelio wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2773
> Logged by:          Amelio
> Email address:      ameliocf@yahoo.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.

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@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

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