Re: Locks on FK Tables From Partitioning

2022-02-09 Thread Simon Riggs
On Tue, 8 Feb 2022 at 23:13, Tom Lane wrote: > > Aaron Sipser writes: > > I am fairly confused about the locks generated by some partitioning code I > > am using. The setup is that we have a partitioned table (call it P), and it > > has a foreign key constraint to another table F. I'm trying to f

Re: Locks on FK Tables From Partitioning

2022-02-08 Thread Tom Lane
Aaron Sipser writes: > I am fairly confused about the locks generated by some partitioning code I > am using. The setup is that we have a partitioned table (call it P), and it > has a foreign key constraint to another table F. I'm trying to figure out > why when I add partitions to P, it seems tha