pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Jessica Richard <rjessil@yahoo.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: how to check objects dependency??
Date: Fri, 2 Nov 2007 16:30:52 -0300
Message-ID: <20071102193052.GC2374@alvh.no-ip.org> (raw)
In-Reply-To: <365368.53951.qm@web56411.mail.re3.yahoo.com>
References: <18966.1193860699@sss.pgh.pa.us>
	<365368.53951.qm@web56411.mail.re3.yahoo.com>

Jessica Richard wrote:
> Instead of using drop user username, I used drop user "username" with
> double quotes, then the error message told me more detail about a
> specific user defined function. Then I was able to drop that function,
> then drop this user.

FYI you can use the commands DROP OWNED and REASSIGN OWNED to drop the
objects by a given role, and respectively assign them to someone else.
(8.2 only).

-- 
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"Ninguna manada de bestias tiene una voz tan horrible como la humana" (Orual)



view thread (8+ messages)

Message-ID: <20071102193052.GC2374@alvh.no-ip.org>
Permalink:  ../20071102193052.GC2374@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20071102193052.GC2374@alvh.no-ip.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alvherre@commandprompt.com, rjessil@yahoo.com, tgl@sss.pgh.pa.us
  Subject: Re: how to check objects dependency??
  In-Reply-To: <20071102193052.GC2374@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox