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
How else can I check?
In response to
pgsql-general by date
|Next:||From: Jeff MacDonald||Date: 2008-11-26 17:00:28|
|Subject: Re: pg_get_serial_sequence Strangeness/Unreliable?|
|Previous:||From: Tom Lane||Date: 2008-11-26 15:29:10|
|Subject: Re: case when evaluating else condition anyway? |