Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4C7DEB5DBC8 for ; Sat, 10 Sep 2011 18:24:13 -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 74469-01 for ; Sat, 10 Sep 2011 21:24:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-1.sys.kth.se (smtp-1.sys.kth.se [130.237.32.175]) by mail.postgresql.org (Postfix) with ESMTP id D5560B5DBC5 for ; Sat, 10 Sep 2011 18:24:06 -0300 (ADT) Received: from mailscan-1.sys.kth.se (mailscan-1.sys.kth.se [130.237.32.91]) by smtp-1.sys.kth.se (Postfix) with ESMTP id 0E20B156333 for ; Sat, 10 Sep 2011 23:24:06 +0200 (CEST) X-Virus-Scanned: by amavisd-new at kth.se Received: from smtp-1.sys.kth.se ([130.237.32.175]) by mailscan-1.sys.kth.se (mailscan-1.sys.kth.se [130.237.32.91]) (amavisd-new, port 10024) with LMTP id pCsbG8NDofQp for ; Sat, 10 Sep 2011 23:24:04 +0200 (CEST) Received: from EXHUB1.ug.kth.se (exhub1.ug.kth.se [130.237.32.134]) by smtp-1.sys.kth.se (Postfix) with ESMTP id D8783156AEE for ; Sat, 10 Sep 2011 23:24:04 +0200 (CEST) Received: from EXDB3.ug.kth.se ([169.254.3.208]) by EXHUB1.ug.kth.se ([130.237.32.134]) with mapi id 14.01.0289.001; Sat, 10 Sep 2011 23:22:33 +0200 From: Mandana Mokhtary To: "pgsql-sql@postgresql.org" Subject: FW: Hi Thread-Topic: Hi Thread-Index: Acxv/58an+OKVrIYQ6SMCp8dIjiOnQAAB1f7 Date: Sat, 10 Sep 2011 21:22:32 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-GB, sv-SE, en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [213.103.192.141] Content-Type: multipart/alternative; boundary="_000_A9344FE6ED34A04F9BF550E6EAAAA3171061193DEXDB3ugkthse_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.403 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201109/19 X-Sequence-Number: 35819 --_000_A9344FE6ED34A04F9BF550E6EAAAA3171061193DEXDB3ugkthse_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ________________________________ 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. at fisrt, the name of the shapfiles have some Swedish alphabet which i chan= ged it to latin I would appreciate any help. Regards, Mandana --_000_A9344FE6ED34A04F9BF550E6EAAAA3171061193DEXDB3ugkthse_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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.

at fisrt, the name of the shapfiles have some Swedish alphabet which i chan= ged it to latin

I would appreciate any help.

Regards, Mandana

--_000_A9344FE6ED34A04F9BF550E6EAAAA3171061193DEXDB3ugkthse_--