Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-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                      
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Attachment: vacuum-complaint.patch
Description: text/x-diff (3.6 KB)

In response to

pgsql-patches by date

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

pgsql-general by date

Next:From: Alvaro HerreraDate: 2008-01-15 23:02:25
Subject: Re: ATTN: Clodaldo was Performance problem. Could it berelated to 8.3-beta4?
Previous:From: Justin PasherDate: 2008-01-15 22:53:26
Subject: Re: Clearing old user ids completely

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group