Horton

Re: dangling permission on tables after drop user.

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Vivek Khera <khera@kcilink.com>
Cc: pgsql-general@postgresql.org
Date: 2004-09-29T20:55:14Z
Lists: pgsql-general 
Vivek Khera wrote:
> 
> there is no user with ID 102 in the pg_user view.  pg_restore complains 
> about the missing user "102".  And no, the user was not "102" it was the 
> name of a (former) employee.

> The gross hack is to pg_restore to an ascii file and delete those GRANT 
> lines, but the compressed dump is over 2Gb for this database.

Am I missing something Vivek, or should the gross hack be "creating a 
user with id=102" ?

-- 
   Richard Huxton
   Archonet Ltd