> 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.
The problem is the function pg_get_viewdef. If the view is drop and transiction is safe (no commit/rollback) the function lock query.
Is possible not use this function?
Is possible that the other functions that returns the definition
t have the same limit?
Frank Lupo (Wolf) !!
\ o o /
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
I gioielli più nuovi, le collezioni più trendy, le trovi solo su Gioie.it!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=768&d=28-2
pgadmin-hackers by date
|Next:||From: frank_lupo||Date: 2003-02-28 11:10:15|
|Subject: Re: Add a definable row limit to 'View Data'|
|Previous:||From: frank_lupo||Date: 2003-02-26 21:44:00|
|Subject: RE: development language|