| From: | csmall(at)eye-net(dot)com(dot)au (Craig Small) |
|---|---|
| To: | pgsql-php(at)postgresql(dot)org |
| Subject: | tuple concurrently updated error |
| Date: | 2001-10-14 04:40:55 |
| Message-ID: | 20011014144055.A28076@eye-net.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
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(at)eye-net(dot)com(dot)au>
MIEEE <csmall(at)ieee(dot)org> Debian developer <csmall(at)debian(dot)org>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emmanuel SARACCO | 2001-10-14 08:48:14 | Re: temp tables and pg_pconnect() |
| Previous Message | Adam Lang | 2001-10-13 21:04:15 | Re: temp tables and pg_pconnect() |