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

On Tue, Apr 7, 2015 at 12:06 PM, Antoine Goutenoir <antoine(at)goutenoir(dot)com>
wrote:

> On Tue, Apr 7, 2015 at 5:02 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:
>
>> 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;
>>
>
> Oh, I created (actually, Doctrine created) those with :
>
> CREATE TABLE Article (id INT NOT NULL, name VARCHAR(16) NOT NULL, PRIMARY
> KEY(id));
> CREATE SEQUENCE Article_id_seq INCREMENT BY 1 MINVALUE 1 START 1;
>
> Instead of :
>
> CREATE SEQUENCE Article_id_seq INCREMENT BY 1 MINVALUE 1 START 1 OWNED BY
> Article.id;
>
>
​You seem to be missing something here because the reported Doctrine code
does nothing to change the Article.id field to use the sequence.
Typically, you would do:

CREATE TABLE Article (id serial)

And the resultant column definition would include:

[...] id integer DEFAULT ​

​nextval('sequence_name_here')​ [...]

​That particular code doesn't directly impact "Ownership"​ though, which is
strictly (I think) the mechanism by which RESTART works.

David J.