Postgres Pro
Downloads
Home   >   mailing lists

tuple concurrently updated error - Mailing list pgsql-php

From csmall@eye-net.com.au (Craig Small)
Subject tuple concurrently updated error
Date
Msg-id 20011014144055.A28076@eye-net.com.au
Whole thread Raw
List pgsql-php
Tree view 
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>

pgsql-php by date:

Previous
From: "Adam Lang"
Date:
Subject: Re: temp tables and pg_pconnect()
Next
From: Emmanuel SARACCO
Date:
Subject: Re: temp tables and pg_pconnect()