Received: from fozzie.eye-net.com.au (fozzie.eye-net.com.au [203.41.228.19]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9E4ewr48579 for ; Sun, 14 Oct 2001 00:41:00 -0400 (EDT) (envelope-from csmall@eye-net.com.au) Received: by fozzie.eye-net.com.au (Postfix, from userid 1000) id 2BE77D62BC; Sun, 14 Oct 2001 14:40:55 +1000 (EST) Date: Sun, 14 Oct 2001 14:40:55 +1000 To: pgsql-php@postgresql.org Subject: tuple concurrently updated error Message-ID: <20011014144055.A28076@eye-net.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.18i From: csmall@eye-net.com.au (Craig Small) X-Archive-Number: 200110/56 X-Sequence-Number: 609 Hello All, I'm using PHP and postgresql and every now and then get this error: (this is from ngrep *sigh*) Warning: PostgreSQL query failed: ERROR: simple_heap_update: tuple concurrently updated. in /raid/indigo/home/ftp/home/csmall/www/lib/db_pgsql.inc.php on line 73
.Database error: Invalid SQL: ...CREATE TEMPORARY TABLE tmp_categories ()...INHERITS (categories)..
.PostgreSQL Error: 1 (ERROR: simple_heap_update: tuple concurrently updated.)
.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/ MIEEE Debian developer