Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commita928970

Browse files
committed
New contrib module for BTREE emulation in GiST.
From Oleg Bartunov and Teodor Sigaev.
1 parenta54075a commita928970

File tree

10 files changed

+3003
-3
lines changed

10 files changed

+3003
-3
lines changed

‎contrib/Makefile

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,23 +1,24 @@
1-
# $Header: /cvsroot/pgsql/contrib/Makefile,v 1.23 2001/07/06 23:07:19 petere Exp $
1+
# $Header: /cvsroot/pgsql/contrib/Makefile,v 1.24 2001/08/22 18:27:53 tgl Exp $
22

33
subdir = contrib
44
top_builddir = ..
55
include$(top_builddir)/src/Makefile.global
66

77
WANTED_DIRS =\
88
array\
9+
btree_gist\
910
cube\
1011
dbase\
1112
dblink\
1213
earthdistance\
1314
findoidjoins\
1415
fulltextindex\
16+
fuzzystrmatch\
1517
intarray\
1618
isbn_issn\
1719
lo\
1820
mSQL-interface\
1921
mac\
20-
metaphone\
2122
miscutil\
2223
noupdate\
2324
oid2name\
@@ -30,7 +31,6 @@ WANTED_DIRS = \
3031
rserv\
3132
rtree_gist\
3233
seg\
33-
soundex\
3434
spi\
3535
string\
3636
tips\

‎contrib/README

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -30,6 +30,14 @@ array -
3030
Array iterator functions
3131
by Massimo Dal Zotto <dz@cs.unitn.it>
3232

33+
btree_gist -
34+
Support for emulating BTREE indexing in GiST
35+
by Oleg Bartunov <oleg@sai.msu.su> and Teodor Sigaev <teodor@stack.net>
36+
37+
chkpass -
38+
An auto-encrypted password datatype
39+
by D'Arcy J.M. Cain <darcy@druid.net>
40+
3341
cube -
3442
Multidimensional-cube datatype (GiST indexing example)
3543
by Gene Selkov, Jr. <selkovjr@mcs.anl.gov>

‎contrib/btree_gist/Makefile

Lines changed: 66 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,66 @@
1+
subdir = contrib/btree_gist
2+
top_builddir = ../..
3+
include$(top_builddir)/src/Makefile.global
4+
5+
# override libdir to install shlib in contrib not main directory
6+
libdir :=$(libdir)/contrib
7+
8+
# shared library parameters
9+
NAME= btree_gist
10+
SO_MAJOR_VERSION= 1
11+
SO_MINOR_VERSION= 0
12+
13+
overrideCPPFLAGS += -I$(srcdir)
14+
15+
OBJS= btree_gist.o
16+
17+
all: all-lib$(NAME).sql
18+
19+
# Shared library stuff
20+
include$(top_srcdir)/src/Makefile.shlib
21+
22+
23+
$(NAME).sql:$(NAME).sql.in
24+
sed -e's:MODULE_PATHNAME:$(libdir)/$(shlib):g'<$<>$@
25+
26+
.PHONY: submake
27+
submake:
28+
$(MAKE) -C$(top_builddir)/src/test/regress pg_regress
29+
30+
# against installed postmaster
31+
installcheck: submake
32+
$(top_builddir)/src/test/regress/pg_regress btree_gist
33+
34+
# in-tree test doesn't work yet (no way to install my shared library)
35+
#check: all submake
36+
#$(top_builddir)/src/test/regress/pg_regress --temp-install\
37+
# --top-builddir=$(top_builddir) btree_gist
38+
check:
39+
@echo"'make check' is not supported."
40+
@echo"Do 'make install', then 'make installcheck' instead."
41+
42+
install: all installdirs install-lib
43+
#$(INSTALL_DATA) $(srcdir)/README.$(NAME) $(docdir)/contrib
44+
$(INSTALL_DATA)$(NAME).sql$(datadir)/contrib
45+
46+
installdirs:
47+
$(mkinstalldirs)$(docdir)/contrib$(datadir)/contrib$(libdir)
48+
49+
uninstall: uninstall-lib
50+
rm -f$(docdir)/contrib/README.$(NAME)$(datadir)/contrib/$(NAME).sql
51+
52+
cleandistcleanmaintainer-clean: clean-lib
53+
rm -f*.so y.tab.c y.tab.h$(OBJS)$(NAME).sql
54+
# things created by various check targets
55+
rm -rf results tmp_check log
56+
rm -f regression.diffs regression.out regress.out run_check.out
57+
ifeq ($(PORTNAME), win)
58+
rm -f regress.def
59+
endif
60+
61+
dependdep:
62+
$(CC) -MM$(CFLAGS)*.c>depend
63+
64+
ifeq (depend,$(wildcard depend))
65+
include depend
66+
endif

‎contrib/btree_gist/README.btree_gist

Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,31 @@
1+
This is B-Tree implementation using GiST for int4 and
2+
timestamp types.
3+
4+
All work was done by Teodor Sigaev (teodor@stack.net) and Oleg Bartunov
5+
(oleg@sai.msu.su). See http://www.sai.msu.su/~megera/postgres/gist
6+
for additional information.
7+
8+
NOTICE:
9+
This version will works only with postgresql version 7.2 and above
10+
because of changes in interface of function calling and in system
11+
tables.
12+
13+
INSTALLATION:
14+
15+
gmake
16+
gmake install
17+
-- load functions
18+
psql <database> < btree_gist.sql
19+
20+
REGRESSION TEST:
21+
22+
gmake installcheck
23+
24+
EXAMPLE USAGE:
25+
26+
create table test (a int4);
27+
-- create index
28+
create index testidx on test using gist (a);
29+
-- query
30+
select * from test where a < 10;
31+

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp