Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BBADB37BD6C for ; Thu, 2 Oct 2008 08:33:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 74562-01 for ; Thu, 2 Oct 2008 08:33:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f21.google.com (mail-gx0-f21.google.com [209.85.217.21]) by postgresql.org (Postfix) with ESMTP id CC48037BC9D for ; Thu, 2 Oct 2008 08:33:47 -0300 (ADT) Received: by gxk14 with SMTP id 14so1201360gxk.19 for ; Thu, 02 Oct 2008 04:33:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=927IK91F7tclPV7EOuXhelVgXjIIT8Ak/3zeuTJ1/pk=; b=D4ewaMXXBb0iDf5MTLtuK7yslsu/cDebOdYDMg6GHPABlTQ4inxQoUqXuB3cXlmX29 u1fMzt4391p+eA7vGFRNVCKrjCv4dBYwzQqjnfdH4sBwbAYjKDAqimNrpiIioccVW3gT p/eML50/pzesNkSh2JcXeSIUJq5AREIIQ4ZUI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=sMnKEu6AF86UZ0LZVu7Dh6jPbKQum7XXgkVHFgr0xkNmzwZBLQqRkS0ljc4j2o58SE /XMJm94775Q+fc+JD5hvF0/ASxmE46Ui9jZcKK4337TTUnYW5LedzSV/idm7L9eMvplz uBMihh9zppN3k6L3hMVDEkqkMA11gPNEBUXCk= Received: by 10.151.6.16 with SMTP id j16mr13974056ybi.72.1222947225609; Thu, 02 Oct 2008 04:33:45 -0700 (PDT) Received: by 10.151.102.14 with HTTP; Thu, 2 Oct 2008 04:33:44 -0700 (PDT) Message-ID: <48d0cacb0810020433k1eadf01ckaee4990fc25ab5c6@mail.gmail.com> Date: Thu, 2 Oct 2008 08:33:44 -0300 From: "Daniel Cristian Cruz" To: pgsql-admin@postgresql.org Subject: DROP TABLE waiting for pg_dump MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_865_9115330.1222947224967" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200810/4 X-Sequence-Number: 30460 ------=_Part_865_9115330.1222947224967 Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit Content-Disposition: inline Helllo, I had a huge database with a dump backup routine. I had a problem today, where pg_dump was locking a concurrent DROP TABLE, and it was another table, not the table in the COPY running. Is it normal? Some kind of bug or is it expected? I'm using 8.2.4 (I need to rewrite dblink functions before upgrade). Regards, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル ------=_Part_865_9115330.1222947224967 Content-Type: text/html; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit Content-Disposition: inline

Helllo,

I had a huge database with a dump backup routine.

I had a problem today, where pg_dump was locking a concurrent DROP TABLE, and it was another table, not the table in the COPY running. Is it normal? Some kind of bug or is it expected?

I'm using 8.2.4 (I need to rewrite dblink functions before upgrade).

Regards,

--
Daniel Cristian Cruz
クルズ  クリスチアン ダニエル
------=_Part_865_9115330.1222947224967--