On Fri, 6 Apr 2001, Tom Lane wrote:
> On closer look, I'll bet that "brandon" and "postgres" have the
> same usesysid assigned in pg_shadow. Need to change one of them.
That was it - both were 501.
Thanks.
--
Dominic J. Eidson
"Baruk Khazad! Khazad ai
Vacuuming pg_database should make the bogus entries go away ...
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
"Dominic J. Eidson" <[EMAIL PROTECTED]> writes:
>> postgres | brandon <-- Incorrect
>> postgres | postgres
>> smc_is_neteng | dominic
>> template1 | brandon <-- Incorrect
>> template1 | postgres
>> wwwrun| brandon <-- Incorrect
>> wwwrun| postgres
>
I just love to reply to myself..
On Fri, 6 Apr 2001, Dominic J. Eidson wrote:
[Snip]
> postgres | brandon <-- Incorrect
> postgres | postgres
> smc_is_neteng | dominic
> template1 | brandon <-- Incorrect
> template1 | postgres
> wwwrun| brandon <-
dominic=# \l
List of databases
Database| Owner
---+--
aleal | aleal
arivera | arivera
bbeyer| bbeyer
brandon | brandon
brandon | postgres
dominic | dominic
ds3 | agould
keystone | dominic
kperoni
