Re: 8.3-beta4, analyze and db owner

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL General ML <pgsql-general(at)postgresql(dot)org>, Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: 8.3-beta4, analyze and db owner
Date: 2008-01-15 23:01:24
Message-ID: 20080115230124.GN4473@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

Clodoaldo escribió:

> > > fahstats=> analyze;
> > > WARNING: skipping "pg_authid" --- only table or database owner can analyze it

> The problem with that warning message is that it implies that the db
> owner can analyze them which can not be done according to your
> comment. The message, if emited, should say then that only superuser
> can analyze those tables.

How about this patch.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Attachment Content-Type Size
vacuum-complaint.patch text/x-diff 3.6 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-01-15 23:02:25 Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?
Previous Message Justin Pasher 2008-01-15 22:53:26 Re: Clearing old user ids completely

Browse pgsql-patches by date

  From Date Subject
Next Message Stefan Schwarzer 2008-01-16 11:26:00 Re: Forgot to dump old data before re-installing machine
Previous Message Greg Smith 2008-01-15 20:14:56 Re: SSL over Unix-domain sockets