Re: changing sequence in serial field

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: changing sequence in serial field
Дата
Msg-id 23310.1215186596@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: changing sequence in serial field  (Julius Tuskenis <julius@nsoft.lt>)
Список pgsql-admin
Julius Tuskenis <julius@nsoft.lt> writes:
> b_prekes_br_kodas_pbk_id_seq1 was created automatically creating serial field and is in some way connected to it.
Thatswhy I get error saying "...column pbk_id requires it." Any way I can't find a way to find and alter this
dependency.

It's a row in pg_depend.  In 8.2 and up you can create/delete the row
with ALTER SEQUENCE OWNED BY, but in earlier releases you'd have to do
it manually.

            regards, tom lane

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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: how to get fy info from the parent table
Следующее
От: Jessica Richard
Дата:
Сообщение: How many table scans in a delete...