Re: relation ### modified while in use

On Mon, 23 Oct 2000, Tom Lane wrote:

>     begin;
>     select * from foo;  -- gets AccessShareLock
>     LOCK TABLE foo;        -- gets AccessExclusiveLock
>     ...
>     end;
> 
> this will work currently because the SELECT releases AccessShareLock
> when done, but it will deadlock if SELECT does not release that lock.
Probably a silly question, but since this is the same transaction,
couldn't the lock be 'upgraded' without a problem? 

Or postgres doesn't currently have idea of lock upgrades...?

-alex