From: Adrian Klaver <adrian.klaver@gmail.com>
To: pgsql-sql@postgresql.org
Cc: Mandana Mokhtary <mokhtary@kth.se>
Subject: Re: FW: Hi
Date: Sat, 10 Sep 2011 15:04:09 -0700
Message-ID: <201109101504.09488.adrian.klaver@gmail.com> (raw)
In-Reply-To: <A9344FE6ED34A04F9BF550E6EAAAA3171061193D@EXDB3.ug.kth.se>
References: <A9344FE6ED34A04F9BF550E6EAAAA31710611934@EXDB3.ug.kth.se>
<A9344FE6ED34A04F9BF550E6EAAAA3171061193D@EXDB3.ug.kth.se>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@gmail.com, mokhtary@kth.se
Subject: Re: FW: Hi
In-Reply-To: <201109101504.09488.adrian.klaver@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox