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

From Alexey Bashtanov
Subject Re: proposal: plpgsql pragma statement
Date
Msg-id 228f585d-6fec-fa58-9496-580858c72186@imap.cc
Whole thread Raw
In response to proposal: plpgsql pragma statement  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: plpgsql pragma statement  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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


pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [PROPOSAL]a new data type 'bytea' for ECPG
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: plpgsql pragma statement