Re: PL argument max size, and doubt - Mailing list pgsql-sql

From Tom Lane
Subject Re: PL argument max size, and doubt
Date
Msg-id 23159.1195800021@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL argument max size, and doubt  (Martin Marques <martin@marquesminen.com.ar>)
Responses Re: PL argument max size, and doubt  (Martin Marques <martin@marquesminen.com.ar>)
List pgsql-sql
Martin Marques <martin@marquesminen.com.ar> writes:
> Tom Lane escribió:
>> Martin Marques <martin@marquesminen.com.ar> writes:
>>> I have always heard that modification queries should be EXECUTED in PL. 
>>> AFAICR.
>> 
>> Run far away from whatever source gave you that advice...

> Sorry, it was with DDL commands.

That's not much better ;-).  DDL commands don't have plans, so there's
not anything that could be invalidated.  I don't see any reason to use
an EXECUTE unless there's an actual textual change in the command you
need to execute.
        regards, tom lane


pgsql-sql by date:

Previous
From: Martin Marques
Date:
Subject: Re: PL argument max size, and doubt
Next
From: "Sabin Coanda"
Date:
Subject: Aleatory exception