Repository List
/
pgestraier
/
trunk
/
bin
/
pgest-index.pl @ HEAD
English
Français
Chinese (Simplified)
Chinese (Traditional)
Blame/Annotate
Checkout
View File
RSS Feed
Show last: 20 ,
50
,
100
,
All
Date
File
Revision
Author
Diff
Revision Log
2008/03/16 20:55:56
88
88
dpavlin
HTML
|
TEXT
better error message when run without arguments
2006/11/26 21:21:46
82
82
dpavlin
HTML
|
TEXT
don't add to full-text index primary keys with names beginning with _
2006/08/08 11:40:09
78
78
dpavlin
HTML
|
TEXT
delete just existing triggers
2006/08/08 11:01:00
77
77
dpavlin
HTML
|
TEXT
try unique index if primary key doesn't exits
2006/08/07 22:53:46
74
74
dpavlin
HTML
|
TEXT
turn debug off
2006/08/07 21:08:41
70
70
dpavlin
HTML
|
TEXT
finish (hopefully) documentation. perldoc pgsql-index.pl is now really
useful :-)
2006/08/07 17:30:56
69
69
dpavlin
HTML
|
TEXT
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
HTML
|
TEXT
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
HTML
|
TEXT
added chunk of documentation and ability to --create or --drop indexes
2006/08/07 14:56:08
66
66
dpavlin
HTML
|
TEXT
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
HTML
|
TEXT
print example SQL search query at end
2006/08/07 14:30:55
63
63
dpavlin
HTML
|
TEXT
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)