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)


Wed, 10 Jan 2001 19:43:05 +0100 (MET)
Olivier PRENANT <ohp@pyrenet.fr>
psql -l bug
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.

For more info (don't think it's a bug) I see two templates db too.

> BTW, when is the release due for? I'm VERY impatient. This is the best
> I've seen.

I'm looking forword to seeing the release of 7.1.



System Administration: It's a dirty job, 
but someone told I had to do it.
-----------------------------------------------------------------
Martï¿½n Marquï¿½s			email: 	martin@math.unl.edu.ar
Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------


Wed, 10 Jan 2001 15:51:35 -0300 (ART)
"Martin A. Marques" <martin@math.unl.edu.ar>
Re: psql -l bug
* Olivier PRENANT <ohp@pyrenet.fr> [010110 12:47]:
> 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.
I'm also on UW711, and do *NOT* see the bug:

Password: 
        List of databases
 Database  |  Owner   | Encoding  
-----------+----------+-----------
 ler       | ler      | SQL_ASCII
 postgres  | postgres | SQL_ASCII
 template0 | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII
(4 rows)

> 
> 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)

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Wed, 10 Jan 2001 12:55:05 -0600
Larry Rosenman <ler@lerctr.org>
Re: psql -l bug
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)


Wed, 10 Jan 2001 19:55:10 +0100 (MET)
Olivier PRENANT <ohp@pyrenet.fr>
Re: psql -l bug
As I said previously.. I apologies, this was all my fault.

Please discard...

Oh my, When will we have an RC???


On Wed, 10 Jan 2001, Larry Rosenman wrote:

> * Olivier PRENANT <ohp@pyrenet.fr> [010110 12:47]:
> > 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.
> I'm also on UW711, and do *NOT* see the bug:
> 
> Password: 
>         List of databases
>  Database  |  Owner   | Encoding  
> -----------+----------+-----------
>  ler       | ler      | SQL_ASCII
>  postgres  | postgres | SQL_ASCII
>  template0 | postgres | SQL_ASCII
>  template1 | postgres | SQL_ASCII
> (4 rows)
> 
> > 
> > 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)
> 
> 

-- 
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)


Wed, 10 Jan 2001 22:03:25 +0100 (MET)
Olivier PRENANT <ohp@pyrenet.fr>
Re: psql -l bug
* Olivier PRENANT <ohp@pyrenet.fr> [010110 15:03]:
> As I said previously.. I apologies, this was all my fault.
> 
> Please discard...
> 
> Oh my, When will we have an RC???
SOON.  I'm running the BETA,....

LER

> 
> 
> On Wed, 10 Jan 2001, Larry Rosenman wrote:
> 
> > * Olivier PRENANT <ohp@pyrenet.fr> [010110 12:47]:
> > > 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.
> > I'm also on UW711, and do *NOT* see the bug:
> > 
> > Password: 
> >         List of databases
> >  Database  |  Owner   | Encoding  
> > -----------+----------+-----------
> >  ler       | ler      | SQL_ASCII
> >  postgres  | postgres | SQL_ASCII
> >  template0 | postgres | SQL_ASCII
> >  template1 | postgres | SQL_ASCII
> > (4 rows)
> > 
> > > 
> > > 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)
> > 
> > 
> 
> -- 
> 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)

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Wed, 10 Jan 2001 15:05:02 -0600
Larry Rosenman <ler@lerctr.org>
Re: psql -l bug