Re: PostgreSQL 8.0 bug or my own stupidity?

[Tom <tom@abwaerts.be>]

[11/07/2005 -- 17:10u] Clive Menzies:

<cut>

> > > I did the following as postgres:
> > > 
> > > $ psql 
> > > 
> > > and then created created users using SQL.
> >
> > what do you mean with "as postgres"?

<cut>

> $ su
> password
> 
> # su postgres
> (no passwd required)

When I try that, I get this:

[17:56:53 tom ~] su
Password: 
[root: /home/tom] su postgres
[root: /home/tom] psql 
psql: FATAL:  database "root" does not exist

Thanks,
Tom

-- 
keys: http://tmp.verbreyt.be/files/ (abwaerts.asc & verbreyt.asc)
 ---
np: Boyd Rice & Fiends - Their Bad Blood