[GENERAL] Strange security issue with Superuser access

I ran into this yesterday and I wanted to post this to see if this is working as expected or it is a bug. By creating 2 tables and creating a FK between them and then changing the owner of the tables to a group, I lost the ability to insert into the first table executing as SUPERUSER. I thought th

Re: [GENERAL] Strange security issue with Superuser access

mail or am I just a poor reader? > > On Mon, 9 Mar 2015 17:00:14 -0400 > Andrzej Pilacik wrote: > > > I ran into this yesterday and I wanted to post this to see if this is > > working as expected or it is a bug. > > > > By creating 2 tables and creating a FK betwee

Re: [GENERAL] Strange security issue with Superuser access

SUPERUSER not able to insert the data when the constraint is introduced. On Tue, Mar 10, 2015 at 10:16 AM, Adrian Klaver wrote: > On 03/10/2015 05:41 AM, Stephen Frost wrote: > >> * Andrzej Pilacik (cypise...@gmail.com) wrote: >> >>> Can anyone explain how the FK constr

[GENERAL] orphan records in pg_class

I inherited a 8.4.9 500gb database. After doing some analysis on it I found two issues that I am not sure how to handle. 1. There is an object in pg_class that I can only query by oid or by using ilike instead of = . That objects also only exists in pg_class, it does not exist in pg_depend nor d