Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0DD189FB787 for ; Tue, 17 Apr 2007 10:14:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 31803-02 for ; Tue, 17 Apr 2007 10:14:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from smtp102.mail.mud.yahoo.com (smtp102.mail.mud.yahoo.com [209.191.85.212]) by postgresql.org (Postfix) with SMTP id 79AB29FB75B for ; Tue, 17 Apr 2007 10:14:47 -0300 (ADT) Received: (qmail 73131 invoked from network); 17 Apr 2007 13:14:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=100Io+GjjvRNuLLFTvxJGlfJBxm/W+1S5QOXrE+dgwhcx3Pfi2d3daVK0TDlarqP19xf+TpC7/SWqCSW5zBAU362CVPVT8AStsZMOwQmOORHMWQNq1ZHZ4JzfYoVe1i40mHrqrIYKm+YrCohlUis8t7trZHZrNz50wZ3+BtcmHM= ; Received: from unknown (HELO ?10.90.2.103?) (burbello3000@200.103.143.8 with plain) by smtp102.mail.mud.yahoo.com with SMTP; 17 Apr 2007 13:14:43 -0000 X-YMail-OSG: QEDx0r0VM1kTe1Fzu_BOcA1CKUlXZp.0YRtSubC9K1kUrXLMX3BRxUmAK2rR4LUipTjTmG81dQ-- Message-ID: <4624C830.1070106@yahoo.com.br> Date: Tue, 17 Apr 2007 10:14:24 -0300 From: "Alexander B." User-Agent: Thunderbird 1.5.0.7 (X11/20060911) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: waiting status Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/152 X-Sequence-Number: 25216 Hi, I constantly get 'waiting' status when I execute some ddl statement and some client connections is in idle transaction. For example, try to remove not null constraint and has client connection in "idle in transaction" status. This situation always get TABLE waiting. Another situation, is to drop a table and for sure doesn't have transactions involved, and always get status "DROP TABLE waiting" Is this normal? Other databases doesn't happen this. Thanks in advance Enviroment: PostgreSQL 8.1.4 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC) 3.3.5 (Debian 1:3.3.5-13)