X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4A65232A704 for ; Thu, 21 Oct 2004 20:40:24 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38935-03 for ; Thu, 21 Oct 2004 19:40:20 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D3E7432A923 for ; Thu, 21 Oct 2004 20:40:16 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9LJeEvw022592; Thu, 21 Oct 2004 15:40:14 -0400 (EDT) To: "Uwe C. Schroeder" Cc: pgsql-admin@postgresql.org Subject: Re: psql enhancement idea In-reply-to: <200410211205.09350.uwe@oss4u.com> References: <200410211205.09350.uwe@oss4u.com> Comments: In-reply-to "Uwe C. Schroeder" message dated "Thu, 21 Oct 2004 12:05:09 -0700" Date: Thu, 21 Oct 2004 15:40:14 -0400 Message-ID: <22591.1098387614@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=DOMAIN_4U2 X-Spam-Level: X-Archive-Number: 200410/286 X-Sequence-Number: 15279 "Uwe C. Schroeder" writes: > I'm just doing a load of database transfers using pg_dump. Because I changed > the schema of quite some tables I have to dump full column inserts. I don't think that conclusion follows from that premise. In recent pg_dump versions (any that use a column list with COPY, which I think is 7.3 or later) there is no fundamental disadvantage to using COPY; it should be semantically equivalent to INSERT-with-column-list commands. The only reason I can see for using the INSERT option anymore is if you think that some of the row insertions might fail, and you don't want that to stop the load altogether. If that's what you want, then you'd certainly not want to wrap the load in BEGIN/END, so there doesn't seem to be much point in adding an option to do it. regards, tom lane