Re: [GENERAL] 8.3-beta4, analyze and db owner

2008-01-15 Thread Alvaro Herrera
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,

Re: [GENERAL] 8.3-beta4, analyze and db owner

2008-01-06 Thread Clodoaldo
2008/1/6, Magnus Hagander <[EMAIL PROTECTED]>: > Clodoaldo wrote: > > I'm the owner of a database and when i issue an analyze command on it, > > the pg tables are skipped with the message that only the owner can > > analyze them: > > > > $ psql fahstats -U cpn > > Welcome to psql 8.3beta4, the Post

Re: [GENERAL] 8.3-beta4, analyze and db owner

2008-01-06 Thread Magnus Hagander
Clodoaldo wrote: I'm the owner of a database and when i issue an analyze command on it, the pg tables are skipped with the message that only the owner can analyze them: $ psql fahstats -U cpn Welcome to psql 8.3beta4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms

[GENERAL] 8.3-beta4, analyze and db owner

2008-01-06 Thread Clodoaldo
I'm the owner of a database and when i issue an analyze command on it, the pg tables are skipped with the message that only the owner can analyze them: $ psql fahstats -U cpn Welcome to psql 8.3beta4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help