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 OID in question. > > In my experience, when a slony 1.2.x slave is involved, this usually means a > relation was dropped without first dropping it from replication using DROP > TABLE. In this case it may be a trigger on a table that has been "disabled" > by slony, it does this by changing pg_trigger.tgrelid to point to an index on > the table in question rather than the table itself. Thus when the table is > dropped the trigger is left behind, pointing to an index that isn't there. > I' probably start with "select * from "pg_catalog".pg_trigger where tgrelid = > <the OID that doesn't exist>", and prune from there.
It only happened to me once. You think it is because slony is poking around pg_catalog. schema, and it shouldn't , basically ? -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general