Re: regdatabase - Mailing list pgsql-hackers

From Tom Lane
Subject Re: regdatabase
Date
Msg-id 3244324.1746590594@sss.pgh.pa.us
Whole thread Raw
In response to regdatabase  (Nathan Bossart <nathandbossart@gmail.com>)
List pgsql-hackers
Nathan Bossart <nathandbossart@gmail.com> writes:
> * Would anyone object if I put together some patches to add regdatabase?

The original concept of the reg* types was to implement lookups for
cases that are more complicated than "(SELECT oid FROM pg_foo WHERE
fooname = 'whatever')".  As an example, regprocedure would be
somewhere between seriously painful and impossible to do by hand.
But any potentially-schema-qualified object name is complicated
enough to justify having a reg* type, in the original vision.

However, we've broken that of late with regnamespace and regrole.
regdatabase would be of exactly the same complexity as those
cases.  So I don't see a reason to object, if you think it's
worth the trouble.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: disabled SSL log_like tests
Next
From: Tom Lane
Date:
Subject: Re: disabled SSL log_like tests