From: | Camm Maguire <camm(at)enhanced(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Mysterious 7.0.3 error |
Date: | 2001-01-17 18:49:20 |
Message-ID: | 54bst63tfz.fsf@intech19.enhanced.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Greetings, and thanks for your reply!
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> 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.
>
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(at)enhanced(dot)com
==========================================================================
"The earth is but one country, and mankind its citizens." -- Baha'u'llah
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Myers | 2001-01-17 19:50:05 | Re: copy from stdin; bug? |
Previous Message | Hannu Krosing | 2001-01-17 17:58:54 | Re: Re: Performance degradation in PostgreSQL 7.1beta3 vs |