Duplicate in pg_user table

From: CHEWTC(at)ap(dot)nec(dot)com(dot)sg
To: pgsql-performance(at)postgresql(dot)org
Subject: Duplicate in pg_user table
Date: 2003-10-27 04:27:29
Message-ID: OF718DF9DE.D1ED309B-ON48256DCC.00182BA4@nec.com.sg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi

Currently we are running Postgresql v7.3.2 on Redhat Linux OS v9.0. We have
Windows2000 client machines inserting records into the Postgresql tables
via the Postgres ODBC v7.3.0100.

After a few weeks of usage, when we do a \d at the sql prompt, there was a
duplicate object name in the same schema, ie it can be a duplicate row of
index or table.

When we do a \d table_name, it will show a duplication of column names
inside the table.

We discovered that the schema in the pg_user table was duplicated also;
thus causing the pg_dump to fail.

Thank you,
REgards.

Browse pgsql-performance by date

  From Date Subject
Next Message Dror Matalon 2003-10-27 04:54:31 Re: Various performance questions
Previous Message Greg Stark 2003-10-27 03:49:29 Re: Various performance questions