psql bug ?
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�
=?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
Import Notes
Reply to msg id not found: YourmessageofMon26Apr1999154043+020037246CDB.555CDE53@sferacarta.com | Resolved by subject fallback
=?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 19026Bruce 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�