Skip site navigation (1) Skip section navigation (2)

Re: duplicated Index entries

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 10:17:20
Message-ID: 03AF4E498C591348A42FC93DEA9661B889FC16@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
Hi Donald,
 
Yes, I do vaguely remember it! How deep is the dependency tree? Is is
possible to send a copy of the definitions of the objects involved for
testing?
 
Regards, Dave.


  _____  

	From: Donald Fraser [mailto:demolish(at)cwgsy(dot)net] 
	Sent: 04 May 2004 10:41
	To: [pgADMIN]
	Subject: Re: [pgadmin-support] duplicated Index entries
	
	
	Hi Dave,
	I have tried the example you gave below and it does not show the
problem.
	Further investigation has shown that the duplicate entries are
only occurring on functions that return a data type named citext. 
	Data type citext is my own installed data type... You might
remember this data type from previous bugs that I reported in the early
stages of development of pgAdmin III - it turned out that the problems
were with PostgreSQL 7.3.x and not pgAdmin III.
	 
	Currently I am using PostgreSQL 7.4.2 so this shouldn't be a
related bug - but then I'm not really qualified to 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 <mailto:dpage(at)vale-housing(dot)co(dot)uk>  
		To: Donald Fraser <mailto:demolish(at)cwgsy(dot)net>  ;
[pgADMIN] <mailto:pgadmin-support(at)postgresql(dot)org>  
		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(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.

pgadmin-support by date

Next:From: Elvis E. Henriquez A.Date: 2004-05-04 10:52:09
Subject: Re: Bug report
Previous:From: Donald FraserDate: 2004-05-04 09:41:15
Subject: Re: duplicated Index entries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group