Re: Questions relating to "modified while in use" messages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Questions relating to "modified while in use" messages
Date: 2000-07-13 16:17:48
Message-ID: 29890.963505068@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> Of course, I also really only noticed it when I ran the two really
> close together or the alter table inside a transaction.

Right, the problem only comes up if the report of the table change
arrives at the other backend just as it's preparing to start a new
transaction on that same table. If the other backend's first table
lock after the ALTER commits is on some other table, no problem.

We do need to fix it but I think there are higher-priority problems...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2000-07-13 21:13:00 Re: Temp tables performance question
Previous Message Bruce Momjian 2000-07-13 16:16:44 Re: Temp tables performance question