Re: [pgadmin-hackers] problem to developing the lock

2003-02-22 Thread frank_lupo 
 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 when read 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=982d=22-2

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-hackers] problem to developing the lock

2003-02-22 Thread Dave Page 
It's rumoured that frank_lupo once said:

 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 when read 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.

Oh, I see. How about wrapping everything in a transaction in
pgDatabase.Execute in pgSchema? We should probably then provide a
secondary connection for use with SQL queries in pgAdmin. Probably not a
bad idea anyway.
What do you think?

Regards, Dave.



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])