Re: [GENERAL] \d shows all my tables twice

You have duplicate entries in pg_shadow/pg_user table.


>
> I'm using the postgresql-6.5.3-1 rpm from PostgreSQLs website on
> redhat 6.0
>
> Some time between yesterday and today postgres developed the habit of
> listing all may table twice when I do \d or \dS from psql.  Right now
> this is only annoying, but does this mean there is a system corruption
> I need to fix?
>
> I've destroyed all my databases other than template1 and vacuumed in
> template1.  My next thought is to reinstall, but I'd rather not if I
> don't have too.
>
> --
> Karl DeBisschop <kdebisschop@alert.infoplease.com>
> 617.832.0332 (Fax: 617.956.2696)
>
> Information Please - your source for FREE online reference
> http://www.infoplease.com  - Your Ultimate Fact Finder
> http://kids.infoplease.com - The Great Homework Helper
>
> Netsaint Development
> http://netsaintplug.sourceforge.net
>
> ************
>
>


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