Psql displays twice tables, views, indices, sequences etc.

prova=> \d
Database    = prova
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | postgres         | aggtest1                         | table    |
 | postgres         | aggtest1                         | table    |
 | postgres         | books                            | table    |
 | postgres         | books                            | table    |
 | postgres         | patrons                          | table    |
 | postgres         | patrons                          | table    |
 | postgres         | poll                             | table    |
 | postgres         | poll                             | table    |
 | postgres         | transactions                     | table    |
 | postgres         | transactions                     | table    |
 | postgres         | vbooks                           | view?    |
 | postgres         | vbooks                           | view?    |
 +------------------+----------------------------------+----------+

prova=> select version();
version
-------------------------------------------------------------------
PostgreSQL 6.5.0 on i586-pc-linux-gnulibc1, compiled by gcc 2.7.2.1
(1 row)

Josï¿½



Psql displays twice tables, views, indices, sequences etc.
prova=> \d
Database    = prova
 +------------------+----------------------------------+----------+
 |  Owner          
|            
Relation            
|   Type   |
 +------------------+----------------------------------+----------+
 | postgres        
| aggtest1                        
| table    |
 | postgres        
| aggtest1                        
| table    |
 | postgres        
| books                           
| table    |
 | postgres        
| books                           
| table    |
 | postgres        
| patrons                         
| table    |
 | postgres        
| patrons                         
| table    |
 | postgres        
| poll                            
| table    |
 | postgres        
| poll                            
| table    |
 | postgres        
| transactions                    
| table    |
 | postgres        
| transactions                    
| table    |
 | postgres        
| vbooks                          
| view?    |
 | postgres        
| vbooks                          
| view?    |
 +------------------+----------------------------------+----------+
prova=> select version();
version
-------------------------------------------------------------------
PostgreSQL 6.5.0 on i586-pc-linux-gnulibc1, compiled by gcc 2.7.2.1
(1 row)
José
Mon, 26 Apr 1999 15:40:43 +0200
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
psql bug ?
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com> writes:
> Psql displays twice tables, views, indices, sequences etc.

Not seeing that here... might be time for a rebuild and initdb?

			regards, tom lane

Mon, 26 Apr 1999 10:57:46 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] psql bug ? 
> =?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com> writes:
> > Psql displays twice tables, views, indices, sequences etc.
> 
> Not seeing that here... might be time for a rebuild and initdb?
> 

Or perhaps there are two entries in pg_user/pg_shadow for the same name.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 26 Apr 1999 11:18:06 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] psql bug ?


Bruce Momjian ha scritto:

> > =?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com> writes:
> > > Psql displays twice tables, views, indices, sequences etc.
> >
> > Not seeing that here... might be time for a rebuild and initdb?
> >
>
> Or perhaps there are two entries in pg_user/pg_shadow for the same name.
>

Yes, this was the cause.  I don't know how but I had two users with the same
name.
Thank you.
Josï¿½



Tue, 27 Apr 1999 09:19:20 +0200
=?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
Re: [HACKERS] psql bug ?