Re: NOTICE: (transaction aborted): queries ignored until END
От | Jason Earl |
---|---|
Тема | Re: NOTICE: (transaction aborted): queries ignored until END |
Дата | |
Msg-id | 87g07987ir.fsf@npa01zz001.simplot.com обсуждение исходный текст |
Ответ на | NOTICE: (transaction aborted): queries ignored until END (RoBSD <robsd@softhome.net>) |
Список | 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 по дате отправления: