Re: BUG #12991: RESTART IDENTITY is not doing anything - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #12991: RESTART IDENTITY is not doing anything
Date
Msg-id 20150407150234.GE12291@awork2.anarazel.de
Whole thread Raw
In response to BUG #12991: RESTART IDENTITY is not doing anything  (antoine@goutenoir.com)
Responses Re: BUG #12991: RESTART IDENTITY is not doing anything  (Antoine Goutenoir <antoine@goutenoir.com>)
List 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 by date:

Previous
From: Kingter Wang
Date:
Subject: pg_rewind TAP tests won't run in 'remote' mode
Next
From: mymailbox24@gmail.com
Date:
Subject: BUG #12992: Failure to start: too many private dirs demanded