Re: NOTICE: (transaction aborted): queries ignored until END

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