Skip site navigation (1) Skip section navigation (2)

BUG #3295: pg_get_serial_sequence returns wrong sequence name for a serial column

From: "Philip Ives" <phil(at)ivesdigital(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3295: pg_get_serial_sequence returns wrong sequence name for a serial column
Date: 2007-05-21 19:10:34
Message-ID: 200705211910.l4LJAYGs002693@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3295
Logged by:          Philip Ives
Email address:      phil(at)ivesdigital(dot)com
PostgreSQL version: 8.1.4
Operating system:   Darwin and FreeBSD 4
Description:        pg_get_serial_sequence returns wrong sequence name for a
serial column
Details: 

pg_get_serial_sequence doesn't return the correct sequence name and returns
a null. This function either shouldn't exist or it should always return the
right name.

:                                             Table "public.ccprocesses"
       Column        |            Type             |                        
   Modifiers                             
---------------------+-----------------------------+------------------------
------------------------------------------
 id                  | bigint                      | not null default
nextval(('seq_ccprocesses_id'::text)::regclass)

select * from pg_get_serial_sequence('ccprocesses','id');
 pg_get_serial_sequence 
------------------------
 
(1 row)

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-05-21 23:21:46
Subject: Re: BUG #3295: pg_get_serial_sequence returns wrong sequence name for a serial column
Previous:From: Zdenek KotalaDate: 2007-05-21 17:43:55
Subject: Re: BUG #3291: Query tool not returning all results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group