[pgadmin-support] interrupting a SQL query

2004-04-29 Thread Jander
Hi.   I have an application in Kylix 2. In this application there is some reports. I need to allow the user interrupt the process SQL query.   Example: The user press key "F6" to start de process SQL query. Now, he    needs to interrupt the process because it is slowly.      

[pgadmin-support] duplicated Index entries

2004-04-29 Thread Donald Fraser
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

Re: [pgadmin-support] duplicated Index entries

2004-04-29 Thread Donald Fraser
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