Skip to content

Commit 8478118

Browse files
author
Artur Zakirov
committed
pg_variables was added into Makefile
1 parent ffa87c3 commit 8478118

File tree

27 files changed

+2982
-0
lines changed

27 files changed

+2982
-0
lines changed

‎contrib/Makefile

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -41,6 +41,7 @@ SUBDIRS = \
4141
pg_standby \
4242
pg_stat_statements \
4343
pg_trgm \
44+
pg_variables \
4445
pgcrypto \
4546
pgrowlocks \
4647
pgstattuple \

‎contrib/hunspell_en_us/log/initdb.log

Lines changed: 48 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,48 @@
1+
Running in noclean mode. Mistakes will not be cleaned up.
2+
The files belonging to this database system will be owned by user "artur".
3+
This user must also own the server process.
4+
5+
The database cluster will be initialized with locales
6+
COLLATE: ru_RU.UTF-8
7+
CTYPE: ru_RU.UTF-8
8+
MESSAGES: C
9+
MONETARY: ru_RU.UTF-8
10+
NUMERIC: ru_RU.UTF-8
11+
TIME: ru_RU.UTF-8
12+
The default database encoding has accordingly been set to "UTF8".
13+
The default text search configuration will be set to "russian".
14+
15+
Data page checksums are disabled.
16+
17+
creating directory /home/artur/source/pg/pgpro/contrib/hunspell_en_us/./tmp_check/data ... ok
18+
creating subdirectories ... ok
19+
selecting default max_connections ... 100
20+
selecting default shared_buffers ... 128MB
21+
selecting dynamic shared memory implementation ... posix
22+
creating configuration files ... ok
23+
creating template1 database in /home/artur/source/pg/pgpro/contrib/hunspell_en_us/./tmp_check/data/base/1 ... ok
24+
initializing pg_authid ... ok
25+
initializing dependencies ... ok
26+
creating system views ... ok
27+
loading system objects' descriptions ... ok
28+
creating collations ... ok
29+
creating conversions ... ok
30+
creating dictionaries ... ok
31+
setting privileges on built-in objects ... ok
32+
creating information schema ... ok
33+
loading PL/pgSQL server-side language ... ok
34+
vacuuming database template1 ... ok
35+
copying template1 to template0 ... ok
36+
copying template1 to postgres ... ok
37+
38+
Sync to disk skipped.
39+
The data directory might become corrupt if the operating system crashes.
40+
41+
WARNING: enabling "trust" authentication for local connections
42+
You can change this by editing pg_hba.conf or using the option -A, or
43+
--auth-local and --auth-host, the next time you run initdb.
44+
45+
Success. You can now start the database server using:
46+
47+
pg_ctl -D /home/artur/source/pg/pgpro/contrib/hunspell_en_us/./tmp_check/data -l logfile start
48+

‎contrib/hunspell_en_us/log/postmaster.log

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
LOG: database system was shut down at 2016-04-21 12:11:59 MSK
2+
LOG: MultiXact member wraparound protections are now enabled
3+
LOG: database system is ready to accept connections
4+
LOG: autovacuum launcher started
5+
LOG: checkpoint starting: immediate force wait flush-all
6+
LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.000 s; sync files=0, longest=0.000 s, average=0.000 s; distance=1 kB, estimate=1 kB
7+
LOG: checkpoint starting: immediate force wait
8+
LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.000 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=1 kB
9+
LOG: received fast shutdown request
10+
LOG: aborting any active transactions
11+
LOG: autovacuum launcher shutting down
12+
LOG: shutting down
13+
LOG: checkpoint starting: shutdown immediate
14+
LOG: checkpoint complete: wrote 55 buffers (0.3%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.000 s; sync files=0, longest=0.000 s, average=0.000 s; distance=162 kB, estimate=162 kB
15+
LOG: database system is shut down

‎contrib/hunspell_en_us/results/hunspell_en_us.out

Lines changed: 77 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,77 @@
1+
CREATE EXTENSION hunspell_en_us;
2+
CREATE TABLE table1(name varchar);
3+
INSERT INTO table1 VALUES ('leaves'), ('leaved'), ('leaving'),
4+
('inability'), ('abilities'), ('disability'), ('ability');
5+
SELECT d.* FROM table1 AS t, LATERAL ts_debug('public.english', t.name) AS d;
6+
alias | description | token | dictionaries | dictionary | lexemes
7+
-----------+-----------------+------------+---------------------------------+------------------+-----------
8+
asciiword | Word, all ASCII | leaves | {english_hunspell,english_stem} | english_hunspell | {leave}
9+
asciiword | Word, all ASCII | leaved | {english_hunspell,english_stem} | english_hunspell | {leave}
10+
asciiword | Word, all ASCII | leaving | {english_hunspell,english_stem} | english_hunspell | {leave}
11+
asciiword | Word, all ASCII | inability | {english_hunspell,english_stem} | english_hunspell | {ability}
12+
asciiword | Word, all ASCII | abilities | {english_hunspell,english_stem} | english_hunspell | {ability}
13+
asciiword | Word, all ASCII | disability | {english_hunspell,english_stem} | english_hunspell | {ability}
14+
asciiword | Word, all ASCII | ability | {english_hunspell,english_stem} | english_hunspell | {ability}
15+
(7 rows)
16+
17+
CREATE INDEX name_idx ON table1 USING GIN (to_tsvector('public.english', "name"));
18+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
19+
@@ to_tsquery('public.english', 'leaving');
20+
name
21+
---------
22+
leaves
23+
leaved
24+
leaving
25+
(3 rows)
26+
27+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
28+
@@ to_tsquery('public.english', 'abilities');
29+
name
30+
------------
31+
inability
32+
abilities
33+
disability
34+
ability
35+
(4 rows)
36+
37+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
38+
@@ to_tsquery('public.english', 'ability');
39+
name
40+
------------
41+
inability
42+
abilities
43+
disability
44+
ability
45+
(4 rows)
46+
47+
DROP INDEX name_idx;
48+
CREATE INDEX name_idx ON table1 USING GIST (to_tsvector('public.english', "name"));
49+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
50+
@@ to_tsquery('public.english', 'leaving');
51+
name
52+
---------
53+
leaves
54+
leaved
55+
leaving
56+
(3 rows)
57+
58+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
59+
@@ to_tsquery('public.english', 'abilities');
60+
name
61+
------------
62+
inability
63+
abilities
64+
disability
65+
ability
66+
(4 rows)
67+
68+
SELECT * FROM table1 WHERE to_tsvector('public.english', name)
69+
@@ to_tsquery('public.english', 'ability');
70+
name
71+
------------
72+
inability
73+
abilities
74+
disability
75+
ability
76+
(4 rows)
77+

‎contrib/hunspell_fr/log/initdb.log

Lines changed: 48 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,48 @@
1+
Running in noclean mode. Mistakes will not be cleaned up.
2+
The files belonging to this database system will be owned by user "artur".
3+
This user must also own the server process.
4+
5+
The database cluster will be initialized with locales
6+
COLLATE: ru_RU.UTF-8
7+
CTYPE: ru_RU.UTF-8
8+
MESSAGES: C
9+
MONETARY: ru_RU.UTF-8
10+
NUMERIC: ru_RU.UTF-8
11+
TIME: ru_RU.UTF-8
12+
The default database encoding has accordingly been set to "UTF8".
13+
The default text search configuration will be set to "russian".
14+
15+
Data page checksums are disabled.
16+
17+
creating directory /home/artur/source/pg/pgpro/contrib/hunspell_fr/./tmp_check/data ... ok
18+
creating subdirectories ... ok
19+
selecting default max_connections ... 100
20+
selecting default shared_buffers ... 128MB
21+
selecting dynamic shared memory implementation ... posix
22+
creating configuration files ... ok
23+
creating template1 database in /home/artur/source/pg/pgpro/contrib/hunspell_fr/./tmp_check/data/base/1 ... ok
24+
initializing pg_authid ... ok
25+
initializing dependencies ... ok
26+
creating system views ... ok
27+
loading system objects' descriptions ... ok
28+
creating collations ... ok
29+
creating conversions ... ok
30+
creating dictionaries ... ok
31+
setting privileges on built-in objects ... ok
32+
creating information schema ... ok
33+
loading PL/pgSQL server-side language ... ok
34+
vacuuming database template1 ... ok
35+
copying template1 to template0 ... ok
36+
copying template1 to postgres ... ok
37+
38+
Sync to disk skipped.
39+
The data directory might become corrupt if the operating system crashes.
40+
41+
WARNING: enabling "trust" authentication for local connections
42+
You can change this by editing pg_hba.conf or using the option -A, or
43+
--auth-local and --auth-host, the next time you run initdb.
44+
45+
Success. You can now start the database server using:
46+
47+
pg_ctl -D /home/artur/source/pg/pgpro/contrib/hunspell_fr/./tmp_check/data -l logfile start
48+

‎contrib/hunspell_fr/log/postmaster.log

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
LOG: database system was shut down at 2016-04-21 12:12:02 MSK
2+
LOG: MultiXact member wraparound protections are now enabled
3+
LOG: database system is ready to accept connections
4+
LOG: autovacuum launcher started
5+
LOG: checkpoint starting: immediate force wait flush-all
6+
LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.000 s; sync files=0, longest=0.000 s, average=0.000 s; distance=1 kB, estimate=1 kB
7+
LOG: checkpoint starting: immediate force wait
8+
LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.000 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=1 kB
9+
LOG: received fast shutdown request
10+
LOG: aborting any active transactions
11+
LOG: autovacuum launcher shutting down
12+
LOG: shutting down
13+
LOG: checkpoint starting: shutdown immediate
14+
LOG: checkpoint complete: wrote 55 buffers (0.3%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=162 kB, estimate=162 kB
15+
LOG: database system is shut down

‎contrib/hunspell_fr/results/hunspell_fr.out

Lines changed: 57 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,57 @@
1+
CREATE EXTENSION hunspell_fr;
2+
CREATE TABLE table1(name varchar);
3+
INSERT INTO table1 VALUES ('batifoler'), ('batifolant'), ('batifole'), ('batifolait'),
4+
('consentant'), ('consentir'), ('consentiriez');
5+
SELECT d.* FROM table1 AS t, LATERAL ts_debug('public.french', t.name) AS d;
6+
alias | description | token | dictionaries | dictionary | lexemes
7+
-----------+-----------------+--------------+-------------------------------+-----------------+-------------------------
8+
asciiword | Word, all ASCII | batifoler | {french_hunspell,french_stem} | french_hunspell | {batifoler}
9+
asciiword | Word, all ASCII | batifolant | {french_hunspell,french_stem} | french_hunspell | {batifolante,batifoler}
10+
asciiword | Word, all ASCII | batifole | {french_hunspell,french_stem} | french_hunspell | {batifoler}
11+
asciiword | Word, all ASCII | batifolait | {french_hunspell,french_stem} | french_hunspell | {batifoler}
12+
asciiword | Word, all ASCII | consentant | {french_hunspell,french_stem} | french_hunspell | {consentante,consentir}
13+
asciiword | Word, all ASCII | consentir | {french_hunspell,french_stem} | french_hunspell | {consentir}
14+
asciiword | Word, all ASCII | consentiriez | {french_hunspell,french_stem} | french_hunspell | {consentir}
15+
(7 rows)
16+
17+
CREATE INDEX name_idx ON table1 USING GIN (to_tsvector('public.french', "name"));
18+
SELECT * FROM table1 WHERE to_tsvector('public.french', name)
19+
@@ to_tsquery('public.french', 'batifolant');
20+
name
21+
------------
22+
batifoler
23+
batifolant
24+
batifole
25+
batifolait
26+
(4 rows)
27+
28+
SELECT * FROM table1 WHERE to_tsvector('public.french', name)
29+
@@ to_tsquery('public.french', 'consentiriez');
30+
name
31+
--------------
32+
consentant
33+
consentir
34+
consentiriez
35+
(3 rows)
36+
37+
DROP INDEX name_idx;
38+
CREATE INDEX name_idx ON table1 USING GIST (to_tsvector('public.french', "name"));
39+
SELECT * FROM table1 WHERE to_tsvector('public.french', name)
40+
@@ to_tsquery('public.french', 'batifolant');
41+
name
42+
------------
43+
batifoler
44+
batifolant
45+
batifole
46+
batifolait
47+
(4 rows)
48+
49+
SELECT * FROM table1 WHERE to_tsvector('public.french', name)
50+
@@ to_tsquery('public.french', 'consentiriez');
51+
name
52+
--------------
53+
consentant
54+
consentir
55+
consentiriez
56+
(3 rows)
57+

‎contrib/hunspell_nl_nl/log/initdb.log

Lines changed: 48 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,48 @@
1+
Running in noclean mode. Mistakes will not be cleaned up.
2+
The files belonging to this database system will be owned by user "artur".
3+
This user must also own the server process.
4+
5+
The database cluster will be initialized with locales
6+
COLLATE: ru_RU.UTF-8
7+
CTYPE: ru_RU.UTF-8
8+
MESSAGES: C
9+
MONETARY: ru_RU.UTF-8
10+
NUMERIC: ru_RU.UTF-8
11+
TIME: ru_RU.UTF-8
12+
The default database encoding has accordingly been set to "UTF8".
13+
The default text search configuration will be set to "russian".
14+
15+
Data page checksums are disabled.
16+
17+
creating directory /home/artur/source/pg/pgpro/contrib/hunspell_nl_nl/./tmp_check/data ... ok
18+
creating subdirectories ... ok
19+
selecting default max_connections ... 100
20+
selecting default shared_buffers ... 128MB
21+
selecting dynamic shared memory implementation ... posix
22+
creating configuration files ... ok
23+
creating template1 database in /home/artur/source/pg/pgpro/contrib/hunspell_nl_nl/./tmp_check/data/base/1 ... ok
24+
initializing pg_authid ... ok
25+
initializing dependencies ... ok
26+
creating system views ... ok
27+
loading system objects' descriptions ... ok
28+
creating collations ... ok
29+
creating conversions ... ok
30+
creating dictionaries ... ok
31+
setting privileges on built-in objects ... ok
32+
creating information schema ... ok
33+
loading PL/pgSQL server-side language ... ok
34+
vacuuming database template1 ... ok
35+
copying template1 to template0 ... ok
36+
copying template1 to postgres ... ok
37+
38+
Sync to disk skipped.
39+
The data directory might become corrupt if the operating system crashes.
40+
41+
WARNING: enabling "trust" authentication for local connections
42+
You can change this by editing pg_hba.conf or using the option -A, or
43+
--auth-local and --auth-host, the next time you run initdb.
44+
45+
Success. You can now start the database server using:
46+
47+
pg_ctl -D /home/artur/source/pg/pgpro/contrib/hunspell_nl_nl/./tmp_check/data -l logfile start
48+

‎contrib/hunspell_nl_nl/log/postmaster.log

Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,16 @@
1+
FATAL: the database system is starting up
2+
LOG: database system was shut down at 2016-04-21 12:12:06 MSK
3+
LOG: MultiXact member wraparound protections are now enabled
4+
LOG: database system is ready to accept connections
5+
LOG: autovacuum launcher started
6+
LOG: checkpoint starting: immediate force wait flush-all
7+
LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.000 s; sync files=0, longest=0.000 s, average=0.000 s; distance=1 kB, estimate=1 kB
8+
LOG: checkpoint starting: immediate force wait
9+
LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.000 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=1 kB
10+
LOG: received fast shutdown request
11+
LOG: aborting any active transactions
12+
LOG: autovacuum launcher shutting down
13+
LOG: shutting down
14+
LOG: checkpoint starting: shutdown immediate
15+
LOG: checkpoint complete: wrote 55 buffers (0.3%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.000 s; sync files=0, longest=0.000 s, average=0.000 s; distance=161 kB, estimate=161 kB
16+
LOG: database system is shut down

‎contrib/hunspell_nl_nl/results/hunspell_nl_nl.out

Lines changed: 54 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,54 @@
1+
CREATE EXTENSION hunspell_nl_nl;
2+
CREATE TABLE table1(name varchar);
3+
INSERT INTO table1 VALUES ('deuren'), ('deurtje'), ('deur'),
4+
('twee'), ('tweehonderd'), ('tweeduizend');
5+
SELECT d.* FROM table1 AS t, LATERAL ts_debug('public.dutch', t.name) AS d;
6+
alias | description | token | dictionaries | dictionary | lexemes
7+
-----------+-----------------+-------------+-----------------------------+----------------+---------
8+
asciiword | Word, all ASCII | deuren | {dutch_hunspell,dutch_stem} | dutch_hunspell | {deur}
9+
asciiword | Word, all ASCII | deurtje | {dutch_hunspell,dutch_stem} | dutch_hunspell | {deur}
10+
asciiword | Word, all ASCII | deur | {dutch_hunspell,dutch_stem} | dutch_hunspell | {deur}
11+
asciiword | Word, all ASCII | twee | {dutch_hunspell,dutch_stem} | dutch_hunspell | {twee}
12+
asciiword | Word, all ASCII | tweehonderd | {dutch_hunspell,dutch_stem} | dutch_hunspell | {twee}
13+
asciiword | Word, all ASCII | tweeduizend | {dutch_hunspell,dutch_stem} | dutch_hunspell | {twee}
14+
(6 rows)
15+
16+
CREATE INDEX name_idx ON table1 USING GIN (to_tsvector('public.dutch', "name"));
17+
SELECT * FROM table1 WHERE to_tsvector('public.dutch', name)
18+
@@ to_tsquery('public.dutch', 'deurtje');
19+
name
20+
---------
21+
deuren
22+
deurtje
23+
deur
24+
(3 rows)
25+
26+
SELECT * FROM table1 WHERE to_tsvector('public.dutch', name)
27+
@@ to_tsquery('public.dutch', 'twee');
28+
name
29+
-------------
30+
twee
31+
tweehonderd
32+
tweeduizend
33+
(3 rows)
34+
35+
DROP INDEX name_idx;
36+
CREATE INDEX name_idx ON table1 USING GIST (to_tsvector('public.dutch', "name"));
37+
SELECT * FROM table1 WHERE to_tsvector('public.dutch', name)
38+
@@ to_tsquery('public.dutch', 'deurtje');
39+
name
40+
---------
41+
deuren
42+
deurtje
43+
deur
44+
(3 rows)
45+
46+
SELECT * FROM table1 WHERE to_tsvector('public.dutch', name)
47+
@@ to_tsquery('public.dutch', 'twee');
48+
name
49+
-------------
50+
twee
51+
tweehonderd
52+
tweeduizend
53+
(3 rows)
54+

0 commit comments

Comments
 (0)