From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Donald Fraser" <demolish(at)cwgsy(dot)net>, "[pgADMIN]" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: duplicated Index entries |
Date: | 2004-05-04 08:33:52 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B889FC0D@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)cwgsy(dot)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 <mailto:demolish(at)cwgsy(dot)net>
To: [pgADMIN] <mailto:pgadmin-support(at)postgresql(dot)org>
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Donald Fraser | 2004-05-04 09:41:15 | Re: duplicated Index entries |
Previous Message | Dave Page | 2004-05-04 08:18:16 | Re: Bug report |