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

Commit8478118

Browse files
author
Artur Zakirov
committed
pg_variables was added into Makefile
1 parentffa87c3 commit8478118

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\
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+
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
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+
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
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+
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+
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
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)
[8]ページ先頭
©2009-2025 Movatter.jp