From: | Camm Maguire <camm(at)enhanced(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Mysterious 7.0.3 error |
Date: | 2001-01-17 14:58:08 |
Message-ID: | 54u26yb4zj.fsf_-_@intech19.enhanced.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)enhanced(dot)com
==========================================================================
"The earth is but one country, and mankind its citizens." -- Baha'u'llah
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-17 14:59:18 | Re: AW: Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3 |
Previous Message | Thomas Lockhart | 2001-01-17 14:14:16 | Re: AW: AW: AW: Re: tinterval - operator problems on AIX |