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