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

Re: execute user-defined BKI

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Howard Bagcat <howard(at)mu(dot)edu(dot)ph>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: execute user-defined BKI
Date: 2004-07-21 10:13:30
Message-ID: 200407211213.30874.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-admin
Am Mittwoch, 21. Juli 2004 11:28 schrieb Howard Bagcat:
> Now, my problem pg_dump and pg_dumpall displayed a lot of WARNING messages,
> like:
>
> "pg_dump: WARNING: owner of table "triggers" appears to be invalid."

Then you need to manually recreate all those users with the right user IDs.  
The user IDs are shown in the owner column of the respective system tables 
(e.g., pg_trigger).

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2004-07-21 14:53:49
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Howard BagcatDate: 2004-07-21 09:28:15
Subject: Re: execute user-defined BKI

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