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