Re: Mysterious 7.0.3 error

Camm Maguire <camm(at)enhanced(dot)com> writes:
> Greetings! We have a script updating our database with thousands of
> entries on a daily basis. To speed up processing, we drop a
> consistency check trigger before the update and recreate it
> afterwards. Occasionally, we get the following, even though the
> database has no other live connections, and the trigger drop is the
> first statement:

> drop trigger rprices_insupdel on rprices;
> DROP
> ERROR: RelationClearRelation: relation 160298 modified while in use

Are you doing other schema changes (like other instances of this script)
in parallel? Or vacuums of system tables? Those are the cases I recall
that might trigger this problem.

> Any pointers most appreciated!

Live with it until 7.1 :-(.

regards, tom lane