Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 89F422E0032 for ; Fri, 23 Nov 2007 06:38:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 22348-04-4 for ; Fri, 23 Nov 2007 06:38:22 -0400 (AST) Received: from smtp-01.arnet.com.ar (smtp-01.arnet.com.ar [200.45.191.24]) by postgresql.org (Postfix) with SMTP id 263DD2E0057 for ; Fri, 23 Nov 2007 06:38:21 -0400 (AST) Received: (qmail 1309 invoked from network); 23 Nov 2007 10:38:19 -0000 Received: from unknown (HELO mail.marquesminen.com.ar) (190.31.63.34) by 0 with SMTP; 23 Nov 2007 10:38:19 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.marquesminen.com.ar (Postfix) with ESMTP id 68F49284FD; Fri, 23 Nov 2007 07:38:18 -0300 (ART) X-Virus-Scanned: amavisd-new at example.com Received: from mail.marquesminen.com.ar ([127.0.0.1]) by localhost (linus.marques [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 89eTQQrjz6V0; Fri, 23 Nov 2007 07:38:15 -0300 (ART) Received: from [192.168.0.5] (dagobah.marques [192.168.0.5]) by mail.marquesminen.com.ar (Postfix) with ESMTP id B047B282DF; Fri, 23 Nov 2007 07:38:15 -0300 (ART) Message-ID: <4746AD64.8090209@marquesminen.com.ar> Date: Fri, 23 Nov 2007 07:37:24 -0300 From: Martin Marques User-Agent: Thunderbird 2.0.0.5 (X11/20070727) MIME-Version: 1.0 To: Tom Lane CC: =?UTF-8?B?Um9kcmlnbyBEZSBMZcOzbg==?= , PostgreSQL SQL List Subject: Re: PL argument max size, and doubt References: <4744313C.40107@marquesminen.com.ar> <47446F13.3090003@marquesminen.com.ar> <14547.1195668326@sss.pgh.pa.us> <4745F67B.7050800@marquesminen.com.ar> <23159.1195800021@sss.pgh.pa.us> In-Reply-To: <23159.1195800021@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/125 X-Sequence-Number: 29653 Tom Lane escribió: > Martin Marques writes: >> Tom Lane escribió: >>> Martin Marques 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