Re: BUG #14003: Error "could not open relation with OID 18152875"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: g(dot)jalmi(at)tcs(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14003: Error "could not open relation with OID 18152875"
Date: 2016-03-07 15:50:21
Message-ID: 21083.1457365821@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

g(dot)jalmi(at)tcs(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message armin.schoeffmann 2016-03-07 16:16:19 BUG #14004: pg_restore never returns on premature EOF of input file if invoked with with parallel job option
Previous Message Tom Lane 2016-03-07 15:41:47 Re: BUG #14001: pg_ctl error output empty/faulty