Re: Cannot convert partitioned table to a view

On 10/7/22 15:27, Kouber Saparev wrote: На чт, 6.10.2022 г. в 17:02 ч. Tom Lane написа: That is an ancient backwards-compatibility hack that you should not rely on, and most certainly shouldn't try to make use of from user code.  It exists because very ancient versions of pg_dump di

Re: pg_restore creates public schema?

On 10/7/22 15:31, Alban Hertroys wrote: On 6 Oct 2022, at 22:52, Ron wrote: On 10/6/22 12:46, Christophe Pettus wrote: On Oct 6, 2022, at 10:44, Ron wrote: Sadly, that VM doesn't have nearly enough disk space to hold the backup folder. Use file mode, and stream the output via scp/ssh to a di

Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE

On Fri, Oct 7, 2022 at 5:16 PM Bryn Llewellyn wrote: > david.g.johns...@gmail.com wrote: > > b...@yugabyte.com wrote: > > (3) The PG doc on quote_ident says this in large friendly letters: > > Quotes are added only if necessary… > > > Notice "only". I now know that this is very much not the case.

Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE

> On Oct 7, 2022, at 17:16, Bryn Llewellyn wrote: > What does "make for a good bug report" mean, David? Well, first of all, brevity. :-) > Is it: > > (1.1) You, David, or somebody else who has been officially recognized as a PG > Contributor (https://www.postgresql.org/community/contributor

Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE

On 10/7/22 17:16, Bryn Llewellyn wrote: david.g.johns...@gmail.com wrote: b...@yugabyte.com  wrote: (3) The PG doc on quote_ident says this in large friendly letters: Quotes are added only if necessary… Notice "only". I now know

Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE

> david.g.johns...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> (3) The PG doc on quote_ident says this in large friendly letters: >> >>> Quotes are added only if necessary… >> >> Notice "only". I now know that this is very much not the case. You can >> compose an effectively unlimited

Re: pg_restore creates public schema?

On 10/7/22 10:11, Ron wrote: And the RHEL8 server can't talk to the RHEL6 server? Give me /some/ credit for thinking of that first... Also give me credit for not assuming what you have done and instead confirming it. I have been in involved in or followed multiple threads on this list wher

Re: Cannot convert partitioned table to a view

Kouber Saparev writes: > Excuse me, I didn't understand what was about to be ripped out then. The fact that creating a _RETURN rule for a table causes it to be changed into a view. That's ugly and arguably dangerous. regards, tom lane

Re: Cannot convert partitioned table to a view

> > No ... what has that got to do with this? We don't particularly care > what a foreign table is referencing, as long as it acts like a table. > Thank you. > We're more likely to rip it out as no-longer-needed than to expand what it > does. Excuse me, I didn't understand what was about to

Re: Cannot convert partitioned table to a view

Kouber Saparev writes: > Does that mean that the ability to point remote partitions to views (on the > remote side) will be forbidden in the future? No ... what has that got to do with this? We don't particularly care what a foreign table is referencing, as long as it acts like a table.

Re: pg_restore creates public schema?

> On 6 Oct 2022, at 22:52, Ron wrote: > > On 10/6/22 12:46, Christophe Pettus wrote: >>> On Oct 6, 2022, at 10:44, Ron wrote: >>> Sadly, that VM doesn't have nearly enough disk space to hold the backup >>> folder. >> Use file mode, and stream the output via scp/ssh to a different machine? >

Re: Cannot convert partitioned table to a view

На чт, 6.10.2022 г. в 17:02 ч. Tom Lane написа: > That is an ancient backwards-compatibility hack that you should not > rely on, and most certainly shouldn't try to make use of from user > code. It exists because very ancient versions of pg_dump didn't > know how to dump views as views. We're m

Re: pg_restore creates public schema?

On 10/6/22 17:01, Adrian Klaver wrote: On 10/6/22 2:03 PM, Ron wrote: On 10/6/22 14:35, Adrian Klaver wrote: On 10/6/22 09:46, Ron wrote: On 10/6/22 10:20, Tom Lane wrote: Because installing new software on production servers requires hurdles (Service Now change ticket approved by the app