anyone please ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 11 May 2010, at 16:19, Grzegorz Jaśkiewicz wrote:
Another thing that makes me think so, is what I've seen in pg_dump's output:
CREATE TRIGGER _simreplic_denyaccess_208
BEFORE INSERT OR DELETE OR UPDATE ON some_table
FOR EACH ROW
EXECUTE PROCEDURE 28799('_somereplic');
Which
:
From: Grzegorz Jaśkiewicz gryz...@gmail.com
Subject: Re: [GENERAL] 8.3.7, 'cache lookup failed' for a table
To: pgsql-general@postgresql.org
Date: Wednesday, 12 May, 2010, 10:33
anyone please ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
no it is not slony related.
It is a postgresql problem.
my original post:
http://archives.postgresql.org/pgsql-general/2010-05/msg00402.php
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Wed, May 12, 2010 at 10:57 AM, Glyn Astill glynast...@yahoo.co.uk wrote:
Hi Grzegorz,
Is it always the same OID(s)?
Usually this means something somewhere has a link to an OID that has been
removed.
You could try digging through pg_catalog lookng for an oid column that refers
to the
: Grzegorz Jaśkiewicz gryz...@gmail.com
Subject: Re: [GENERAL] 8.3.7, 'cache lookup failed' for a table
To: Alban Hertroys dal...@solfertje.student.utwente.nl
Cc: pgsql-general@postgresql.org
Date: Wednesday, 12 May, 2010, 10:57
no it is not slony related.
It is a postgresql problem.
my
--- On Wed, 12/5/10, Grzegorz Jaśkiewicz gryz...@gmail.com wrote:
Glyn Astill glynast...@yahoo.co.uk
wrote:
Hi Grzegorz,
Is it always the same OID(s)?
Usually this means something somewhere has a link to
an OID that has been removed.
You could try digging through pg_catalog lookng
we ere adding/removing slony to the system for Nth
time (due to it sometimes going out of sync) may be caused by that as well.
--- On Wed, 12/5/10, Grzegorz Jaśkiewicz gryz...@gmail.com wrote:
From: Grzegorz Jaśkiewicz gryz...@gmail.com
Subject: Re: [GENERAL] 8.3.7, 'cache lookup failed
On Wed, May 12, 2010 at 11:09 AM, Alban Hertroys
dal...@solfertje.student.utwente.nl wrote:
On 12 May 2010, at 12:01, Glyn Astill wrote:
Did you not mention that this server was a slony slave at some point though?
Just because you have removed slony, and the error comes from postgresql
--- On Wed, 12/5/10, Grzegorz Jaśkiewicz gryz...@gmail.com wrote:
Alban Hertroys
dal...@solfertje.student.utwente.nl
wrote:
On 12 May 2010, at 12:01, Glyn Astill wrote:
Did you not mention that this server was a slony
slave at some point though?
Just because you have removed slony,
2010/5/12 Glyn Astill glynast...@yahoo.co.uk:
--- On Wed, 12/5/10, Grzegorz Jaśkiewicz gryz...@gmail.com wrote:
Alban Hertroys
dal...@solfertje.student.utwente.nl
wrote:
On 12 May 2010, at 12:01, Glyn Astill wrote:
Did you not mention that this server was a slony
slave at some point
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
You think it is because slony is poking around pg_catalog.
schema, and it shouldn't , basically ?
No, Slony 1.2.x pokes around in pg_catalog because in versions
of postgres prior to 8.3 (which 1.2.x has to support) there was
no built in
I got that sort of error on 8.3.7 (can't upgrade really), is it
something that can be easily resolved ? I do understand that OID is
gone from the pg catalogue , but still in memory.
Will restart of database help in this case ? Was it fixed in
following revisions ?? (8.3.x, x7).
--
GJ
--
Having seen that all previous problems went unresolved, heres a bit
more info. The system is 32 bit, running on enterprise redhat 4.7. It
is slony's slave node, so it will be hit with quite few updates.
My guess is that it happened when we ere adding/removing slony to the
system for Nth time (due
14 matches
Mail list logo