pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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>



Message-ID: <20011014144055.A28076@eye-net.com.au>
Permalink:  ../20011014144055.A28076@eye-net.com.au/
Also on:    postgresql.org/message-id/20011014144055.A28076@eye-net.com.au

 · 

reply

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