| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Slava Mikerin <mikerin(dot)slava(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: troubleshooting PGError |
| Date: | 2011-11-10 17:30:30 |
| Message-ID: | 201111100930.31280.adrian.klaver@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2011-11-10 17:37:04 | 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 |
| Previous Message | Pavel Stehule | 2011-11-10 17:15:02 | Re: function within a function/rollbacks/exception handling |