Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 70803B5DBFC for ; Sat, 10 Sep 2011 19:04:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 14960-09 for ; Sat, 10 Sep 2011 22:04:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pz0-f42.google.com (mail-pz0-f42.google.com [209.85.210.42]) by mail.postgresql.org (Postfix) with ESMTP id C4BC6B5DC43 for ; Sat, 10 Sep 2011 19:04:14 -0300 (ADT) Received: by pzk37 with SMTP id 37so6267325pzk.15 for ; Sat, 10 Sep 2011 15:04:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=from:to:subject:date:user-agent:cc:references:in-reply-to :mime-version:content-type:content-transfer-encoding:message-id; bh=EAtyjfTbl2mcz8ZkRdtVoTMRVAEuWgtuEtysfbv1bI8=; b=CUXh2BEtuV967cZHgTcso5KD2lS3TwAOPPD6f+EXCRkXeSO3u6NUn64ROIUTVKY3J6 5+Ce1/Jbd1kmxGtQ+bFqdM3J/f/bbwPfVbwxXWBrTWxgXu3hSef4YhSuM3xTy9ErW3jY 4R70VQQ9aU7wcoLwM4GvbjevTWTUIMzteezGY= Received: by 10.68.10.40 with SMTP id f8mr2379146pbb.67.1315692254423; Sat, 10 Sep 2011 15:04:14 -0700 (PDT) Received: from tucker.localnet (c-24-17-164-54.hsd1.wa.comcast.net. [24.17.164.54]) by mx.google.com with ESMTPS id x6sm30364644pba.5.2011.09.10.15.04.11 (version=SSLv3 cipher=OTHER); Sat, 10 Sep 2011 15:04:13 -0700 (PDT) From: Adrian Klaver To: pgsql-sql@postgresql.org Subject: Re: FW: Hi Date: Sat, 10 Sep 2011 15:04:09 -0700 User-Agent: KMail/1.13.5 (Linux/2.6.32-33-generic; KDE/4.4.5; i686; ; ) Cc: Mandana Mokhtary References: In-Reply-To: MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Message-Id: <201109101504.09488.adrian.klaver@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.889 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201109/21 X-Sequence-Number: 35821 On Saturday, September 10, 2011 2:22:32 pm 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. > Means just what it says, a transaction was aborted due to error and at that point all further commands where ignored. > at fisrt, the name of the shapfiles have some Swedish alphabet which i > changed it to latin > > I would appreciate any help. The actual command string would be nice:) If the above was it then that explains the problem. First I think you are looking for psql not pgsql. Second it should be psql -U postgres ... > > Regards, Mandana -- Adrian Klaver adrian.klaver@gmail.com