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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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