[postgis-users] Postgis: Error

[Majid Kazemi]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100305/be3527e0/attachment.html>