Sorry to folowup on my own post....
Problem solved: real and test db don't run on the same machine.
On the test one, postgres had the same uid as pg_shadow.usesysid for the
user...
Sorry to have bothered you all.
Reagrds
On Wed, 10 Jan 2001, Olivier PRENANT wrote:
> Hi,
>
> I just recompiled 7.1 beta from current CVS today.
>
> I pg_dump'ed my 7.02 db's and reloaded it on 7.1 with no probs apart that
> psql -l shows 2 template0 and template1...
>
> Template0 and template1 belong to user postgres and to an other who has no
> priviledges and no db!!!
>
> What makes me think it's a psql bug is that select * from pg_databases
> show 1 template0 and 1 template1.
>
> For what it's worth, it on unixware 711.
>
> BTW, when is the release due for? I'm VERY impatient. This is the best
> I've seen.
>
> Regards,,
>
>
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
