Re: [PATCH] SET search_path += octopus - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] SET search_path += octopus
Date
Msg-id 655762.1603217772@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] SET search_path += octopus  (Andres Freund <andres@anarazel.de>)
Responses Re: [PATCH] SET search_path += octopus  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> Given that this is just SQL level, I don't see why we'd need a special
> type of language here. You can just use DO etc.

I'd make that point against the whole proposal.  There's nothing here that
can't be done with current_setting() + set_config().  I'm pretty dubious
about layering extra functionality into such a fundamental utility command
as SET; and the fact that we've gone twenty-odd years without similar
previous proposals doesn't speak well for it being really useful.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [PATCH] SET search_path += octopus
Next
From: Isaac Morland
Date:
Subject: Re: [PATCH] SET search_path += octopus