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

From: Andres Freund <andres(at)anarazel(dot)de>
To: antoine(at)goutenoir(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12991: RESTART IDENTITY is not doing anything
Date: 2015-04-07 15:02:34
Message-ID: 20150407150234.GE12291@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2015-04-07 04:07:56 +0000, antoine(at)goutenoir(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message mymailbox24 2015-04-07 16:44:03 BUG #12992: Failure to start: too many private dirs demanded
Previous Message kingter wang 2015-04-07 09:07:39 Re: pg_rewind test could not run in 'remote' mode