X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6E82E4764A7 for ; Thu, 8 May 2003 07:15:11 -0400 (EDT) Received: from mail.deltav.hu (mail.deltav.hu [213.163.0.192]) by postgresql.org (Postfix) with ESMTP id 3F415476453 for ; Thu, 8 May 2003 07:15:10 -0400 (EDT) Received: from fejleszt2 ([213.163.10.103]) by mail.deltav.hu (Netscape Messaging Server 3.6) with SMTP id AAA6644 for ; Thu, 8 May 2003 13:15:11 +0200 Message-ID: <005501c31553$16ee7120$0a03a8c0@fejleszt2> From: "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" To: References: <010d01c314c1$3ba30950$0a03a8c0@fejleszt2> <200305072010.49526.dev@archonet.com> Subject: Re: "too clever" when creating SQL functions Date: Thu, 8 May 2003 13:15:10 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Status: No, hits=-15.9 required=5.0 tests=BAYES_20,ORIGINAL_MESSAGE,REFERENCES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/163 X-Sequence-Number: 13328 Dear Richard, I had a look at a 7.2.1 dump, but it doesn't do that thing. It simply creates triggers after all the data has been COPY-ed (i.e. at the end of the file. Only rules and sequence setvals after that. G. -- while (!asleep()) sheep++; ---------------------------- cut here ------------------------------ ----- Original Message ----- From: "Richard Huxton" Sent: Wednesday, May 07, 2003 9:10 PM You might want to look at the output of pg_dump - IIRC that disables all your triggers (fk's etc) and re-enables them at the end. Might be what you're after. -- Richard Huxton