Re: pg_dump: Refactor code that constructs ALTER ... OWNER TO commands

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump: Refactor code that constructs ALTER ... OWNER TO commands
Date: 2022-11-05 17:39:09
Message-ID: CADkLM=euGi8YNoHnYyXmbaD+FUiEUhe8WauMWScs_TbEawktAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 2, 2022 at 5:30 PM Peter Eisentraut <
peter(dot)eisentraut(at)enterprisedb(dot)com> wrote:

> On 01.11.22 13:59, Corey Huinker wrote:
> > On Mon, Oct 24, 2022 at 5:54 AM Peter Eisentraut
> > <peter(dot)eisentraut(at)enterprisedb(dot)com
> > <mailto:peter(dot)eisentraut(at)enterprisedb(dot)com>> wrote:
> >
> > Avoid having to list all the possible object types twice. Instead,
> > only
> > _getObjectDescription() needs to know about specific object types.
> It
> > communicates back to _printTocEntry() whether an owner is to be set.
> >
> > In passing, remove the logic to use ALTER TABLE to set the owner of
> > views and sequences. This is no longer necessary. Furthermore, if
> > pg_dump doesn't recognize the object type, this is now a fatal error,
> > not a warning.
> >
> >
> > Makes sense, passes all tests.
>
> Committed.
>
> > It's clearly out of scope for this very focused patch, but would it make
> > sense for the TocEntry struct to be populated with an type enumeration
> > integer as well as the type string to make for clearer and faster
> > sifting later?
>
> That could be better, but wouldn't that mean a change of the format of
> pg_dump archives?
>

Sorry for the confusion, I was thinking strictly of the in memory
representation after it is extracted from the dictionary.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-11-05 17:45:59 Re: [PATCH] ALTER TABLE ... SET STORAGE default
Previous Message Julien Rouhaud 2022-11-05 17:25:09 Re: Schema variables - new implementation for Postgres 15