Ola,
Alguem poderia me ajudar e me dizer o que significa
esse erro: " Error: cache lookup failed for index
107488493 "
Eu detectei esse erro em meu banco referente a esse
select:
SELECT t.tableoid, t.oid, t.relname as indexname,
pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef,
t.relnatts as indnkeys, i.indkey, i.indisclustered,
c.contype, c.conname, c.tableoid as contableoid, c.oid
as conoid, (SELECT spcname FROM
pg_catalog.pg_tablespace s WHERE s.oid =
t.reltablespace) as tablespace,
array_to_string(t.reloptions, ', ') as options FROM
pg_catalog.pg_index i JOIN pg_catalog.pg_class t ON
(t.oid = i.indexrelid) LEFT JOIN pg_catalog.pg_depend
d ON (d.classid = t.tableoid AND d.objid = t.oid AND
d.deptype = 'i') LEFT JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE i.indrelid = '107488490'::pg_catalog.oid ORDER
BY indexname
Obrigado.
Abra sua conta no Yahoo! Mail, o único sem limite de espaço para
armazenamento!
http://br.mail.yahoo.com/
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
