Re: [pgadmin-support] pgAdmin III - bug with reverse engineered SQL with function indexes

2003-07-31 Thread Donald Fraser
> Donald Fraser wrote: > > > pgAdmin III July 16th Build > > PostgreSQL 7.3.3 > > > > The reverse engineered SQL for indexes that use a function do not work. > > For example I create an index with the following command: > > CREATE UNIQUE INDEX tbl_security_fullname_key > > ON tbl_security > > U

[pgadmin-support] pgAdmin III - bug with reverse engineered SQL with function indexes

2003-07-31 Thread Donald Fraser
pgAdmin III July 16th Build PostgreSQL 7.3.3   The reverse engineered SQL for indexes that use a function do not work. For example I create an index with the following command: CREATE UNIQUE INDEX tbl_security_fullname_key  ON tbl_security  USING btree (get_securityname_4idx(s_umbname, s_nam