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
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 |