BUG #15937: Partitioning

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15937: Partitioning

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      15937
Logged by:          Vladimír Frimmel
Email address:      [hidden email]
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.

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15937: Partitioning

Peter Eisentraut-6
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