| From: | Christoph Berg <christoph(dot)berg(at)credativ(dot)de> |
|---|---|
| To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #15238: Sequence owner not updated when owning table is foreign |
| Date: | 2018-09-25 12:06:35 |
| Message-ID: | 20180925120634.GB19816@msg.credativ.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Re: Peter Eisentraut 2018-06-15 <e3cf9eb8-add9-f523-b3f8-de657e091a14(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2018-09-25 12:07:23 | BUG #15400: perl error |
| Previous Message | Maxim Boguk | 2018-09-25 11:24:39 | Re: BUG #15160: planner overestimates number of rows in join when there are more than 200 rows coming from CTE |