Re: NOTICE: (transaction aborted): queries ignored until END - Mailing list pgsql-general

From Jason Earl
Subject Re: NOTICE: (transaction aborted): queries ignored until END
Date
Msg-id 87g07987ir.fsf@npa01zz001.simplot.com
Whole thread Raw
In response to NOTICE: (transaction aborted): queries ignored until END  (RoBSD <robsd@softhome.net>)
List pgsql-general
You might consider installing a newer version of PostgreSQL.  Yes, I
know that this is somewhat problematic as the RaQ actually uses
PostgreSQL itself.  However, you should be able to build a new version
yourself and run it alongside the RaQ version, except on a different
port.

PostgreSQL 6.5.3 was the first that I would even consider trusting in
a production environment (and then only using very simple queries).
The newer versions of PostgreSQL are miles ahead of 6.5.2.

Jason

RoBSD <robsd@softhome.net> writes:

> Hello ,
>
> I have a program (swatch on a Cobalt RaQ3) with access to a
> postgresql DB (version 6.5.2-C2) that was working good until I
> added a user with select privileges on one of
> the tables. I created a Perl script that connect to the DB with the
> new user and password using the DBI and DBD. But after the first run
> of the new Perl script the original program started to not update the
> DB and to give the error:
> "NOTICE: (transaction aborted): queries ignored until END"
>
> I can't change the original program or even read it.
>
> On a RaQ4 with a different version of swatch and postgresql (7.0.2)
> everything is working well.
>
> Thank you for your answers,
> Radu
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: A newbie's opinion - postgres NEEDS a Windows binary!
Next
From: J Smith
Date:
Subject: Re: Packages for RH7.2