Re: Users, Roles and Connection Pooling

2019-10-02 Thread Matt Andrews
privileges for many people, but many different privileges for a few people. Does it come down to performance issues when there are many roles to users? On Wed, 2 Oct 2019 at 21:03, Rob Sargent wrote: > > > On Oct 2, 2019, at 3:41 AM, Matt Andrews > wrote: > > I have little exper

Re: Users, Roles and Connection Pooling

2019-10-02 Thread Matt Andrews
, maybe earlier. > > While this seems plausible- I'd love to hear about exactly what you've > seen start to be a problem when getting up to that many users. Are you > just referring to things like \du? Or..? > > Thanks, > > Stephen > -- Matt Andrews 0400 990 131

Users, Roles and Connection Pooling

2019-10-01 Thread Matt Andrews
app users through a connection pool. I’m thinking that any queries should start with SET ROLE ‘username’ and end with RESET ROLE. Is this how it could work? Any help would be greatly appreciated. -- Matt Andrews 0400 990 131

Re: Mapping view columns to their source columns

2019-09-24 Thread Matt Andrews
1 On Wed, Sep 25, 2019 at 2:54 PM Tom Lane wrote: > Matt Andrews writes: > > I'm trying to map view columns to their source columns using the system > > catalogs and information schema, but not having much luck. It's easy to > > determine which columns a vie

Mapping view columns to their source columns

2019-09-24 Thread Matt Andrews
t want to manipulate the returned data based on the types/constraints of the underlying columns of the view. It seems like mapping view columns to their source columns should be something that's been done before. Is it possible? Matt Andrews 0400 990 131