create temp table ... inherits

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

Responses

Browse pgsql-bugs by date

  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...