"Jenny -" <[EMAIL PROTECTED]> writes:
> so even though the application locks a row in a table, table-level locks are
> automatically taken by postgesql ? why is that?
So that the table doesn't disappear while you're trying to scan it. (Or
afterwards --- a row-level lock wouldn't be noticed by DROP TABLE.)
Note that AccessShareLock is a pretty weak kind of lock, and holding it
does not prevent most other operations.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
