Re: duplicate templates, wrong users

On Wed, Dec 05, 2001 at 03:23:42PM -0500, Yanek Korff wrote:
...
> here's pg_user:
> usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
> passwd | valuntil
> ------------+----------+-------------+----------+----------+-----------+----
> ------+----------
> pgsql | 72 | t | t | t | t |
> ******** |
> os_user | 71 | t | f | t | t |
> ******** |
> user3 | 75 | f | f | f | f |
> ******** |
> user1 | 72 | f | f | f | f |
> ******** |
> user2 | 73 | f | f | f | f |
> ******** |
...
> What's with the duplicate databases?

I think the problem is really the duplicate in usesysid - pgsql and user1
both have usesysid=72.

Cheers,

Patrick