From: | Harry Yau <harry(dot)yau(at)regaltronic(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Mulit-User Locking?? |
Date: | 2002-06-22 04:04:50 |
Message-ID: | 3D13F762.9517661A@regaltronic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All:
I got a question right now, please let me a hand.
I am wondering is Postgresql will do something like session on the back
end that will lock up a table or database while a table or database is
accessed by one user. Then all other user cannot access that table or
database.
As I know, there is one for the sybase. I have to put a line something
like:
"read commit isolation"
at the end of the SELECT SQL statement to let all other user to access
the table or database during I am SELECT (only browsing) the table.
Please, let me know either there is a feature like that for the
Postgresql.
THANK YOU VERY MUCH.
Hary Yau
From | Date | Subject | |
---|---|---|---|
Next Message | Robson Martins | 2002-06-22 14:35:20 | Restor only date |
Previous Message | Bruce Momjian | 2002-06-22 03:58:08 | Re: Import from text file |