[postgis-users] Postgis: Error

[pcreso at pcreso.com]

Hi Majid,

What you have written here is the message from the end of the transaction saying it failed & rolled back.

While the transaction was running, there will have been an error message which describes what actually failed. If you scroll further up the output messages on screen you'll see this message which should help determine what the problem is.


Brent Wood

--- On Sat, 3/6/10, Majid Kazemi <Majid.Kazemi at teranet.ca> wrote:

> From: Majid Kazemi <Majid.Kazemi at teranet.ca>
> Subject: Re: [postgis-users] Postgis: Error
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Saturday, March 6, 2010, 5:34 AM
> 
> 
> 
>  
>  
> 
> 
> 
> 
> 
> 
> 
>  
> 
> 
> 
> Thanks for
> response. 
> 
> Here are
> the steps: 
> 
> I have
> installed postgres 8.3.9 on Redhat
> 5. Server started successfully. Postgres database was
> created.  
> 
> Since I
> need to create a spatial database,
> I have untar postgis-1.5.0.tar.gz 
> 
> cd
> postgis-1.5.0 
> 
> ./configure.
> 
> 
> During the
> running the configure I run
> into a lot of issue for missing libraries.
>  
> 
> I have
> downloaded and installed geos,
> Proj4.6 and GTK+2. It all seems were okay. Then I run
>  
> 
> ./configure
> again.  
> 
> The postgis
> installed successfully according
> to screen output. 
> 
> Then, I
> have created another database. 
> 
> Psql
> createlang plpgsql . I was logged in
> as postgres. 
> 
> Then I
> followed the following steps: 
> 
> Psql
> –d mydb –f postgis.sql   at
> this step I encountered these errors. 
> 
> “Current
> transaction is aborted, command
> ignored until end of transaction block”.
> Rollback
> 
> 
> 
> Please let
> me know if you need more
> information. 
> 
> Thanks,
> Majid 
> 
> 
>   
> 
> 
>   
> 
> 
> 
> 
> 
> 
> 
> 
> 
> From:
> postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net]
> On Behalf Of Emilie
> Laffray
> 
> Sent: March
> 5, 2010 11:16 AM
> 
> To: PostGIS
> Users Discussion
> 
> Subject: Re:
> [postgis-users]
> Postgis: Error 
> 
> 
> 
>    
> 
> 
>   
> 
> 
> 
> On 5 March 2010 16:06, Majid Kazemi
> <Majid.Kazemi at teranet.ca>
> wrote: 
> 
> 
> 
> 
> 
> Hi,
> 
> 
> I
> am trying to run postgis .sql 1.5 on Linux to create a
> spatial database. I am
> receiving the following error: 
> 
> Current
> transaction is aborted, command ignored until end of
> transaction block.
> Rollback. 
> 
> I
> am very new to postgres and postgis. Your help will highly
> be appreciated.  
> 
> Thanks,
> Majid 
> 
>    
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Can you provide us with the steps you are taking? The error
> in itself is not
> enough to tell us what is wrong.
> 
> The message just indicates that somewhere an error occurred
> in a transaction
> and the transaction is rolled back. It doesn't give us
> any information on what
> you were trying to do and where the error is occurring.
> 
> 
> 
> Emilie Laffray 
> 
> 
> 
>  
> 
> 
> 
> -----Inline Attachment Follows-----
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>