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.
ruby-1.9.2-p290 and pg-0.11.0 gem used
On Thu, Nov 10, 2011 at 9:04 AM,
Thank you. I found the problem. It was with the previous query, not
the one that was showing up in the prompt.
I found the actual query in one of the log files.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/ma
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of slavix
Sent: Wednesday, November 09, 2011 12:03 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] troubleshooting PGError
Hello,
I am new to postgres, but need to
On 10 Nov 2011, at 17:42, Slava Mikerin wrote:
> Thank you for reply Alban, I am new to postgres and don't know the
> right commands to use to troubleshoot this issue.. The error message
> is unclear and I don't know what caused the problem. can you tell me
> what exact command to use? I don't ne
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.
S
On Thursday, November 10, 2011 8:56:56 am you wrote:
> "PostgreSQL 8.4.9 on i686-pc-linux-gnu, compiled by GCC gcc-4.4.real
> (Ubuntu/Linaro 4.4.4-14ubuntu5) 4.4.5, 32-bit"
>
Please reply to the list also. That gets your issue in front of more eyes:)
The above answers my first question.
The seco
On Thursday, November 10, 2011 8:47:39 am you wrote:
> not sure about version.. (latest i presume because installed recently)
> same problem on my local machine running Ubuntu and on Heroku server
> what command to get version?
>
select version();
--
Adrian Klaver
adrian.kla...@gmail.com
--
S
your transaction had an error, and any query after the first one that
has failed will be ignored.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tuesday, November 08, 2011 9:02:40 pm slavix wrote:
> Hello,
> I am new to postgres, but need to resolve this error:
>
> PGError: ERROR: current transaction is aborted, commands ignored
> until end of transaction block
>
> : SELECT 1 FROM "trades" WHERE ("trades"."uuid" =
>
> 'bc8d86e6-0a8
On 9 November 2011 06:02, slavix wrote:
> Hello,
> I am new to postgres, but need to resolve this error:
>
> PGError: ERROR: current transaction is aborted, commands ignored
> until end of transaction block
> : SELECT 1 FROM "trades" WHERE ("trades"."uuid" =
> 'bc8d86e6-0a8d-11e1-a345-001d09203
Hello,
I am new to postgres, but need to resolve this error:
PGError: ERROR: current transaction is aborted, commands ignored
until end of transaction block
: SELECT 1 FROM "trades" WHERE ("trades"."uuid" =
'bc8d86e6-0a8d-11e1-a345-001d09203579' AND "trades"."id" != 25) LIMIT
1
Don't know what
11 matches
Mail list logo
