On Fri, Jan 20, 2017 at 2:34 AM, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Fri, Jan 20, 2017 at 12:49 AM, Robert Haas <robertmh...@gmail.com> wrote: >> On Wed, Jan 18, 2017 at 12:42 PM, Robert Haas <robertmh...@gmail.com> wrote: >>> Problems 2-4 actually have to do with a DestReceiver of type >>> DestRemote really, really wanting to have an associated Portal and >>> database connection, so one approach is to create a stripped-down >>> DestReceiver that doesn't care about those things and then passing >>> that to GetPGVariable. >> >> I tried that and it worked out pretty well, so I'm inclined to go with >> this approach. Proposed patches attached. 0001 adds the new >> DestReceiver type, and 0002 is a revised patch to implement the SHOW >> command itself. >> >> Thoughts, comments? > > This looks like a sensible approach to me. DestRemoteSimple could be > useful for background workers that are not connected to a database as > well. Isn't there a problem with PGC_REAL parameters?
No, because the output of SHOW is always of type text, regardless of the type of the GUC. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers