Обсуждение: NOTICE: (transaction aborted): queries ignored until END

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

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

SS> On Tue, 20 Nov 2001, RoBSD wrote:

>> 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"

SS> IIRC, There were problems in older versions where the default permission
SS> would get blown away when you added the first user permissions to a table.
SS> I think if you grant permissions back to public you might be okay.

Thank you very much! This was the perfect answer for me.

I resolved the problem by changing back the permissions to that table.

Radu