Tom Lane escribió:
Martin Marques <[EMAIL PROTECTED]> writes:
Tom Lane escribió:
Martin Marques <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
