Re: pg_dump: Refactor code that constructs ALTER ... OWNER TO commands - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: pg_dump: Refactor code that constructs ALTER ... OWNER TO commands
Date
Msg-id CADkLM=dbaQ-74PC_ovPyBNQfxOYaCezcDyTjZJTXJgAumJc8=g@mail.gmail.com
Whole thread Raw
In response to pg_dump: Refactor code that constructs ALTER ... OWNER TO commands  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: pg_dump: Refactor code that constructs ALTER ... OWNER TO commands
List pgsql-hackers
On Mon, Oct 24, 2022 at 5:54 AM Peter Eisentraut <peter.eisentraut@enterprisedb.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.

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?


 

pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert
Next
From: Andres Freund
Date:
Subject: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local