Re: BUG #15238: Sequence owner not updated when owning table is foreign
Re: Peter Eisentraut 2018-06-15 <e3cf9eb8-add9-f523-b3f8-de657e091a14@2ndquadrant.com>
On 6/12/18 09:21, PG Bug reporting form wrote:
If a foreign table has a sequence attached (e.g. if the foreign table has a
"serial" column), and the foreign table owner is updated, the sequence owner
is not updated, leading to errors on restore:Yup, it only recurses to sequences for regular tables and materialized
views. I suggest to remove the relkind check altogether. See attached
patch.
Did that ever get applied? I can't find it in the git log.
Christoph
--
Senior Berater, Tel.: +49 2166 9901 187
credativ GmbH, HRB M�nchengladbach 12080, USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 M�nchengladbach
Gesch�ftsf�hrung: Dr. Michael Meskes, J�rg Folz, Sascha Heuer
Datenschutzerkl�rung: https://www.credativ.de/datenschutz
Import Notes
Reply to msg id not found: 4163c7cb-bc8f-3767-21e7-e9dee69df04c@lab.ntt.co.jp20180615034001.lgsbilj7pqczofj7@alvherre.pgsqle3cf9eb8-add9-f523-b3f8-de657e091a14@2ndquadrant.com
On Tue, Sep 25, 2018 at 02:06:35PM +0200, Christoph Berg wrote:
Did that ever get applied? I can't find it in the git log.
Not that I can see. I have added an entry for old bugs on the v11 list
of open items. Peter, could you finish wrapping it or do you need some
help?
--
Michael
On 26/09/2018 02:09, Michael Paquier wrote:
On Tue, Sep 25, 2018 at 02:06:35PM +0200, Christoph Berg wrote:
Did that ever get applied? I can't find it in the git log.
Not that I can see. I have added an entry for old bugs on the v11 list
of open items. Peter, could you finish wrapping it or do you need some
help?
Committed and backpatched now.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On Wed, Sep 26, 2018 at 08:53:44PM +0200, Peter Eisentraut wrote:
Committed and backpatched now.
Thanks, Peter.
--
Michael
Michael Paquier <michael@paquier.xyz> writes:
On Wed, Sep 26, 2018 at 08:53:44PM +0200, Peter Eisentraut wrote:
Committed and backpatched now.
Thanks, Peter.
Should the entry on the v11 Open Items list be closed now?
regards, tom lane