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

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


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


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?


Well, I thought you were for a comment-like thing that remains there when compiled and can act as a hint for your static analysis extension.
Surely this PERFORM won't impose any hints on the following statement itself.
But maybe your extension could read the PERFORM statement preceding it and treat it as an annotation hint for the following statement.

PERFORM is +/- SELECT, so if I use PERFORM, I have to modify this statement.



Best,
  Alex

pgsql-hackers by date:

Previous
From: Pavel Luzanov
Date:
Subject: Re: proposal: plpgsql pragma statement
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: plpgsql pragma statement