Re: BUG #15238: Sequence owner not updated when owning table isforeign

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема Re: BUG #15238: Sequence owner not updated when owning table isforeign
Дата
Msg-id 20180925120634.GB19816@msg.credativ.de
обсуждение исходный текст
Ответ на Re: BUG #15238: Sequence owner not updated when owning table isforeign  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: BUG #15238: Sequence owner not updated when owning table isforeign
Список pgsql-bugs
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


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Maxim Boguk
Дата:
Сообщение: Re: BUG #15160: planner overestimates number of rows in join whenthere are more than 200 rows coming from CTE
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15400: perl error