Thread: BUG #15937: Partitioning
The following bug has been logged on the website: Bug reference: 15937 Logged by: Vladimír Frimmel Email address: frimmelv@gmail.com PostgreSQL version: 11.3 Operating system: Linux Description: Hi, is it possible to LOCK only PARTITION on partitioning table instead of whole TABLE? When I performed command LOCK with table partition name, no error raised, but whole table was locked. Is it OK? We need to lock onli partition, not whole table. This is the critical point in our migration from Oracle. Thanks for reply. Vladimir.
On 2019-08-01 14:51, PG Bug reporting form wrote: > Hi, is it possible to LOCK only PARTITION on partitioning table instead of > whole TABLE? > When I performed command LOCK with table partition name, no error raised, > but whole table was locked. Is it OK? We need to lock onli partition, not > whole table. This is the critical point in our migration from Oracle. Can you show the actual commands of what you are doing? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services