Re: proposal: plpgsql pragma statement

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: plpgsql pragma statement
Date: 2018-12-05 11:42:54
Message-ID: 228f585d-6fec-fa58-9496-580858c72186@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Best regards,
  Alexey

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2018-12-05 13:17:48 Re: proposal: plpgsql pragma statement
Previous Message Michael Meskes 2018-12-05 11:24:28 Re: [PROPOSAL]a new data type 'bytea' for ECPG