On Wed, 2005-07-06 at 23:36 -0400, Tom Lane wrote:
> Joe Markwardt <joe@xxxxxxxxxxxxx> writes:
> > On Wed, 2005-07-06 at 14:04 -0400, Tom Lane wrote:
> >> They appear to be triggers for a foreign-key constraint between
> >> pl_inventory_analyzer_files_table and pl02_status_table ... so I guess
> >> the question is what happened to the latter?
>
> > I'm not sure. As far as I can tell nothing has happened to the
> > pl02_status_table, nor should anything have happened to it recently.
>
> Well, that's just plain bizarre...
>
> The next thing to check is whether the OID mentioned in pg_trigger
> (which I forgot already) is the same as the OID shown in pg_class, ie
> select oid from pg_class where relname = 'pl02_status_table'.
oid
-----------
438094756
(1 row)
The oid that shows up in the error is 438095645.
the oid for the pl02_status_table does not show up in any of the rows in
pg_trigger that have the oid from the error in them. The oid for the
status table does show up in a few other rows in pg_trigger (attached
file), which makes sense since its referenced in at least 2 other tables
with foreign keys, and it still is being replicated by slony so it has
that trigger on it as well.
Thanks
Joe
pl=# select * from pg_trigger where tgrelid=438094756 or tgfoid=438094756 or tgconstrrelid=438094756;
tgrelid | tgname | tgfoid | tgtype | tgenabled | tgisconstraint | tgconstrname | tgconstrrelid | tgdeferrable | tginitdeferred | tgnargs | tgattr | tgargs
-----------+--------------------------------+-----------+--------+-----------+----------------+--------------+---------------+--------------+----------------+---------+--------+------------------------------------------------------------------------------------------------------
438094756 | _T1_denyaccess_51 | 438099997 | 31 | t | f | | 0 | f | f | 1 | | _T1\000
694764767 | RI_ConstraintTrigger_694764778 | 1644 | 21 | t | t | $3 | 438094756 | f | f | 6 | | $3\000pl_batch_search_table\000pl02_status_table\000UNSPECIFIED\000status\000status_id\000
438095547 | RI_ConstraintTrigger_438096078 | 1644 | 21 | t | t | status_id_fk | 438094756 | f | f | 6 | | status_id_fk\000pl02_rfq_table\000pl02_status_table\000UNSPECIFIED\000status_id\000status_id\000
438095488 | RI_ConstraintTrigger_438095994 | 1644 | 21 | t | t | $1 | 438094756 | f | f | 6 | | $1\000pl_inventory_evaluator_files\000pl02_status_table\000UNSPECIFIED\000status_id\000status_id\000(4 rows)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
