X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0F3DC9FA4E0 for ; Wed, 26 Jul 2006 17:51:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 96540-04 for ; Wed, 26 Jul 2006 17:51:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.197]) by postgresql.org (Postfix) with ESMTP id 678549FA004 for ; Wed, 26 Jul 2006 17:51:36 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s14so1138632wxc for ; Wed, 26 Jul 2006 13:51:34 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=lfKGeFOD9+c3DAUXGh8yQ/gUob9U6RBJCpDP3hocigPNEqeJ8CQyI00ayKhScwF2/y0Atea3f/TuXnjeb3oE7f4rwYPCb3prWDqQuZSFWGseigmgoE2MMYtxh44qv0XDng40s++ua5YlkOy6bvjffYI36vwzL0MrpwLHyzm2v48= Received: by 10.70.6.8 with SMTP id 8mr3410702wxf; Wed, 26 Jul 2006 13:51:34 -0700 (PDT) Received: by 10.70.73.6 with HTTP; Wed, 26 Jul 2006 13:51:34 -0700 (PDT) Message-ID: <1d219a6f0607261351w2a743022t65e9d026b89dffdf@mail.gmail.com> Date: Wed, 26 Jul 2006 16:51:34 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: create table problems MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_12597_2550803.1153947094139" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.38 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_10_20, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200607/225 X-Sequence-Number: 22471 ------=_Part_12597_2550803.1153947094139 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_12597_2550803.1153947094139 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline   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
------=_Part_12597_2550803.1153947094139--