Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 170669F9DA9 for ; Tue, 18 Sep 2007 12:05:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 40197-03-4 for ; Tue, 18 Sep 2007 12:04:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id B58B89FA26C for ; Tue, 18 Sep 2007 12:04:53 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so109567ugf for ; Tue, 18 Sep 2007 08:04:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=MPoivSYJI9g6T66DOo9DySJEumWYGC3ugBrt9V2tov0=; b=OnAdJvE4pEuCHMlbfLp3ZSMZYp9xW6TSEPtXdK90DUziSNm1957KobQKXpkEjzOLIWjkSqxCnsK3o0SzhakNW7Gg81nzRRm2vCwaaAzWTLvAIOkflZOyMaYLTdBbra3aVZHMHQAPEMc6ynxgJ/i9hcBic8ImVpdgOo5QZ1Vj7Sg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=CGSMqu/NCdJSbiB3mvB/OTh/p4lJB1TnEbK1V2J2jp7dtaIotc5lANMJAnL7QK2P3MFiAWa36MYEupDXektImGghyjWyStqExD0DG8DAg7R5z0wItnI1xhTTfOdhHmphhk0dxGc4HtxAsmLHvAcdleiHg0V+D6DLbQZT03KcjPw= Received: by 10.66.250.9 with SMTP id x9mr806747ugh.1190127892298; Tue, 18 Sep 2007 08:04:52 -0700 (PDT) Received: by 10.66.220.7 with HTTP; Tue, 18 Sep 2007 08:04:52 -0700 (PDT) Message-ID: Date: Tue, 18 Sep 2007 10:04:52 -0500 From: "Scott Marlowe" To: "soni de" Subject: Re: Regarding COPY command from Postgres 8.2.0 Cc: "Ansgar -59cobalt- Wiechers" , pgsql-performance@postgresql.org In-Reply-To: <9f2e40a90709172131g26d681a1pf030910a1793f791@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <9f2e40a90709140321l11e6cdb5g91d8f8bf0a43fd01@mail.gmail.com> <20070914120321.GA2615@mail.planetcobalt.net> <9f2e40a90709172131g26d681a1pf030910a1793f791@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/309 X-Sequence-Number: 26854 On 9/17/07, soni de wrote: > We have upgraded postgres from 7.2.4 to 8.2.0. > We have program which executes COPY command and our new database is changed > having some extra columns in some tables. > Because of this, COPY commands are failing. > So, we wanted the option to COPY the data without specifying column names. Can't you just edit the import to have the newer 8.2.x syntax of COPY table (field1, field2, field3, field4) FROM stdin; ??? And please tell me you aren't running 8.2.0, but 8.2.4 or now that it just came out, 8.2.5. Those minor point releases contain a lot of bug fixes, and you're just asking for trouble by running a .0 release.