Re: problem to developing the lock - Mailing list pgadmin-hackers

From frank_lupo
Subject Re: problem to developing the lock
Date
Msg-id HAP7QX$358335C9DDA23F3EAD36040490541AFD@email.it
Whole thread Raw
Responses Re: problem to developing the lock  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-hackers
> It's rumoured that frank_lupo once said:
> > I am developing the lock but I find problems why the pgadmin2 it
> > remains blocked.  How can be resolved the problem?
> 
> > Read mail:
> > drop view not possible to select from pg_view
> > http://archives.postgresql.org/pgsql-general/2003-01/msg01031.php
> 
> Sorry Frank, I don't understand what you mean :-(
> 
> Regards, Dave.
> 
> 
> 

I set autocommit =off. 
When drop view and i do not send commit or rollback,is not possible to select from other user on pg_view. The Pgadmin2
whenread schema is locked,and is not possible to make whichever other operation.  This is my problem.
 
It is not possible to use pgadmin2 if the view are locked.


Bye !!
Frank Lupo (Wolf) !!

   /\_ _/\
   \ o o /
--ooo-----ooo---



--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Un giorno a settimana gusta la Mozzarella di Bufala Campana e la Treccia di Agerola.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=982&d=22-2


pgadmin-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: reset statistic
Next
From: "Dave Page"
Date:
Subject: Re: problem to developing the lock