Re: pg_get_serial_sequence Strangeness/Unreliable?

Поиск
Список
Период
Сортировка
От Jeff MacDonald
Тема Re: pg_get_serial_sequence Strangeness/Unreliable?
Дата
Msg-id 03620B7E-BB83-45F1-B157-2939E51B31CA@bignose.ca
обсуждение исходный текст
Ответ на Re: pg_get_serial_sequence Strangeness/Unreliable?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_get_serial_sequence Strangeness/Unreliable?
Список pgsql-general
On 25-Nov-08, at 10:44 AM, Tom Lane wrote:

> Jeff MacDonald <oss@bignose.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?


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: case when evaluating else condition anyway?
Следующее
От: Jeff MacDonald
Дата:
Сообщение: Re: pg_get_serial_sequence Strangeness/Unreliable?