ERROR: could not open relation with OID 22617039

From: "Adriano Sperandio" <adriano(dot)sperandio(at)by7(dot)com(dot)br>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: ERROR: could not open relation with OID 22617039
Date: 2015-06-16 17:51:19
Message-ID: 0a2201d0a85d$0dcf03c0$296d0b40$@by7.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello, I'm experiencing a problem when I run a given query. the error does
not occur when I run the same query again.

I tried to search the object by OID, but have not found.

My Version:

----------------------------------------------------------------------------
----------------------------

PostgreSQL 9.1.15 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 64-bit

(1 row)

Command:

create temporary table qfabs as (select f.*

from

fabs as f,

(select

setor, ramo, comunidade

from

comunidades

where

setor = 177

) as c

where

( (f.ano> 2014) or (f.ano = 2014 and
f.mes>= 6) ) and

( (f.ano< 2015) or (f.ano = 2015 and
f.mes<= 5) ) and

( f.setor = c.setor and f.ramo = c.ramo and
f.comunidade = c.comunidade )

)

PostgreSql Error:

ERROR: could not open relation with OID 22617039

pastcri-dev=> SELECT oid FROM pg_class where oid=22617039;

oid

-----

(0 rows)

pastcri-dev=> select relname, relkind from pg_class where relfilenode
=22617039;

relname | relkind

---------+---------

(0 rows)

Adriano Sperandio

Diretor de Serviços e Projetos

E-mail: <mailto:adriano(dot)sperandio(at)by7(dot)com(dot)br> adriano(dot)sperandio(at)by7(dot)com(dot)br

<tel:%2B55%2047%203432-9000> +55 47 3432-9000 / 47 92225010
---
Microsoft Certified Professional

Microsoft Certified Technology Specialist

Oracle Database 11g Administrator Certified Associate

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Christoph Berg 2015-06-16 18:35:56 Re: [GENERAL] pg_xlog on a hot_standby slave filling up
Previous Message Jeff Janes 2015-06-16 17:00:13 Re: BUG #13443: master will remove dead rows when hot standby(use slot) disconnect