Re: BUG #12991: RESTART IDENTITY is not doing anything

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: BUG #12991: RESTART IDENTITY is not doing anything
Дата
Msg-id 20150407150234.GE12291@awork2.anarazel.de
обсуждение исходный текст
Ответ на BUG #12991: RESTART IDENTITY is not doing anything  (antoine@goutenoir.com)
Ответы Re: BUG #12991: RESTART IDENTITY is not doing anything  (Antoine Goutenoir <antoine@goutenoir.com>)
Список pgsql-bugs
Дерево обсуждения 
On 2015-04-07 04:07:56 +0000, antoine@goutenoir.com wrote:
> Example, say Article has `id` as primary key :

How is that table defined? Restart identity will only work if the
sequence is 'owned' by the id column. That happens if you either create
it by specifying 'serial' as the column type, or if you explicitly use
ALTER SEQUENCE ... OWNED BY table.col;

Greetings,

Andres Freund

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

Предыдущее
От: Kingter Wang
Дата:
Сообщение: pg_rewind TAP tests won't run in 'remote' mode
Следующее
От: mymailbox24@gmail.com
Дата:
Сообщение: BUG #12992: Failure to start: too many private dirs demanded