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