Postgres Pro
Downloads
Home   >   mailing lists

privs drop after alter table - Mailing list pgsql-general

From Gauthier, Dave
Subject privs drop after alter table
Date
Msg-id 0AD01C53605506449BA127FB8B99E5E10C37E452@FMSMSX105.amr.corp.intel.com
Whole thread Raw
Responses Re: privs drop after alter table
List pgsql-general
Tree view

v8.3.4 on linux

 

After this..

alter table fred alter column wilma set default 'dino';

 

...it appeared that a user that had insert,delete,update privs lost them.

I regranded and things went back to normal.

 

Is it correct for those privs to be dropped in this case?  If so, why (just curious).

 

Thanks in Advance

pgsql-general by date:

Previous
From: Darren Duncan
Date:
Subject: Re: Uppercase to lowercase trigger?
Next
From: Michael Nolan
Date:
Subject: Re: Issue with rsync based incremental backup : postgres: startup process waiting for 0000000100000001000000D2