Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 355899FC5A9 for ; Wed, 31 Oct 2007 12:46:43 -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 09333-06-4 for ; Wed, 31 Oct 2007 12:46:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56412.mail.re3.yahoo.com (web56412.mail.re3.yahoo.com [216.252.111.91]) by postgresql.org (Postfix) with SMTP id 058C19FC3C7 for ; Wed, 31 Oct 2007 11:50:57 -0300 (ADT) Received: (qmail 96182 invoked by uid 60001); 31 Oct 2007 14:50:51 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=j+GAl0csGeF2jDT8n3Iab9+iFG0NoZk0PmfpwJ11sX7TZBgd9JAuj3eM4OiptdquyG5bg7+MDGlqBV6ceWH1JB89begMo5eVHpTgIRdtyC8WIDCJcVT/11oDNepCP9qjGdtllCVV42JEDejStjlNRp+1XNZoDLHnfHLit8/Fu7E=; X-YMail-OSG: vPchcicVM1lwaYwmswBP5NiHszXt88ExGSvhfcAQxA4IyNLhOTLYIdxggTUfw7Jko3I.f4QDBwkxcrec4xxC48YO5E7ZfgS3SWmPuHwXinBXlz6aiG99pVoiswVwlg-- Received: from [198.119.134.32] by web56412.mail.re3.yahoo.com via HTTP; Wed, 31 Oct 2007 07:50:51 PDT Date: Wed, 31 Oct 2007 07:50:51 -0700 (PDT) From: Jessica Richard Subject: how to check objects dependency?? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2122854017-1193842251=:93368" Content-Transfer-Encoding: 8bit Message-ID: <906847.93368.qm@web56412.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/314 X-Sequence-Number: 27228 --0-2122854017-1193842251=:93368 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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? Thanks, Jessica __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-2122854017-1193842251=:93368 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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?

Thanks,
Jessica

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com --0-2122854017-1193842251=:93368--