Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2FA9EB5DBE1 for ; Sun, 11 Sep 2011 22:31:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 22330-02 for ; Mon, 12 Sep 2011 01:31:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com [209.85.220.174]) by mail.postgresql.org (Postfix) with ESMTP id 3A2BFB5DBC5 for ; Sun, 11 Sep 2011 22:31:49 -0300 (ADT) Received: by vxi9 with SMTP id 9so2404266vxi.19 for ; Sun, 11 Sep 2011 18:31:49 -0700 (PDT) Received: by 10.52.173.230 with SMTP id bn6mr415686vdc.522.1315791109192; Sun, 11 Sep 2011 18:31:49 -0700 (PDT) Received: from [10.1.1.6] (124-148-242-247.dyn.iinet.net.au [124.148.242.247]) by mx.google.com with ESMTPS id ig8sm9419331vdb.3.2011.09.11.18.31.46 (version=SSLv3 cipher=OTHER); Sun, 11 Sep 2011 18:31:48 -0700 (PDT) Message-ID: <4E6D60F7.5080101@ringerc.id.au> Date: Mon, 12 Sep 2011 09:31:35 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2 MIME-Version: 1.0 To: Mandana Mokhtary CC: "pgsql-sql@postgresql.org" Subject: Re: FW: Hi References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201109/22 X-Sequence-Number: 35822 On 11/09/2011 5:22 AM, Mandana Mokhtary wrote: > > ------------------------------------------------------------------------ > *From:* Mandana Mokhtary > *Sent:* 10 September 2011 23:21 > *To:* pgsql-sql-owner@postgresql.org > *Subject:* Hi > > Hi All > I tried to import shapfile into postgres using this comand: > > pgsql -c -s 3006 -W LATIN1 c:/...... |psql _U postgres (database name) > > I could import some but not all. > I got this error that I do not have any idea about it: > > current transaction is aborted, commands ignored until end of > transactions block. There was another error before that one, look for it. You want the FIRST error. -- Craig Ringer