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