From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Amelio <ameliocf(at)yahoo(dot)com(dot)br> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #2773: Problem pg_get_serial_sequence |
Date: | 2006-11-21 17:08:06 |
Message-ID: | 200611211708.kALH86N03282@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Amelio wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2773
> Logged by: Amelio
> Email address: ameliocf(at)yahoo(dot)com(dot)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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Kaltenbrunner | 2006-11-21 17:13:44 | Re: BUG #2773: Problem pg_get_serial_sequence |
Previous Message | rahman sule | 2006-11-21 16:28:18 | PGSQL SETUP PROBLEM |