Re: problem to developing the lock

> 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
of obje

c
t have the same limit?

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
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