Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql bug ?

psql bug ?

From
José Soares
Date:
<tt>Psql displays twice tables, views, indices, sequences etc.</tt><tt></tt><p><tt>prova=> \d</tt><br
/><tt>Database   = prova</tt><br /><tt> +------------------+----------------------------------+----------+</tt><br
/><tt> | Owner           |             Relation             |   Type   |</tt><br
/><tt> +------------------+----------------------------------+----------+</tt><br/><tt> | postgres         |
aggtest1                        | table    |</tt><br /><tt> | postgres         | aggtest1                         |
table   |</tt><br /><tt> | postgres         | books                            | table    |</tt><br /><tt> |
postgres        | books                            | table    |</tt><br /><tt> | postgres         |
patrons                         | table    |</tt><br /><tt> | postgres         | patrons                          |
table   |</tt><br /><tt> | postgres         | poll                             | table    |</tt><br /><tt> |
postgres        | poll                             | table    |</tt><br /><tt> | postgres         |
transactions                    | table    |</tt><br /><tt> | postgres         | transactions                     |
table   |</tt><br /><tt> | postgres         | vbooks                           | view?    |</tt><br /><tt> |
postgres        | vbooks                           | view?    |</tt><br
/><tt> +------------------+----------------------------------+----------+</tt><tt></tt><p><tt>prova=>select
version();</tt><br/><tt>version</tt><br
/><tt>-------------------------------------------------------------------</tt><br/><tt>PostgreSQL 6.5.0 on
i586-pc-linux-gnulibc1,compiled by gcc 2.7.2.1</tt><br /><tt>(1 row)</tt><tt></tt><p><tt>José</tt><br /><tt></tt> 

Re: [HACKERS] psql bug ?

From
Tom Lane
Date:
José 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

Re: [HACKERS] psql bug ?

From
Bruce Momjian
Date:
> José 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,
Pennsylvania19026

Re: [HACKERS] psql bug ?

From
José Soares
Date:

Bruce Momjian ha scritto:

> > José 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é