Show last: 20 , 50 , 100 , All

Date File Revision Author Revision Log
2008/03/16 20:55:56 88 88 dpavlin better error message when run without arguments
2006/11/26 21:21:46 82 82 dpavlin don't add to full-text index primary keys with names beginning with _
2006/08/08 11:40:09 78 78 dpavlin delete just existing triggers
2006/08/08 11:01:00 77 77 dpavlin try unique index if primary key doesn't exits
2006/08/07 22:53:46 74 74 dpavlin turn debug off
2006/08/07 21:08:41 70 70 dpavlin finish (hopefully) documentation. perldoc pgsql-index.pl is now really
useful :-)
2006/08/07 17:30:56 69 69 dpavlin single-line progress bar (if it fits), only thing going to STDOUT is example SQL query
(so it can be redirected to file)
2006/08/07 17:05:07 68 68 dpavlin auto-discover primary key (if it's single column and sutable), auto-generate SQL
select * from table which is *NOT OPTIMAL* if you are not going to search all
columns in your table
2006/08/07 16:38:24 67 67 dpavlin added chunk of documentation and ability to --create or --drop indexes
2006/08/07 14:56:08 66 66 dpavlin don't change encoding when inserting in HyperEstraier (since pgest_trigger doesn't do that).
This might mean that Hyper Estraier web UI won't have correct encoding if your database
isn't in UTF-8 encoding (which might get fixed, but that would require all
functions to have encoding parametar which is, IMHO, overkill)
2006/08/07 14:47:00 65 65 dpavlin print example SQL search query at end
2006/08/07 14:30:55 63 63 dpavlin drop triggers at beginning, work inside transaction, create pgest and pgest_trigger functions
2006/08/07 13:24:49 62 62 dpavlin script to create pgest index on PostgreSQL database (modification of dbi-indexer.pl from
Search::Estraier distribution)