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-01 17:59:28
Message-ID: CADkLM=dbaQ-74PC_ovPyBNQfxOYaCezcDyTjZJTXJgAumJc8=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Oct 24, 2022 at 5:54 AM Peter Eisentraut <
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.

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?

In response to

Responses

Browse pgsql-hackers by date

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