David Galkowski writes:
> On Mon, Aug 9, 2010 at 9:29 PM, Tom Lane wrote:
>> Works for me ... what PG version are you dealing with?
> 8.1.11
Oh. This is something we fixed in 8.2 and beyond:
http://archives.postgresql.org/pgsql-committers/2006-09/msg00101.php
It was not possible to back-patch
8.1.11
On Mon, Aug 9, 2010 at 9:29 PM, Tom Lane wrote:
> David Galkowski writes:
>> In order to consolidate two users, user1 and user2, in the database I
>> changed the owner of all tables and views that user2 owned to be owned
>> by user1. I then revoked all remaining privileges from user2 and
David Galkowski writes:
> In order to consolidate two users, user1 and user2, in the database I
> changed the owner of all tables and views that user2 owned to be owned
> by user1. I then revoked all remaining privileges from user2 and
> dropped the role. During this process I changed both table
In order to consolidate two users, user1 and user2, in the database I
changed the owner of all tables and views that user2 owned to be owned
by user1. I then revoked all remaining privileges from user2 and
dropped the role. During this process I changed both table1 and view1
(that selects from ta
