tuple concurrently updated error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxxxxxxx>
MIEEE <csmall@xxxxxxxx>                 Debian developer <csmall@xxxxxxxxxx>


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux