Re: [GENERAL] change owner strange behavior

2010-08-10 Thread David Galkowski
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

[GENERAL] change owner strange behavior

2010-08-09 Thread David Galkowski
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