Re: BUG #15238: Sequence owner not updated when owning table isforeign - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #15238: Sequence owner not updated when owning table isforeign
Date
Msg-id 20180615034001.lgsbilj7pqczofj7@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #15238: Sequence owner not updated when owning table isforeign  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: BUG #15238: Sequence owner not updated when owning table isforeign  (Christoph Berg <christoph.berg@credativ.de>)
List pgsql-bugs
On 2018-Jun-14, Peter Eisentraut wrote:

> Also, can partitioned tables have serial columns?  Are there more omissions?

You're right, this is wrong for partitioned tables too.

create table part (a serial) partition by range (a);
create table part2 partition of part for values from (1) to (1000);
create user foo;
alter table part owner to foo;

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #15238: Sequence owner not updated when owning table isforeign
Next
From: Amit Langote
Date:
Subject: Re: BUG #15238: Sequence owner not updated when owning table isforeign