t: 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
o say that for
certain...
Not sure what else I can do to pin point things any
further...
Regards
Donald Fraser
- Original Message -
From:
Dave
Page
To: Donald Fraser ; [pgADMIN]
Sent: Tuesday, May 04, 2004 9:33 AM
Subject: RE: [pgadmin-support] duplicated
Index entri
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:[EMAIL PROTECTED] Sent: 29 April 2004 17:42To:
[pgADMIN]Subject: Re: [pgadmin-support] duplicat
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
N
