Re: BUG #14003: Error "could not open relation with OID 18152875" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14003: Error "could not open relation with OID 18152875"
Date
Msg-id 21083.1457365821@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14003: Error "could not open relation with OID 18152875"  (g.jalmi@tcs.com)
List pgsql-bugs
g.jalmi@tcs.com writes:
> PostgreSQL version: 9.1.14

> Scenario:  A temporary table is created within a function where no schema
> name is specefied for the table. This table is created using dynamic sql.
>     close the cursor
>         return all records from temporary table  and then drop the temorary
> table.

It's hard to be sure since you didn't provide a concrete test case, but
this sounds very much like a bug that was fixed last September (in 9.1.19
and its sibling releases); see
http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=dae1c9480

If updating to 9.1.19 or 9.1.20 doesn't fix it, please provide an
exact script to reproduce the problem.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14001: pg_ctl error output empty/faulty
Next
From: armin.schoeffmann@aegaeon.de
Date:
Subject: BUG #14004: pg_restore never returns on premature EOF of input file if invoked with with parallel job option