Hey folks,
Running 7.4b4 on a 2 processor SMP system:
PostgreSQL 7.4beta4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 (Mandrake Linux 9.1 3.2.2-3mdk)
CREATE TEMP TABLE is being executed in two processes (same Perl/DBI script). It occurs when the scripts are executed
atthe same time. One of the processes dies with the following:
Oct 12 09:39:45 thunder postgres[31398]: [2-1] ERROR: tuple concurrently updated
Oct 12 09:39:45 thunder postgres[31398]: [2-2] STATEMENT: CREATE TEMP TABLE temp_obs_v() INHERITS( obs_root ) ON
COMMITDELETE ROWS
Is this something I'm going to have to deal with, or is it a bug? I found reference, but no follow up, at
http://archives.postgresql.org/pgsql-php/2001-10/msg00055.php. I've tried without success to create a small self
containedexample, but can reproduce at will on my system.
tassiv=# \d obs_root
Table "public.obs_root"
Column | Type | Modifiers
---------+---------+------------------------------------------------
x | real | not null
y | real | not null
imag | real | not null
smag | real | not null
loc | spoint | not null
obs_id | integer | not null default nextval('"obs_id_seq"'::text)
file_id | integer | not null
use | boolean | default false
solve | boolean | default false
star_id | integer |
mag | real |
Foreign-key constraints:
"$1" FOREIGN KEY (file_id) REFERENCES files(file_id)
"$2" FOREIGN KEY (star_id) REFERENCES catalog(star_id)
Cheers,
Rob
--
09:55:17 up 72 days, 2:22, 4 users, load average: 1.04, 1.01, 1.00