Re: [BUGS] create temp table ... inherits

2003-10-12 Thread Tom Lane
Robert Creager <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> confessed: >> Can you get a backtrace from the errfinish call to confirm this theory? > Breakpoint 1, 0x081b4806 in errfinish () > (gdb) bt > #0 0x081b4806 in errfinish () > #1 0x081b5546 in elog_finish () > #2 0x0807cc32

Re: [BUGS] create temp table ... inherits

2003-10-12 Thread Robert Creager
When grilled further on (Sun, 12 Oct 2003 13:06:25 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > > The two temp tables share a common parent? Ops, forgot. Yes. "obs_root" (which is what the temp table inherits from), is a persistent table. The temp table is used to filter data going into o

Re: [BUGS] create temp table ... inherits

2003-10-12 Thread Robert Creager
When grilled further on (Sun, 12 Oct 2003 13:06:25 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > > Can you get a backtrace from the errfinish call to confirm this theory? Breakpoint 1, 0x081b4806 in errfinish () (gdb) bt #0 0x081b4806 in errfinish () #1 0x081b5546 in elog_finish () #2 0x0

Re: [BUGS] create temp table ... inherits

2003-10-12 Thread Tom Lane
Robert Creager <[EMAIL PROTECTED]> writes: > 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 c

[BUGS] create temp table ... inherits

2003-10-12 Thread Robert Creager
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