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
pgp00000.pgp
Description: PGP signature
