/[pgestraier]/trunk/bin/pgest-index.pl
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Log of /trunk/bin/pgest-index.pl

Parent Directory Parent Directory | Revision Log Revision Log


Links to HEAD: (view) (annotate)
Sticky Revision:

Revision 88 - (view) (annotate) - [select for diffs]
Modified Sun Mar 16 20:55:56 2008 UTC (16 years ago) by dpavlin
File length: 7473 byte(s)
Diff to previous 82
better error message when run without arguments

Revision 82 - (view) (annotate) - [select for diffs]
Modified Sun Nov 26 21:21:46 2006 UTC (17 years, 4 months ago) by dpavlin
File length: 7467 byte(s)
Diff to previous 78
don't add to full-text index primary keys with names beginning with _

Revision 78 - (view) (annotate) - [select for diffs]
Modified Tue Aug 8 11:40:09 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 7216 byte(s)
Diff to previous 77
delete just existing triggers

Revision 77 - (view) (annotate) - [select for diffs]
Modified Tue Aug 8 11:01:00 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 6762 byte(s)
Diff to previous 74
try unique index if primary key doesn't exits

Revision 74 - (view) (annotate) - [select for diffs]
Modified Mon Aug 7 22:53:46 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 6611 byte(s)
Diff to previous 70
turn debug off

Revision 70 - (view) (annotate) - [select for diffs]
Modified Mon Aug 7 21:08:41 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 6611 byte(s)
Diff to previous 69
finish (hopefully) documentation. perldoc pgsql-index.pl is now really
useful :-)

Revision 69 - (view) (annotate) - [select for diffs]
Modified Mon Aug 7 17:30:56 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 5757 byte(s)
Diff to previous 68
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 - (view) (annotate) - [select for diffs]
Modified Mon Aug 7 17:05:07 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 5664 byte(s)
Diff to previous 67
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 - (view) (annotate) - [select for diffs]
Modified Mon Aug 7 16:38:24 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 4954 byte(s)
Diff to previous 66
added chunk of documentation and ability to --create or --drop indexes

Revision 66 - (view) (annotate) - [select for diffs]
Modified Mon Aug 7 14:56:08 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 3460 byte(s)
Diff to previous 65
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 - (view) (annotate) - [select for diffs]
Modified Mon Aug 7 14:47:00 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 3591 byte(s)
Diff to previous 63
print example SQL search query at end

Revision 63 - (view) (annotate) - [select for diffs]
Modified Mon Aug 7 14:30:55 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 3196 byte(s)
Diff to previous 62
drop triggers at beginning, work inside transaction, create pgest and pgest_trigger functions

Revision 62 - (view) (annotate) - [select for diffs]
Added Mon Aug 7 13:24:49 2006 UTC (17 years, 7 months ago) by dpavlin
File length: 2637 byte(s)
script to create pgest index on PostgreSQL database (modification of dbi-indexer.pl from
Search::Estraier distribution)

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a

  ViewVC Help
Powered by ViewVC 1.1.26