This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
Log of /trunk/bin
Directory Listing
Revision
82 -
Directory Listing
Modified
Sun Nov 26 21:21:46 2006 UTC
(17 years, 6 months ago)
by
dpavlin
don't add to full-text index primary keys with names beginning with _
Revision
78 -
Directory Listing
Modified
Tue Aug 8 11:40:09 2006 UTC
(17 years, 10 months ago)
by
dpavlin
delete just existing triggers
Revision
77 -
Directory Listing
Modified
Tue Aug 8 11:01:00 2006 UTC
(17 years, 10 months ago)
by
dpavlin
try unique index if primary key doesn't exits
Revision
74 -
Directory Listing
Modified
Mon Aug 7 22:53:46 2006 UTC
(17 years, 10 months ago)
by
dpavlin
turn debug off
Revision
70 -
Directory Listing
Modified
Mon Aug 7 21:08:41 2006 UTC
(17 years, 10 months ago)
by
dpavlin
finish (hopefully) documentation. perldoc pgsql-index.pl is now really
useful :-)
Revision
69 -
Directory Listing
Modified
Mon Aug 7 17:30:56 2006 UTC
(17 years, 10 months ago)
by
dpavlin
single-line progress bar (if it fits), only thing going to STDOUT is example SQL query
(so it can be redirected to file)
Revision
68 -
Directory Listing
Modified
Mon Aug 7 17:05:07 2006 UTC
(17 years, 10 months ago)
by
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
Revision
67 -
Directory Listing
Modified
Mon Aug 7 16:38:24 2006 UTC
(17 years, 10 months ago)
by
dpavlin
added chunk of documentation and ability to --create or --drop indexes
Revision
66 -
Directory Listing
Modified
Mon Aug 7 14:56:08 2006 UTC
(17 years, 10 months ago)
by
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)
Revision
65 -
Directory Listing
Modified
Mon Aug 7 14:47:00 2006 UTC
(17 years, 10 months ago)
by
dpavlin
print example SQL search query at end
Revision
63 -
Directory Listing
Modified
Mon Aug 7 14:30:55 2006 UTC
(17 years, 10 months ago)
by
dpavlin
drop triggers at beginning, work inside transaction, create pgest and pgest_trigger functions
Revision
62 -
Directory Listing
Added
Mon Aug 7 13:24:49 2006 UTC
(17 years, 10 months ago)
by
dpavlin
script to create pgest index on PostgreSQL database (modification of dbi-indexer.pl from
Search::Estraier distribution)