Thread: FW: Hi

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

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