
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


Any pointers most appreciated!

-- 
Camm Maguire			     			camm@enhanced.com
==========================================================================
"The earth is but one country, and mankind its citizens."  --  Baha'u'llah

17 Jan 2001 09:58:08 -0500
Camm Maguire <camm@enhanced.com>
Mysterious 7.0.3 error
Camm Maguire <camm@enhanced.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

Wed, 17 Jan 2001 10:31:21 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Mysterious 7.0.3 error 
Greetings, and thanks for your reply!

Tom Lane <tgl@sss.pgh.pa.us> writes:

> Camm Maguire <camm@enhanced.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.
> 

No, just one job, this job, at a time.

> > Any pointers most appreciated!
> 
> Live with it until 7.1 :-(.
> 

Will do.  Thanks!

> 			regards, tom lane
> 
> 

-- 
Camm Maguire			     			camm@enhanced.com
==========================================================================
"The earth is but one country, and mankind its citizens."  --  Baha'u'llah

17 Jan 2001 13:49:20 -0500
Camm Maguire <camm@enhanced.com>
Re: Mysterious 7.0.3 error