Locks on FK Tables From Partitioning

Hi, 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 that a lock is also taken on

Question on tablefunc extension

Hello, We downloaded postgresql software from this site, https://www.postgresql.org/ftp/source/v12.1/, as a tar ball file (postgresql-12.1.tar.bz2). So we didn't do install the 'postgresql-contrib' option. Our developers asked that we add on the "tablefunc" extension to the existing postgres

Re: Question on tablefunc extension

On 2/8/22 09:30, Lu, Dan wrote: Hello, We downloaded postgresql software from this site, https://www.postgresql.org/ftp/source/v12.1/ , as a tar ball file (postgresql-12.1.tar.bz2).  So we didn’t do install the 'postgresql-contrib' option. Our

Re: Locks on FK Tables From Partitioning

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