Re: [PATCH] Add size/acl information when listing databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Gilligan <andy(at)tcpd(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] Add size/acl information when listing databases
Date: 2008-01-20 04:34:17
Message-ID: 3235.1200803657@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Gilligan <andy(at)tcpd(dot)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 null
end

would fix it.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gilligan 2008-01-20 05:27:05 Re: [PATCH] Add size/acl information when listing databases
Previous Message Andrew Gilligan 2008-01-20 04:18:17 Re: [PATCH] Add size/acl information when listing databases