PROTECTED]
Subject: Re: [ADMIN] Duplicate indexes found in the postgres Database
"Chris White" <[EMAIL PROTECTED]> writes:
> How do I look at the catalogs and which ones do I need to look at?
Now that I look at it, pg_tables is not a join in 7.2, but just a
straight select from pg_cla
esop_gui=arwdRxt}
(2 rows)
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 01, 2003 12:42 PM
To: Chris White
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Duplicate indexes found in the postgres Database
"Chris White" <[EMAIL PROTECTED
"Chris White" <[EMAIL PROTECTED]> writes:
> User was able to recreate the problem, but this time only on table got
> duplicated 'gui_config'. So here is the info you wanted:
> select ctid,xmin,xmax,oid,* from pg_class where relname = 'gui_config';
> ctid | xmin | xmax | oid | relname | rel
esop_gui=arwdRxt}
(2 rows)
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 01, 2003 12:42 PM
To: Chris White
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Duplicate indexes found in the postgres Database
"Chris White" <[EMAIL PROTECTED
"Chris White" <[EMAIL PROTECTED]> writes:
> How do I look at the catalogs and which ones do I need to look at?
Now that I look at it, pg_tables is not a join in 7.2, but just a
straight select from pg_class. So the problem is definitely in
pg_class. Let's see the results of
select ctid,xmin,xma
ry 01, 2003 9:31 AM
To: Chris White
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Duplicate indexes found in the postgres Database
"Chris White" <[EMAIL PROTECTED]> writes:
> While interrogating the table information for our database, I notice that
> some tables (i.e. gui_con
"Chris White" <[EMAIL PROTECTED]> writes:
> While interrogating the table information for our database, I notice that
> some tables (i.e. gui_config, vm_mailbox, vm_message) have duplicate
> entries. Does anybody know why this would occur and is it a problem?
Probably it is :-(. You'll need to di
While interrogating the table information for our database, I notice that
some tables (i.e. gui_config, vm_mailbox, vm_message) have duplicate
entries. Does anybody know why this would occur and is it a problem?
Attached are appropriate outputs. Queries on the tables which are duplicated
in the ent
