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

Re: pg_get_serial_sequence Strangeness/Unreliable?

From: Jeff MacDonald <oss(at)bignose(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_get_serial_sequence Strangeness/Unreliable?
Date: 2008-11-26 16:58:49
Message-ID: 03620B7E-BB83-45F1-B157-2939E51B31CA@bignose.ca (view raw or flat)
Thread:
Lists: pgsql-general
On 25-Nov-08, at 10:44 AM, Tom Lane wrote:

> Jeff MacDonald <oss(at)bignose(dot)ca> writes:
>> The issue, is that when I run pg_get_serial_sequence on a particular
>> table/column it returns NULL.
>
> Does the column actually own that sequence?  Or is its default just
> something that was inserted manually?
>

Hi Tom, so far as I know the table "owns" the serial in so much as  
when i do a \d of the table it says this

status_id     | integer               | not null default  
nextval('status_status_id_seq'::regclass)

How else can I check?


In response to

Responses

pgsql-general by date

Next:From: Jeff MacDonaldDate: 2008-11-26 17:00:28
Subject: Re: pg_get_serial_sequence Strangeness/Unreliable?
Previous:From: Tom LaneDate: 2008-11-26 15:29:10
Subject: Re: case when evaluating else condition anyway?

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