On Wed, May 31, 2017 at 10:49 PM, Dilip Kumar <dilipbal...@gmail.com> wrote: > On Wed, May 31, 2017 at 2:20 PM, Michael Paquier > <michael.paqu...@gmail.com> wrote: >> Yeah, see 0e0f43d6 for example. A simple fix is to look at >> IsUnderPostmaster when creating, altering or dropping a subscription >> in subscriptioncmds.c. > > Yeah, below patch fixes that.
Thanks, this looks correct to me at quick glance. + if (!IsUnderPostmaster) + ereport(FATAL, + (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), + errmsg("subscription commands are not supported by single-user servers"))); The messages could be more detailed, like directly the operation of CREATE/ALTER/DROP SUBCRIPTION in each error message. But that's a nit. -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers