Re: duplicated Index entries

----- Original Message -----

From: Dave Page

To: Donald Fraser ; [pgADMIN]

Sent: Tuesday, May 04, 2004 9:33 AM

Subject: RE: [pgadmin-support] duplicated Index entries

Hi Donald,

 

Sorry for the delay in replying.

 

I've created the following objects using the latest CVS version of pgAdmin and see no duplicates - would you mind trying the same on your system please?

 

CREATE TABLE foo
(
  id serial NOT NULL,
  data varchar(32)
) WITHOUT OIDS;

CREATE INDEX foo_idx
  ON foo
  USING btree
  (ascii(data::text));

 

CREATE INDEX foo_idx2
  ON foo
  USING btree
  (ascii(data::text))
  WHERE id > 1;

 

Regards, Dave.

---

From: Donald Fraser [mailto:demolish@cwgsy.net]
Sent: 29 April 2004 17:42
To: [pgADMIN]
Subject: Re: [pgadmin-support] duplicated Index entries

Some more information to help solve this sneaky little bug!

 

The duplicated indexes are only on indexes that use a function!

For example:

 

CREATE INDEX tbl_cmpy_notumbrella_key
  ON tbl_cmpy
  USING btree
  (get_cmpyname(s_umbname, s_name))
  WHERE b_isumbrella IS NOT TRUE AND d_deceased IS NULL;

 

----- Original Message -----

From: Donald Fraser

To: [pgADMIN]

Sent: Thursday, April 29, 2004 5:30 PM

Subject: [pgadmin-support] duplicated Index entries

pgAdmin III version 1.0.2

 

On certain tables, under the Indexes tree view I am getting duplicated index entries but not on all entries.

For example I have a table that has 19 indexes yet the tree view shows 25 - hence it has duplicated 6 entries.

To prove that they were in fact duplicated:

a) each duplicated index has exactly the same details including the oid.

b) I deleted one of the duplicated entries and then did a refresh - the second entry was also removed.

 

Regards

Donald Fraser.