Re: duplicate templates, wrong users - Mailing list pgsql-general

From Patrick Welche
Subject Re: duplicate templates, wrong users
Date
Msg-id 20011210191640.F2303@quartz.newn.cam.ac.uk
Whole thread Raw
In response to duplicate templates, wrong users  ("Yanek Korff" <yanek@cigital.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: problem with select after updating
Next
From: "Robert B. Easter"
Date:
Subject: Re: What is the practical limitation of no multi-threading?