From: csmall@eye-net.com.au
To: pgsql-php@postgresql.org
Subject: tuple concurrently updated error
Date: Sun, 14 Oct 2001 14:40:55 +1000
Message-ID: <20011014144055.A28076@eye-net.com.au> (raw)
Hello All,
I'm using PHP and postgresql and every now and then get this error:
(this is from ngrep *sigh*)
<b>Warning</b>: PostgreSQL query failed: ERROR: simple_heap_update:
tuple concurrently updated. in
<b>/raid/indigo/home/ftp/home/csmall/www/lib/db_pgsql.inc.php</b> on
line <b>73</b><br>.</td></tr></table><b>Database error:</b> Invalid
SQL: ...CREATE TEMPORARY TABLE tmp_categories ()...INHERITS
(categories)..<br>.<b>PostgreSQL Error</b>: 1 (ERROR:
simple_heap_update: tuple concurrently updated.)<br>.Session halted.
It seems that the command
CREATE TEMPORARY TABLE tmp_categories () INHERITS (categories)
fails. I'm suspecting two people going to the page at the same time,
but how should it be re-coded so that this problem doesn't happen?
Please CC me, I'm not on the list.
--
Craig Small VK2XLZ GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5
Eye-Net Consulting http://www.eye-net.com.au/ <csmall@eye-net.com.au>
MIEEE <csmall@ieee.org> Debian developer <csmall@debian.org>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: csmall@eye-net.com.au
Subject: Re: tuple concurrently updated error
In-Reply-To: <20011014144055.A28076@eye-net.com.au>
References: <20011014144055.A28076@eye-net.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox