Re: [GENERAL] alter table owner doesn't update acl information

2005-05-12 Thread Madeleine Theile
On Thu, 2005-05-12 at 16:15 -0400, Tom Lane wrote: > "Madeleine Theile" <[EMAIL PROTECTED]> 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 > >

Re: [GENERAL] alter table owner doesn't update acl information

2005-05-12 Thread Madeleine Theile
On Wed, 2005-05-11 at 12:04 -0400, Tom Lane wrote: > "Madeleine Theile" <[EMAIL PROTECTED]> writes: > > After I've dropped one of the superusers that created and thus > > owns some of the views and reinstalled it again with a different usesysid > &

[GENERAL] alter table owner doesn't update acl information

2005-05-11 Thread Madeleine Theile
Hi, first of all: I use Postgres-version: 7.3.9 and uname -a gives: Linux 2.4.21-286-smp4G Now here's the problem: I have several superusers in my database and some normal users that only have access to the data by views. After I've dropped one of the superusers that created and thus owns some o