Re: PL argument max size, and doubt

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Marques <martin(at)marquesminen(dot)com(dot)ar>
Cc: Rodrigo De León <rdeleonp(at)gmail(dot)com>, PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: PL argument max size, and doubt
Date: 2007-11-23 06:40:21
Message-ID: 23159.1195800021@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Martin Marques <martin(at)marquesminen(dot)com(dot)ar> writes:
> Tom Lane escribi:
>> Martin Marques <martin(at)marquesminen(dot)com(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sabin Coanda 2007-11-23 09:23:15 Aleatory exception
Previous Message Martin Marques 2007-11-22 21:36:59 Re: PL argument max size, and doubt