From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | General Bug Report: Transaction END statemente generates NOTICE: EndTransactionBlock and not inprogress/abort state |
Date: | 1999-03-15 04:47:33 |
Message-ID: | 199903150447.XAA78888@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Manuel Lemos
Your email address : mlemos(at)acm(dot)org
Category : runtime: front-end: PHP/FI
Severity : non-critical
Summary: Transaction END statemente generates NOTICE: EndTransactionBlock and not inprogress/abort state
System Configuration
--------------------
Operating System : Lunix 2.0.34, SunOS 5.6
PostgreSQL version : 6.4.2
Compiler used : gcc 2.7.2.3
Hardware:
---------
Linux cohones 2.0.34 #14 Mon Sep 14 20:25:09 WEST 1998 i586 unknown
SunOS crystal.adgrafix.com 5.6 Generic_105181-11 sun4u sparc SUNW,UltraSPARC-IIi
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
I use PHP persistent connections to PostgreSQL. I use BEGIN to start a
transaction and I noticed that the changes are not effectively committed
when I do a simple COMMIT. Since with PHP's persistent connections are
never closed I realized that I have to perform an END query or start a new
query with BEGIN.
The problem is that when I perform an END query PostgreSQL front end dumps
this message to stderr which ends in the Web server (Apache 1.3.4) error
log:
NOTICE: EndTransactionBlock and not inprogress/abort state
--------------------------------------------------------------------------
Test Case:
----------
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Reifenberger | 1999-03-15 16:38:28 | query corruption for complexer queries on -current? |
Previous Message | Bruce Momjian | 1999-03-14 18:19:27 | Re: [BUGS] SQL optimisation dead loop |