| Lists: | pgsql-general |
|---|
| From: | frank_lupo <frank_lupo(at)email(dot)it> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | drop view not possible to select from pg_view |
| Date: | 2003-01-24 16:35:14 |
| Message-ID: | H988QQ$3F4E26609CCBC3152D405E112449DE33@email.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
I set autocommit =off.
When drop table and i do not send commit or rollback is possible to select from other user on pg_class or pg_tables.
When drop view and i do not send commit or rollback is not possible to select from other user on pg_view. The selection is lock.
For unlock selection on pg_view the user that dropped view have to send commit or rollback.
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://adv2.email.it/cgi-bin/foclick.cgi?mid=768&d=24-1
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | frank_lupo <frank_lupo(at)email(dot)it> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: drop view not possible to select from pg_view |
| Date: | 2003-01-24 21:21:11 |
| Message-ID: | 22789.1043443271@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
"=?utf-8?Q?frank=5Flupo?=" <frank_lupo(at)email(dot)it> writes:
> When drop view and i do not send commit or rollback is not possible to sele=
> ct from other user on pg_view. The selection is lock. =0D
The only thing that's locked is computing the "definition" field for the
view you are currently altering (read dropping). I see no way to avoid
that, nor any really strong reason to worry about it. Access to a table
that you're currently dropping is locked, too.
regards, tom lane