create temp table ... inherits - Mailing list pgsql-bugs

From Robert Creager
Subject create temp table ... inherits
Date
Msg-id 20031012100810.4122a5c1.Robert_Creager@LogicalChaos.org
Whole thread Raw
Responses Re: create temp table ... inherits
List 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
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Partial indices...
Next
From: Tom Lane
Date:
Subject: Re: create temp table ... inherits