Skip site navigation (1)
Skip section navigation (2)
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.
Thanks,
Chris
PG 8.1.3
Peripheral Links
Header And Logo
|
Site Navigation
create table problems
- From: "Chris Hoover" <revoohc(at)gmail(dot)com>
- To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: create table problems
- Date: Wed, 26 Jul 2006 16:51:34 -0400
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.
Thanks,
Chris
PG 8.1.3
- Follow-Ups:
- Re: create table problems
- From: Michael Fuhr
- Re: create table problems
- Prev by Date: Re: Starting PostgreSQL from a windows application
- Next by Date: Re: DBA tasks
- Previous by thread: Starting PostgreSQL from a windows application
- Next by thread: Re: create table problems
- Indexes: