Thank you Tom and Albe. After grant connect database privilege to user test, the query runs without problem. Thanks, Suya -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Thursday, May 08, 2014 12:13 AM To: Albe Laurenz Cc: Huang, Suya; 'pgsql-general General' Subject: Re: [GENERAL] ERROR: permission denied for database control Albe Laurenz <laurenz.albe@xxxxxxxxxx> writes: > Suya Huang wrote: >> --fails if try to get all db size in one sql postgres=> SELECT >> current_date,pg_database_size(pg_database.datname) from pg_database; >> ERROR: permission denied for database control > It seems like you have a database called "control" for which user "test" > has no connect privilege. Yeah, this failure is unsurprising. But it looks like we forgot to document the restriction :-(. I see a mention of it in the 8.3 release notes, but there's nothing in the documentation of the functions themselves. Will fix. regards, tom lane
