I am trying to create a table in my production system that has a foreign key into an existing table. However, this action is being blocked by transactions on that table, and is blocking any additional selects on that table.
Why is this? The table is empty (being a create), so I don't understand what Postgresql is trying to do.