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

Commit618b867

Browse files
committed
Merge branch 'PGPRO9_5' into PGPRO9_5_ptrack
2 parents6596c9d +dda4a37 commit618b867

File tree

45 files changed

+847
-174
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

45 files changed

+847
-174
lines changed

‎configure

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2745,7 +2745,7 @@ fi
27452745

27462746

27472747

2748-
PGPRO_VERSION="$PACKAGE_VERSION.1"
2748+
PGPRO_VERSION="$PACKAGE_VERSION.2"
27492749
PGPRO_PACKAGE_NAME="PostgresPro"
27502750

27512751

‎configure.in

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -38,7 +38,7 @@ PGAC_ARG_REQ(with, extra-version, [STRING], [append STRING to version],
3838
[PG_VERSION="$PACKAGE_VERSION$withval"],
3939
[PG_VERSION="$PACKAGE_VERSION"])
4040

41-
PGPRO_VERSION="$PACKAGE_VERSION.1"
41+
PGPRO_VERSION="$PACKAGE_VERSION.2"
4242
PGPRO_PACKAGE_NAME="PostgresPro"
4343
AC_SUBST(PGPRO_PACKAGE_NAME)
4444

‎contrib/btree_gist/expected/not_equal.out

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,6 +9,7 @@ INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
99
INSERT INTO test_ne VALUES('2007-02-03', -91.3);
1010
INSERT INTO test_ne VALUES('2011-09-01', 43.7);
1111
INSERT INTO test_ne SELECT '2009-01-01', 10.7 FROM generate_series(1,1000);
12+
SET enable_indexscan to false;
1213
EXPLAIN (COSTS OFF) SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
1314
QUERY PLAN
1415
------------------------------------------------------------------------------------------------------
@@ -25,6 +26,7 @@ SELECT * FROM test_ne WHERE a <> '2009-01-01' AND b <> 10.7;
2526
Thu Sep 01 00:00:00 2011 | 43.7
2627
(2 rows)
2728

29+
RESET enable_indexscan;
2830
-- test search for "not equals" using an exclusion constraint
2931
CREATE TABLE zoo (
3032
cage INTEGER,

‎contrib/btree_gist/sql/not_equal.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -14,10 +14,14 @@ INSERT INTO test_ne VALUES('2007-02-03', -91.3);
1414
INSERT INTO test_neVALUES('2011-09-01',43.7);
1515
INSERT INTO test_neSELECT'2009-01-01',10.7FROM generate_series(1,1000);
1616

17+
SET enable_indexscan to false;
18+
1719
EXPLAIN (COSTS OFF)SELECT*FROM test_neWHERE a<>'2009-01-01'AND b<>10.7;
1820

1921
SELECT*FROM test_neWHERE a<>'2009-01-01'AND b<>10.7;
2022

23+
RESET enable_indexscan;
24+
2125
-- test search for "not equals" using an exclusion constraint
2226

2327
CREATETABLEzoo (

‎doc/src/sgml/Makefile

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -54,7 +54,7 @@ ifndef XSLTPROC
5454
XSLTPROC =$(missing) xsltproc
5555
endif
5656

57-
overrideXSLTPROCFLAGS += --stringparam pg.version '$(VERSION)'
57+
overrideXSLTPROCFLAGS += --stringparam pg.version '$(PGPRO_VERSION)'
5858

5959

6060
GENERATED_SGML = bookindex.sgml version.sgml\
@@ -147,7 +147,7 @@ endif
147147
# changes.
148148
version.sgml:$(top_srcdir)/configure
149149
{ \
150-
echo"<!ENTITY version\"$(VERSION)\">";\
150+
echo"<!ENTITY version\"$(PGPRO_VERSION)\">";\
151151
echo"<!ENTITY majorversion\"$(MAJORVERSION)\">";\
152152
echo"<!ENTITY productname\"$(PRODUCT_NAME)\">";\
153153
}>$@

‎doc/src/sgml/contrib.sgml

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -130,6 +130,7 @@ CREATE EXTENSION <replaceable>module_name</> FROM unpackaged;
130130
&pgbuffercache;
131131
&pgcrypto;
132132
&pgfreespacemap;
133+
&pgpathman;
133134
&pgprewarm;
134135
&pgrowlocks;
135136
&pgstatstatements;

‎doc/src/sgml/filelist.sgml

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -133,6 +133,7 @@
133133
<!ENTITY pgbuffercache SYSTEM "pgbuffercache.sgml">
134134
<!ENTITY pgcrypto SYSTEM "pgcrypto.sgml">
135135
<!ENTITY pgfreespacemap SYSTEM "pgfreespacemap.sgml">
136+
<!ENTITY pgpathman SYSTEM "pgpathman.sgml">
136137
<!ENTITY pgprewarm SYSTEM "pgprewarm.sgml">
137138
<!ENTITY pgrowlocks SYSTEM "pgrowlocks.sgml">
138139
<!ENTITY pgstandby SYSTEM "pgstandby.sgml">

‎doc/src/sgml/func.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -350,7 +350,7 @@
350350
expression that contains both NULL and non-null values will return false
351351
for both tests.
352352
This definition conforms to the SQL standard, and is a change from the
353-
inconsistent behavior exhibited by <productname>&productname;</productname>
353+
inconsistent behavior exhibited by <productname>PostgreSQL</productname>
354354
versions prior to 8.2.
355355
</para>
356356
</note>
@@ -14452,7 +14452,7 @@ AND
1445214452

1445314453
<note>
1445414454
<para>
14455-
Prior to <productname>PosgreSQL</productname> 8.2, the
14455+
Prior to <productname>PostgreSQL</productname> 8.2, the
1445614456
<literal>&lt;</>, <literal>&lt;=</>, <literal>&gt;</> and <literal>&gt;=</>
1445714457
cases were not handled per SQL specification. A comparison like
1445814458
<literal>ROW(a,b) &lt; ROW(c,d)</>
@@ -14961,7 +14961,7 @@ SELECT * FROM pg_ls_dir('.') WITH ORDINALITY AS t(ls,n);
1496114961
<row>
1496214962
<entry><literal><function>version()</function></literal></entry>
1496314963
<entry><type>text</type></entry>
14964-
<entry>PostgreSQL version information. See also <xref linkend="guc-server-version-num"> for a machine-readable version.</entry>
14964+
<entry><productname>PostgreSQL</productname> version information. See also <xref linkend="guc-server-version-num"> for a machine-readable version.</entry>
1496514965
</row>
1496614966

1496714967
<row>

‎doc/src/sgml/gin.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -539,7 +539,7 @@
539539
<function>extractQuery</> to pass additional data to the
540540
<function>consistent</> and <function>comparePartial</> methods.
541541
To use it, <function>extractQuery</> must allocate
542-
an array of <literal>*nkeys</>Pointers and store its address at
542+
an array of <literal>*nkeys</>pointers and store its address at
543543
<literal>*extra_data</>, then store whatever it wants to into the
544544
individual pointers. The variable is initialized to <symbol>NULL</symbol> before
545545
call, so this argument can simply be ignored by operator classes that

‎doc/src/sgml/install-windows.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -81,7 +81,7 @@
8181
for Windows Desktop</productname> or those in the <productname>Windows SDK
8282
7.1</productname>, which are both free downloads from Microsoft.
8383
</para>
84-
<para>>
84+
<para>
8585
Both 32-bit and 64-bit builds are possible with the Microsoft Compiler suite.
8686
32-bit <productname>&productname;</productname> builds are possible with
8787
<productname>Visual Studio 2005</productname> to
@@ -441,7 +441,7 @@ $ENV{CONFIG}="Debug";
441441
<userinput>vcregress modulescheck</userinput>
442442
<userinput>vcregress ecpgcheck</userinput>
443443
<userinput>vcregress isolationcheck</userinput>
444-
<userinput>vcregresstapcheck</userinput>
444+
<userinput>vcregressbincheck</userinput>
445445
<userinput>vcregress upgradecheck</userinput>
446446
</screen>
447447

@@ -456,8 +456,8 @@ $ENV{CONFIG}="Debug";
456456
</para>
457457

458458
<para>
459-
Running theTAPregression tests, with "vcregresstapcheck", requires an
460-
additional Perl module to be installed:
459+
Running the regression tests on client programs, with "vcregressbincheck",
460+
requires anadditional Perl module to be installed:
461461
<variablelist>
462462
<varlistentry>
463463
<term><productname>IPC::Run</productname></term>

‎doc/src/sgml/installation.sgml

Lines changed: 6 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -344,18 +344,15 @@ su - postgres
344344
<para>
345345
The <productname>&productname;</> &version; sources can be obtained from the
346346
download section of our
347-
website: <ulink url="http://www.postgresql.org/download/"></ulink>. You
348-
should get a file named <filename>postgresql-&version;.tar.gz</filename>
349-
or <filename>postgresql-&version;.tar.bz2</filename>. After
347+
website: <ulink url="http://www.postgrespro.ru/download/latest"></ulink>. You
348+
should get a file named <filename>postgrespro-&version;.tar.bz2</filename> . After
350349
you have obtained the file, unpack it:
351350
<screen>
352-
<userinput>gunzip postgresql-&version;.tar.gz</userinput>
353-
<userinput>tar xfpostgresql-&version;.tar</userinput>
351+
<userinput>bunzip2 postgrespro-&version;.tar.bz2</userinput>
352+
<userinput>tar xfpostgrespro-&version;.tar</userinput>
354353
</screen>
355-
(Use <command>bunzip2</command> instead of <command>gunzip</command> if you
356-
have the <filename>.bz2</filename> file.)
357354
This will create a directory
358-
<filename>postgresql-&version;</filename> under the current directory
355+
<filename>postgrespro-&version;</filename> under the current directory
359356
with the <productname>&productname;</> sources.
360357
Change into that directory for the rest
361358
of the installation procedure.
@@ -2714,7 +2711,7 @@ PHSS_30849 s700_800 u2comp/be/plugin library Patch
27142711

27152712
<para>
27162713
By default, the &productname; man pages are installed into
2717-
<filename>/usr/local/pgsql/man</filename>. By default, UnixWare
2714+
<filename>/usr/local/pgsql/share/man</filename>. By default, UnixWare
27182715
does not look there for man pages. To be able to read them you
27192716
need to modify the
27202717
<varname>MANPATH</varname> variable

‎doc/src/sgml/intro.sgml

Lines changed: 54 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -86,7 +86,7 @@
8686

8787
<para>
8888
<productname>&productname;</productname> is an object-relational
89-
database management system (<acronym>ORDBMS</acronym>) basedon <ulink
89+
database management system (<acronym>ORDBMS</acronym>), developed by Postgres Professionalonthe base of<ulink
9090
url="http://postgresql.org"><productname>PostgreSQL</productname></ulink>, which is in turn based on
9191
<ulink url="http://db.cs.berkeley.edu/postgres.html">
9292
<productname>POSTGRES, Version 4.2</productname></ulink>,
@@ -121,7 +121,7 @@
121121
</listitem>
122122
</itemizedlist>
123123

124-
Also, <productname>&productname;</productname> can be extended by the
124+
Also, <productname>&productname;</productname>, as well as <productname>PostgreSQL</productname>, can be extended by the
125125
user in many ways, for example by adding new
126126

127127
<itemizedlist spacing="compact">
@@ -148,10 +148,61 @@
148148

149149
<para>
150150
And because of the liberal license,
151-
<productname>&productname;</productname> can be used, modified, and
151+
<productname>&productname;</productname>and <productname>PostgreSQL</productname>can be used, modified, and
152152
distributed by anyone free of charge for any purpose, be it
153153
private, commercial, or academic.
154154
</para>
155+
</sect1>
156+
157+
<sect1 id="intro-pgpro-vs-pg">
158+
<title> Difference between <productname>&productname;</productname> and PostgreSQL</title>
159+
160+
<para>
161+
<productname>&productname;</productname> is the most actual PostgreSQL version with some additional patches applied and extensions added.
162+
Mostly, these are patches already accepted by the PostgreSQL community and committed into PostgreSQL.
163+
Also there some patches and extensions developed by Postgres Professional.
164+
Users of <productname>&productname;</productname> thus have early access to some important features and fixes.
165+
</para>
166+
167+
<para>Currently the difference between <productname>&productname;</productname> and PostgreSQL is the following:
168+
<itemizedlist spacing="compact">
169+
<listitem>
170+
<simpara>Performance improvement on multicore systems (buffer manager and locks optimization).</simpara>
171+
</listitem>
172+
<listitem>
173+
<simpara>Full text search improvements: phrase search, hunspell morphology,
174+
some dictionaries are bundled with distribution and can be enabled by a single SQL statement,
175+
<application>shared_ispell</application> allowing to store dictionaries in shared memory.</simpara>
176+
</listitem>
177+
<listitem>
178+
<simpara>Covering indexes.</simpara>
179+
</listitem>
180+
<listitem>
181+
<simpara><application>libicu</application> support on all platforms, providing platform-independent sort for various locales.</simpara>
182+
</listitem>
183+
<listitem>
184+
<simpara><application>pg_trgm</application> module supporting fuzzy string comparison and substring search.</simpara>
185+
</listitem>
186+
<listitem>
187+
<simpara>Improved <application>pageinspect</application> module provides access to internal data storage structure.</simpara>
188+
</listitem>
189+
<listitem>
190+
<simpara><application>sr_plan</application> module allows to save and restore query plans.</simpara>
191+
</listitem>
192+
<listitem>
193+
<simpara><application>dump_stat</application> module allowing to save and restore database statistics when dumping/restoring the database. </simpara>
194+
</listitem>
195+
<listitem>
196+
<simpara><application>jsquery</application> module provides a specific language for effective index-supported querying of JSONB data.</simpara>
197+
</listitem>
198+
</itemizedlist>
199+
</para>
200+
201+
<para>
202+
<productname>&productname;</productname> releases are following the PostgreSQL releases, though sometimes occur more frequently.
203+
The <productname>&productname;</productname> versioning scheme is based on the PostgreSQL one and has an additional decimal place.
204+
</para>
205+
155206
</sect1>
156207

157208
&history;

‎doc/src/sgml/jsquery.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -51,7 +51,7 @@
5151
<sect2 id="jsquery-installation">
5252
<title>Installation</title>
5353
<para>
54-
When you installedPostgresPro distribution, jsquery is available
54+
When you installed<productname>Postgres Pro</productname> distribution, jsquery is available
5555
as a contrib moudle. Install contrib modules (postgrespro-contrib
5656
package in the binary distribution for Linux, or make -C contrib
5757
install if you are building from source), then start psql shell

‎doc/src/sgml/legal.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -11,7 +11,7 @@
1111
<title>Legal Notice</title>
1212

1313
<para>
14-
<productname>PostgresPro</productname> is Copyright &copy; 2016 by the
14+
<productname>Postgres Pro</productname> is Copyright &copy; 2016 by the
1515
Postgres Professional.
1616
</para>
1717
<para>

‎doc/src/sgml/libpq.sgml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -7907,7 +7907,7 @@ testlibpq.o(.text+0xa4): undefined reference to `PQerrorMessage'
79077907
/*
79087908
* testlibpq.c
79097909
*
7910-
* Test the C version of libpq, the&productname; frontend library.
7910+
* Test the C version of libpq, thePostgres Pro frontend library.
79117911
*/
79127912
#include <stdio.h>
79137913
#include <stdlib.h>

‎doc/src/sgml/pg_variables.sgml

Lines changed: 3 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@
33
<sect2 id="pg-varaibles-introduction">
44
<title>Introduction</title>
55
<para>
6-
The <emphasis role="strong">pg_variables</emphasis> module
6+
The <filename>pg_variables</filename> module
77
provides functions to work with variables of various types.
88
Created variables live only in the current user session.
99
</para>
@@ -497,8 +497,7 @@ SELECT pgv_get_int('vars', 'int2');
497497
(1 row)
498498
</programlisting>
499499
<para>
500-
Let's assume we have a <emphasis role="strong">tab</emphasis>
501-
table:
500+
Let's assume we have a <varname>tab</varname> table:
502501
</para>
503502
<programlisting>
504503
CREATE TABLE tab (id int, t varchar);
@@ -567,7 +566,7 @@ SELECT * FROM pgv_stats() order by package;
567566
(1 row)
568567
</programlisting>
569568
<para>
570-
You can delete variables orhole packages:
569+
You can delete variables orwhole packages:
571570
</para>
572571
<programlisting>
573572
SELECT pgv_remove('vars', 'int1');

0 commit comments

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