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

From Martin Marques
Subject Re: PL argument max size, and doubt
Date
Msg-id 4746AD64.8090209@marquesminen.com.ar
Whole thread Raw
In response to Re: PL argument max size, and doubt  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom Lane escribió:
> 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.

Well, actually....

http://archives.postgresql.org/pgsql-sql/2007-02/msg00214.php

See the follow-ups


pgsql-sql by date:

Previous
From: "Sabin Coanda"
Date:
Subject: Re: Aleatory exception
Next
From: "Sabin Coanda"
Date:
Subject: Re: Aleatory exception - found cause