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

From Pavel Stehule
Subject Re: proposal: plpgsql pragma statement
Date
Msg-id CAFj8pRD2mJPYtAhpuWtmpgHX2J4FxMXVRXykUN5MnA2wrg7VvQ@mail.gmail.com
Whole thread Raw
In response to Re: proposal: plpgsql pragma statement  (Alexey Bashtanov <bashtanov@imap.cc>)
Responses Re: proposal: plpgsql pragma statement  (Alexey Bashtanov <bashtanov@imap.cc>)
List pgsql-hackers
Hi

st 5. 12. 2018 v 12:42 odesílatel Alexey Bashtanov <bashtanov@imap.cc> napsal:
Hello Pavel,

>
> The PRAGMA statement does nothing in runtime. It works only in compile
> time, and add a pair of key, value to next non pragma statement. This
> information can be used by some plpgsql extensions.
>
> What do you think about this proposal?
>

You can use PERFORM as a workaround:

PERFORM 'PRAGMA', 'cmdtype', 'CREATE';

There's some overhead when executing, but probably not too much.

Thank you for tip, but I have not any idea, how it can work?

Regards

Pavel
 

Best regards,
   Alexey

pgsql-hackers by date:

Previous
From: Alexey Bashtanov
Date:
Subject: Re: proposal: plpgsql pragma statement
Next
From: Alexey Bashtanov
Date:
Subject: Re: proposal: plpgsql pragma statement