| From: | marllius ribeiro <marllius(dot)ribeiro(at)tecnisys(dot)com(dot)br> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Thomas Munro <munro(at)ip9(dot)org> |
| Subject: | Re: Complete LOCK TABLE ... IN ACCESS|ROW|SHARE |
| Date: | 2016-10-06 18:28:45 |
| Message-ID: | 20161006182845.1296.43465.pgcf@coridan.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
This was my first test which had help Gerdan.
I did some tests and found nothing special. The stated resource is implemented correctly.
He passes all regression tests and enables the use of the new features specified.
The test was initially performed to verify that the features exist, however not effected, it follows the evidence:
postgres=# lock teste IN
ACCESS EXCLUSIVE MODE EXCLUSIVE MODE ROW SHARE MODE
ACCESS SHARE MODE ROW EXCLUSIVE MODE SHARE MODE
postgres=# lock teste IN
ACCESS EXCLUSIVE MODE EXCLUSIVE MODE ROW SHARE MODE
ACCESS SHARE MODE ROW EXCLUSIVE MODE SHARE MODE
postgres=# lock teste IN ACCESS
postgres=# lock teste IN ACCESS
postgres=# lock t
TABLE teste
postgres=# lock teste IN
ACCESS EXCLUSIVE MODE EXCLUSIVE MODE ROW SHARE MODE
ACCESS SHARE MODE ROW EXCLUSIVE MODE SHARE MODE
postgres=# lock teste IN
ACCESS EXCLUSIVE MODE EXCLUSIVE MODE ROW SHARE MODE
ACCESS SHARE MODE ROW EXCLUSIVE MODE SHARE MODE
postgres=# lock TABLE
information_schema. pg_temp_1. pg_toast_temp_1. teste
pg_catalog. pg_toast. public.
postgres=# lock TABLE teste IN
ACCESS EXCLUSIVE MODE EXCLUSIVE MODE ROW SHARE MODE
ACCESS SHARE MODE ROW EXCLUSIVE MODE SHARE MODE
postgres=# lock TABLE teste IN ACCESS
postgres=# lock TABLE teste IN ACCESS
postgres=# lock TABLE teste IN ACCESS
postgres=# lock TABLE teste IN SHARE
postgres=# lock TABLE teste IN ROW
postgres=# lock TABLE teste IN ROW
postgres=# lock TABLE teste IN ROW
---------------------------------
After applied patch come the new features.
postgres=# lock table teste IN ACCESS
EXCLUSIVE MODE SHARE MODE
postgres=# lock table teste IN
ACCESS EXCLUSIVE MODE EXCLUSIVE MODE ROW SHARE MODE SHARE ROW EXCLUSIVE MODE
ACCESS SHARE MODE ROW EXCLUSIVE MODE SHARE MODE SHARE UPDATE EXCLUSIVE MODE
postgres=# lock table teste IN ACCESS
EXCLUSIVE MODE SHARE MODE
postgres=# lock table teste IN ACCESS
EXCLUSIVE MODE SHARE MODE
postgres=# lock table teste IN ROW
EXCLUSIVE MODE SHARE MODE
postgres=# lock table teste IN SHARE
MODE ROW EXCLUSIVE MODE UPDATE EXCLUSIVE MODE
postgres=# lock table teste IN SHARE
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2016-10-06 18:38:56 | pgbench vs. wait events |
| Previous Message | Pavan Deolasee | 2016-10-06 17:59:38 | FSM corruption leading to errors |