From: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
---|---|
To: | PGBugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | create temp table ... inherits |
Date: | 2003-10-12 16:08:10 |
Message-ID: | 20031012100810.4122a5c1.Robert_Creager@LogicalChaos.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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 at the 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 COMMIT DELETE 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 contained example, 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-10-12 17:06:25 | Re: create temp table ... inherits |
Previous Message | Tom Lane | 2003-10-11 17:11:59 | Re: [GENERAL] Partial indices... |