X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C95EDD1B285 for ; Wed, 21 Jul 2004 07:13:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41646-03 for ; Wed, 21 Jul 2004 10:13:37 +0000 (GMT) Received: from curie.credativ.org (credativ.com [217.160.209.18]) by svr1.postgresql.org (Postfix) with ESMTP id 6225CD1B1B8 for ; Wed, 21 Jul 2004 07:13:33 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by curie.credativ.org (Postfix) with ESMTP id F2E3955BCC; Wed, 21 Jul 2004 12:13:33 +0200 (CEST) Received: from www.credativ.de (pD9501026.dip0.t-ipconnect.de [217.80.16.38]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by curie.credativ.org (Postfix) with ESMTP id 9E84955BCA; Wed, 21 Jul 2004 12:13:33 +0200 (CEST) Received: from bell.credativ.de (bell.credativ.de [172.26.14.16]) by www.credativ.de (Postfix) with ESMTP id 719671C0004; Wed, 21 Jul 2004 12:13:32 +0200 (CEST) From: Peter Eisentraut To: Howard Bagcat Subject: Re: execute user-defined BKI Date: Wed, 21 Jul 2004 12:13:30 +0200 User-Agent: KMail/1.6.2 Cc: pgsql-admin@postgresql.org References: <1090374725.40fdcc458ece6@sulat.mu.edu.ph> <200407210929.42398.peter_e@gmx.net> <1090402095.40fe372f2ab14@sulat.mu.edu.ph> In-Reply-To: <1090402095.40fe372f2ab14@sulat.mu.edu.ph> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200407211213.30874.peter_e@gmx.net> X-Virus-Scanned: by AMaViS at credativ.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/237 X-Sequence-Number: 14305 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/