| From: | Martin Marques <martin(at)marquesminen(dot)com(dot)ar> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 10:37:24 |
| Message-ID: | 4746AD64.8090209@marquesminen.com.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Tom Lane escribió:
> 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.
Well, actually....
http://archives.postgresql.org/pgsql-sql/2007-02/msg00214.php
See the follow-ups
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sabin Coanda | 2007-11-23 11:42:50 | Re: Aleatory exception - found cause |
| Previous Message | Sabin Coanda | 2007-11-23 09:26:51 | Re: Aleatory exception |