Re: Feature request: include script file into function body (better syntax) - Mailing list pgsql-bugs

From Jasen Betts
Subject Re: Feature request: include script file into function body (better syntax)
Date
Msg-id iie5lg$b91$3@reversiblemaps.ath.cx
Whole thread Raw
In response to Feature request: include script file into function body  (Steve White <swhite@aip.de>)
List pgsql-bugs
On 2011-02-01, Steve White <swhite@aip.de> wrote:
> Hi Tom,
>
> I already agreed to Kevin's proposed syntax, and it is better than
> my suggestion, but mine isn't quite as crazy as you make out.
>
> On  1.02.11, Tom Lane wrote:
>> Steve White <swhite@aip.de> writes:
>> > Try this instead:
>>
>> > ================================================
>> > CREATE OR REPLACE FUNCTION
>> >         myfunc( ... )
>> > RETURNS VOID AS '#PGSQL_IMPORT filename' LANGUAGE PLPYTHONU;
>> > ================================================
>>
>> I think having psql decide that string literals mean something other
>> than their face value is Right Out --- it would bite you on the rear
>> just when you least expect it.
>
> Interesting idea... but why would psql make this decision?
> Did somebody suggest that off-line?
>
> I said that the script interpreter might do this...

if the interpreter does it you stop ordinary users from using it
for security reasons,

--
⚂⚃ 100% natural

pgsql-bugs by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Feature request: include script file into function body
Next
From: Matt Zinicola
Date:
Subject: Re: BUG #5862: Postgres dumps core upon a connection attempt