Re: proposal: plpgsql pragma statement - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: proposal: plpgsql pragma statement
Date
Msg-id CADUqk8WGKgaNCoERyDnu8C1EKT_wUMxDrvO9Xv5U+WEippC6pA@mail.gmail.com
Whole thread Raw
In response to Re: proposal: plpgsql pragma statement  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Ahh. Gotcha. Makes sense.

On Thu, Dec 6, 2018 at 11:57 AM Robert Haas <robertmhaas@gmail.com> wrote:
On Thu, Dec 6, 2018 at 11:39 AM Jonah H. Harris <jonah.harris@gmail.com> wrote:
> IIRC, PRAGMA in Ada was compile-time only. How would you foresee it affecting runtime?

Well, I don't know what Ada does with PRAGMA exactly, but look at
these examples from Oracle:

http://psoug.org/definition/pragma.htm

You wouldn't *execute* those at runtime, but at least for some of
them, the runtime behavior would depend on whether or not they were
specified.  It certainly seems possible that we might want to have
similar things.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Jonah H. Harris

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PATCH] Opclass parameters
Next
From: Tom Lane
Date:
Subject: Re: slow queries over information schema.tables