Re: [PATCH] Add size/acl information when listing databases - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] Add size/acl information when listing databases
Date
Msg-id 3235.1200803657@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Add size/acl information when listing databases  (Andrew Gilligan <andy@tcpd.net>)
Responses Re: [PATCH] Add size/acl information when listing databases  (Andrew Gilligan <andy@tcpd.net>)
List pgsql-hackers
Andrew Gilligan <andy@tcpd.net> writes:
> Showing the size on \l+ probably makes more sense, but I imagine that
> would require a very different approach due to the permissions changes?

I haven't experimented, but perhaps something along the lines of
case when has_database_privilege(current_user, db.oid, 'connect')then pg_database_size...else nullend

would fix it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Gilligan
Date:
Subject: Re: [PATCH] Add size/acl information when listing databases
Next
From: Andrew Gilligan
Date:
Subject: Re: [PATCH] Add size/acl information when listing databases