[postgis-users] Postgis: Error

[pcreso at pcreso.com]

If you can run it in an X console, you can usually set the history to whatever value you like, or even unlimited.

Not recommended for general use, but useful in such cases.

Brent



--- 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: pcreso at pcreso.com, "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Saturday, March 6, 2010, 6:47 AM
> Thanks guys. 
> It was generating a lot of records. It does not fit into
> screen. Is there any logs created for this? Or I should put
> the output into a log file.
> Thanks, Majid
> 
> -----Original Message-----
> From: pcreso at pcreso.com
> [mailto:pcreso at pcreso.com]
> 
> Sent: March 5, 2010 12:43 PM
> To: PostGIS Users Discussion
> Cc: Majid Kazemi
> Subject: Re: [postgis-users] Postgis: Error
> 
> 
> 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
> > 
>