proposal: plpgsql pragma statement - Mailing list pgsql-hackers

From Pavel Stehule
Subject proposal: plpgsql pragma statement
Date
Msg-id CAFj8pRALJQnTbvc-Vt-5Lni8C8CtRS0S249hqN9=so+6bmhyqQ@mail.gmail.com
Whole thread Raw
Responses Re: proposal: plpgsql pragma statement  (Alexey Bashtanov <bashtanov@imap.cc>)
Re: proposal: plpgsql pragma statement  (Dmitry Igrishin <dmitigr@gmail.com>)
Re: proposal: plpgsql pragma statement  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Hi


It is working well, but because it does static analyse only, sometimes it can produces false alarms or it should to stop a analyse, because there are not necessary data.


I see one possible solution in introduction of pragma statement with syntax:

  PRAGMA keyword [content to semicolon];

The pragma has a relation to following statement. So the issue 36 can be solved by pragma

PRAGMA cmdtype CREATE;
EXECUTE format('CREATE TABLE xxx ...

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?

Regards

Pavel

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock
Next
From: Alvaro Herrera
Date:
Subject: Re: psql display of foreign keys