Received: from sss.pgh.pa.us (sss.pgh.pa.us [216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f49ErUA62876 for ; Wed, 9 May 2001 10:53:30 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f49ErDR20551; Wed, 9 May 2001 10:53:13 -0400 (EDT) To: bboett@erm1.u-strasbg.fr (Bruno Boettcher) cc: pgsql-sql@postgresql.org Subject: Re: no more pg_dump cause of multiple declared database?? In-reply-to: <20010509091209.B16061@erm1.u-strasbg.fr> References: <20010509091209.B16061@erm1.u-strasbg.fr> Comments: In-reply-to bboett@erm1.u-strasbg.fr (Bruno Boettcher) message dated "Wed, 09 May 2001 09:12:09 +0200" Date: Wed, 09 May 2001 10:53:13 -0400 Message-ID: <20548.989419993@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/62 X-Sequence-Number: 2863 bboett@erm1.u-strasbg.fr (Bruno Boettcher) writes: > fibu=# \l > List of databases > Database | Owner | Encoding > -----------+----------+----------- > admin | www | SQL_ASCII > fibu | bboett | SQL_ASCII > fibu | hordemgr | SQL_ASCII > horde | www | SQL_ASCII > template0 | postgres | SQL_ASCII > template1 | postgres | SQL_ASCII > (6 rows) > how can this be? You have multiple users registered in pg_shadow with the same usesysid. Alter the usesysid of the one you don't want to own that database. (You will then have to find the objects he *should* own, and fix their owner ID values...) There should be a unique index on pg_shadow.usesysid, but due to an old oversight there isn't. Fixing this is on the TODO list. regards, tom lane