On Thu, 2005-05-12 at 16:15 -0400, Tom Lane wrote: > "Madeleine Theile" <mt@xxxxxxxxxx> writes: > > But what if he doesn't? Then the only possibility is to drop all the > > views and recreate them as another user in order to fix the issue with > > the acl rights. > > See ALTER OWNER. The intention is to make you give away all the owned > objects before getting rid of the user. > > regards, tom lane > Try it, it doesn't work! I can give you examples in case you need them. Cheers, Madeleine ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)