Re: troubleshooting PGError - Mailing list pgsql-general

From Adrian Klaver
Subject Re: troubleshooting PGError
Date
Msg-id 201111100930.31280.adrian.klaver@gmail.com
Whole thread Raw
In response to troubleshooting PGError  (slavix <mikerin.slava@gmail.com>)
List pgsql-general
On Thursday, November 10, 2011 9:10:10 am Slava Mikerin wrote:
> I am running Rails 3.1 that uses a db. I used phpmyadmin for
> development and deployed to Heroku which uses postgres. When I got
> this error on the Heroku server I switched to postgres locally to
> investigate and got same error.

So what do the postgres logs show?
The message shows that something caused an error within a transaction block, at
that point all over commands are ignored until a ROLLBACK is given. Look in the
log and see if you find anything suspicious.

>
> ruby-1.9.2-p290 and pg-0.11.0 gem used
>


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Wes Cravens
Date:
Subject: Re: Returning a row from a function with an appended array field
Next
From: "David Johnston"
Date:
Subject: Re: Re: plpgsql, I have a solution, want to see if there is a cleaner/better one. Taking vertical list and comma separating it onto a row