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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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