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

From Alexey Bashtanov
Subject Re: proposal: plpgsql pragma statement
Date
Msg-id bc1ff0f8-b5e9-be05-30f3-65f52346ca8e@imap.cc
Whole thread Raw
In response to Re: proposal: plpgsql pragma statement  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: plpgsql pragma statement
Re: proposal: plpgsql pragma statement
List pgsql-hackers


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.

Best,
  Alex

pgsql-hackers by date:

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