Re: Recursive SELECT problem - Mailing list pgsql-sql

From Dave Page
Subject Re: Recursive SELECT problem
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40138826D@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Recursive SELECT problem  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-sql

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 17 May 2006 15:07
> To: Dave Page
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Recursive SELECT problem
>
> "Dave Page" <dpage@vale-housing.co.uk> writes:
> > I'm trying to write a query to determine whether or not the current
> > login role has CREATEDB (or CREATEROLE) privileges, either
> directly or
> > inherited from a parent role.
>
> Those privileges don't inherit, so I'm not sure why you need
> a recursive check.

Because I didn't realise they didn't inherit 'cos I missed the note at
the bottom of the CREATE ROLE page :-)

Thanks - that makes life significantly easier!

Regards, Dave.


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recursive SELECT problem
Next
From: Tom Lane
Date:
Subject: Re: Table constraints and INSERT