Re: [HACKERS] Complete LOCK TABLE ... IN ACCESS|ROW|SHARE
On Thu, Oct 6, 2016 at 2:28 PM, marllius ribeiro wrote: > 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. Committed. I tweaked the comments just slightly. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Complete LOCK TABLE ... IN ACCESS|ROW|SHARE
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 MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW EXCLUSIVE MODE SHARE MODE postgres=# lock teste IN ACCESS EXCLUSIVE MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW 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 MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW EXCLUSIVE MODE SHARE MODE postgres=# lock teste IN ACCESS EXCLUSIVE MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW 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 MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW 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 MODEEXCLUSIVE MODE ROW SHARE MODE SHARE ROW EXCLUSIVE MODE ACCESS SHARE MODEROW 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Complete LOCK TABLE ... IN ACCESS|ROW|SHARE
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: tested, passed Documentation:not tested 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 MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW EXCLUSIVE MODE SHARE MODE postgres=# lock teste IN ACCESS EXCLUSIVE MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW 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 MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW EXCLUSIVE MODE SHARE MODE postgres=# lock teste IN ACCESS EXCLUSIVE MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW 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 MODEEXCLUSIVE MODE ROW SHARE MODE ACCESS SHARE MODEROW 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 MODEEXCLUSIVE MODE ROW SHARE MODE SHARE ROW EXCLUSIVE MODE ACCESS SHARE MODEROW 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 The new status of this patch is: Ready for Committer -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Complete LOCK TABLE ... IN ACCESS|ROW|SHARE
Hi After LOCK TABLE ... IN ACCESS|ROW|SHARE we run out of completions. Here's a patch to improve that, for November. -- Thomas Munro http://www.enterprisedb.com complete-lock-table.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers