Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EF1789FC509 for ; Wed, 31 Oct 2007 14:14:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 46668-02-3 for ; Wed, 31 Oct 2007 14:13:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 8E4639FC7E6 for ; Wed, 31 Oct 2007 13:04:46 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so327323ugf for ; Wed, 31 Oct 2007 09:04:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=wIoUdjoFGK07hjSjLgSAEXzuCTxzlREHgJWSP5O8G1g=; b=lrgQkH+pDzCdkgbrYcQv2hbuzTKDNQLi2RMfDIVr+c0QAKTtkU16X8AUqhnXYxt/jQfHDfjP6LUhyckYGkkBVD3uilFvODO70TmgymW8+1h7S3+UUrHAqqrUuS3EObVr+IWVF8SasT18/UzJ2lakwmApmsof63PsMeDw8QCLE/E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=H3nottFNGtFllCoQLFwzIKi8HT/kNDFqec1iN8vIV9dOvddHRDJLtvcqbW4aHh0bV8T9OBKLaDqiOzIieW6tCRc+ivEV5W1YWi4RWXryjKFQaFX6jws8SdnLDrW/oWrsY9StARNJ2egxBX+dG0yL/kClC/t7HFzD5hRrxEu9sMs= Received: by 10.67.119.15 with SMTP id w15mr1058395ugm.1193846685477; Wed, 31 Oct 2007 09:04:45 -0700 (PDT) Received: by 10.67.40.10 with HTTP; Wed, 31 Oct 2007 09:04:45 -0700 (PDT) Message-ID: Date: Wed, 31 Oct 2007 11:04:45 -0500 From: "Scott Marlowe" To: "Jessica Richard" Subject: Re: how to check objects dependency?? Cc: pgsql-admin@postgresql.org In-Reply-To: <906847.93368.qm@web56412.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <906847.93368.qm@web56412.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/317 X-Sequence-Number: 27231 On 10/31/07, Jessica Richard wrote: > I am trying to drop a user but it complained with the following message: > > ERROR: role "joe" cannot be dropped because some objects depend on it > DETAIL: 1 objects in database Jan_test > 1 objects in database Jan > > this user does not own any tables in those two databases. Is there any > command I can use to check all the dependencies on this user? What version of pgsql are you running? In 8.2 I get a more useful error message for a table that is owned by a user, i.e.: ERROR: role ... cannot be dropped ... DETAIL: owner of table Have you looked in the logs to see if something like that shows up in them?