Re: pg_get_serial_sequence Strangeness/Unreliable?

ALTER SEQUENCE OWNED BY worked!

Thanks folks.

jeff.

On 26-Nov-08, at 1:04 PM, Alvaro Herrera wrote:

> Jeff MacDonald wrote:
>
>> 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?
>
> He means ALTER SEQUENCE ... OWNED BY
>
> I don't know how you can ensure that it is, short of
>
> begin;
> drop table status;
> \d status_status_id_seq
> -- verify that the sequence exists; if owned, it should have been
> dropped too
> rollback;
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support