= %version instead of just
%pgmajor - port /usr/share/postgresql/install-alternatives usage to the new
scheme - update to 10.1
* Security Issues
- CVE-2017-15098: Memory disclosure in JSON functions
- CVE-2017-15099: INSERT ... ON CONFLICT DO UPDATE fails to
enforce SELECT privileges
Prior to this release, the "INSERT ... ON CONFLICT DO UPDATE"
would not check to see if the executing user had permission
to perform a "SELECT" on the index performing the conflicting
check. Additionally, in a table with row-level security
enabled, the "INSERT ... ON CONFLICT DO UPDATE" would not
check the SELECT policies for that table before performing
the update.
This fix ensures that "INSERT ... ON CONFLICT DO UPDATE"
checks against table permissions and RLS policies before
executing.
* Bug Fixes and Improvements
This update also fixes a number of bugs reported in the last
few months. Some of these issues affect only version 10, but
many affect all supported versions:
- Fix a race condition in BRIN indexing that could cause some
rows to not be included in the indexing.
- Fix crash when logical decoding is invoked from a PL language
function.
- Several fixes for logical replication.
- Restored behavior for CTEs attached to INSERT/UPDATE/DELETE
statements to pre-version 10.
- Prevent low-probability crash in processing of nested trigger
firings.
- Do not evaluate an aggregate function's argument expressions
when the conditions in the FILTER clause evaluate to FALSE.
This complies with SQL-standard behavior.
- Fix incorrect query results when multiple GROUPING SETS
columns contain the same simple variable.
- Fix memory leak over the lifespan of a query when evaluating
a set-returning function from the target list in a SELECT.
- Several fixes for parallel query execution, including fixing
a crash in the parallel execution of certain queries that
contain a certain type of bitmap scan.
- Fix json_build_array(), json_build_object(),
jsonb_build_array(), and jsonb_build_object() to handle
explicit VARIADIC arguments correctly.
- Prevent infinite float values from being casted to the
numeric type.
- Fix autovacuum's “work item” logic to prevent possible
crashes and silent loss of work items.
- Several fixes for VIEWs around adding columns to the end of a
view.
- Fix for hashability detection of range data types that are
created by a user.
- Improvements on using extended statistics on columns for the
purposes of query planning.
- Prevent idle_in_transaction_session_timeout from being
ignored when a statement_timeout occurred earlier.
- Fix low-probability loss of NOTIFY messages due more than 2
billion transactions processing before any queries are
executed in the session.
- Several file system interaction fixes.
- Correctly restore the umask setting when file creation fails
in COPY or lo_export().
- Fix pg_dump to ensure that it emits GRANT commands in a valid
order.
- Fix pg_basebackup's matching of tablespace paths to
canonicalize both paths before comparing to help improve
Windows compatibility.
- Fix libpq to not require user's home directory to exist when
trying to read the "~/.pgpass" file.
- Several fixes for ecpg.
- This update also contains tzdata release 2017c, with updates
for Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks &
Caicos Islands, plus historical corrections for Alaska,
Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago
Pago.
For more details see:
https://www.postgresql.org/docs/current/static/release-10-1.html - Use /usr/share/postgresql/install-alternatives in the respective
scriptlets.
- Fix the logic around restart on upgrade and stop on removal.
We bring the binaries, but we don't own the unit file. - Update to the final 10.0 release. Major enhancements include:
* Logical replication using publish/subscribe
* Declarative table partitioning
* Improved query parallelism
* Significant general performance improvements
* Stronger password authentication based on SCRAM-SHA-256
* Improved monitoring and control
A dump/restore using pg_dumpall, or use of pg_upgrade, is
required for those wishing to migrate data from any previous
release.
Version 10 contains a number of changes that may affect
compatibility with previous releases.
See the release notes for details:
https://www.postgresql.org/docs/10/static/release-10.html
- Reduce the number of version-related macros in the spec file. - Break a build dependency loop in the server packages that led to
bootstrap problems. - Update to 10rc1
PostgreSQL 10 RC 1 requires an upgrade from beta 4, or earlier
either using pg_dump / pg_restore or pg_upgrade.
Changes since beta4 include:
* Add psql variables showing server version and psql version.
* Several fixes for partitioning
* Several fixes for logical replication
* Several fixes for transition tables
* Fix for query that could end up in an uninterruptible state
- Adjust dependencies to the new packaging schema. - update to 10beta4
PostgreSQL 10 beta 4 requires an upgrade from beta 3, or earlier
either using pg_dump / pg_restore or pg_upgrade.
Any bugfixes applied to 9.6 or earlier that also affected 10 are
included in beta 4. Our users and contributors also reported bugs
against 10 beta 3, and many of them have been fixed in this
release. We urge our community to re-test to ensure that these
bugs are actually fixed, including:
- Show foreign tables in information_schema.table_privileges
view. This fix applies to new databases, see the release notes
for the procedure to apply the fix to an existing database.
- Clean up handling of a fatal exit (e.g., due to receipt of
SIGTERM) that occurs while trying to execute a ROLLBACK of a
failed transaction
- Remove assertion that could trigger during a fatal exit
- Correctly identify columns that are of a range type or domain
type over a composite type or domain type being searched for
- Prevent crash when passing fixed-length pass-by-reference data
types to parallel worker processes
- Fix crash in pg_restore when using parallel mode and using a
list file to select a subset of items to restore
- Change ecpg’s parser to allow RETURNING clauses without
attached C variables
- Change ecpg’s parser to recognize backslash continuation of C
preprocessor command lines
- Improve selection of compiler flags for PL/Perl on Windows
- Fix make check to behave correctly when invoked via a non-GNU
make program
Note that some known issues remain unfixed. Before reporting a
bug in the beta, please check the Open Items page.
https://wiki.postgresql.org/wiki/PostgreSQL_10_Open_Items - update to 10beta3
- hash: Fix write-ahead logging bugs related to init forks
- Fix oddity in error handling of constraint violation in
ExecConstraints for partitioned tables
- Use a real RT index when setting up partition tuple routing
- Fix serious performance problems in json(b) to_tsvector()
- Fix problems defining multi-column range partition bounds
- Fix partitioning crashes during error reporting
- Fix race conditions in replication slot operations
- Fix very minor memory leaks in psql's command.c
- PL/Perl portability fix: avoid including XSUB.h in plperl.c
- Fix inadequate stack depth checking in the wake of expression
execution changes
- Allow creation of C/POSIX collations without depending on libc
behavior
- Fix OBJECT_TYPE/OBJECT_DOMAIN confusion
- Remove duplicate setting of SSL_OP_SINGLE_DH_USE option
- Fix crash with logical replication on a function index
- Teach map_partition_varattnos to handle whole-row expressions
- Fix lock upgrade hazard in ATExecAttachPartition
- Apply ALTER ... SET NOT NULL recursively in ALTER ... ADD
PRIMARY KEY
- hash: Increase the number of possible overflow bitmaps by 8x
- Only kill sync workers at commit time in subscription DDL
- Fix bug in deciding whether to scan newly-attached partition
- Make pg_stop_backup's wait_for_archive flag work on standbys
- Fix handling of dropped columns in logical replication
- Fix local/remote attribute mix-up in logical replication - bump version in update-alternatives call - use multibuild - initial package nebbiolo 1632133557
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ 10.18-8.38.1 10.18-8.38.1 10.18-8.38.1 test regress autoinc.so data agg.data array.data constrf.data constro.data dept.data desc.data emp.data hash.data jsonb.data onek.data person.data real_city.data rect.data streets.data stud_emp.data student.data tenk.data tsearch.data expected abstime.out advisory_lock.out aggregates.out alter_generic.out alter_operator.out alter_table.out amutils.out arrays.out async.out bit.out bitmapops.out boolean.out box.out brin.out btree_index.out case.out char.out char_1.out char_2.out circle.out cluster.out collate.icu.utf8.out collate.linux.utf8.out collate.out combocid.out comments.out conversion.out copy2.out copydml.out copyselect.out create_aggregate.out create_am.out create_cast.out create_function_3.out create_index.out create_misc.out create_operator.out create_table.out create_table_like.out create_type.out create_view.out date.out dbsize.out delete.out dependency.out domain.out drop_if_exists.out drop_operator.out enum.out equivclass.out errors.out event_trigger.out expressions.out float4-exp-three-digits.out float4.out float8-exp-three-digits-win32.out float8-small-is-zero.out float8-small-is-zero_1.out float8.out foreign_data.out foreign_key.out functional_deps.out geometry.out geometry_1.out geometry_2.out gin.out gist.out groupingsets.out guc.out hash_index.out horology.out hs_standby_allowed.out hs_standby_check.out hs_standby_disallowed.out hs_standby_functions.out identity.out indirect_toast.out inet.out inherit.out init_privs.out insert.out insert_conflict.out int2.out int4.out int8-exp-three-digits.out int8.out interval.out join.out json.out json_encoding.out json_encoding_1.out jsonb.out limit.out line.out lock.out lseg.out macaddr.out macaddr8.out matview.out misc_functions.out misc_sanity.out money.out name.out namespace.out numeric.out numeric_big.out numerology.out numerology_1.out object_address.out oid.out oidjoins.out opr_sanity.out password.out path.out pg_lsn.out plancache.out plpgsql.out point.out polygon.out polymorphism.out portals.out portals_p2.out prepare.out prepared_xacts.out prepared_xacts_1.out privileges.out psql.out psql_crosstab.out publication.out random.out rangefuncs.out rangetypes.out regex.linux.utf8.out regex.out regproc.out reindex_catalog.out reltime.out replica_identity.out returning.out roleattributes.out rolenames.out rowsecurity.out rowtypes.out rules.out sanity_check.out security_label.out select.out select_distinct.out select_distinct_on.out select_having.out select_having_1.out select_having_2.out select_implicit.out select_implicit_1.out select_implicit_2.out select_into.out select_parallel.out select_views.out sequence.out spgist.out stats.out stats_ext.out strings.out subscription.out subselect.out sysviews.out tablesample.out temp.out text.out tidscan.out time.out timestamp.out timestamptz.out timetz.out tinterval.out transactions.out triggers.out truncate.out tsdicts.out tsearch.out tsrf.out tstypes.out txid.out type_sanity.out typed_table.out union.out updatable_views.out update.out uuid.out vacuum.out varchar.out varchar_1.out varchar_2.out window.out with.out without_oid.out xml.out xml_1.out xml_2.out xmlmap.out xmlmap_1.out input constraints.source copy.source create_function_1.source create_function_2.source largeobject.source misc.source tablespace.source output constraints.source copy.source create_function_1.source create_function_2.source largeobject.source largeobject_1.source misc.source tablespace.source parallel_schedule pg_regress refint.so regress.so serial_schedule sql abstime.sql advisory_lock.sql aggregates.sql alter_generic.sql alter_operator.sql alter_table.sql amutils.sql arrays.sql async.sql bit.sql bitmapops.sql boolean.sql box.sql brin.sql btree_index.sql case.sql char.sql circle.sql cluster.sql collate.icu.utf8.sql collate.linux.utf8.sql collate.sql combocid.sql comments.sql conversion.sql copy2.sql copydml.sql copyselect.sql create_aggregate.sql create_am.sql create_cast.sql create_function_3.sql create_index.sql create_misc.sql create_operator.sql create_table.sql create_table_like.sql create_type.sql create_view.sql date.sql dbsize.sql delete.sql dependency.sql domain.sql drop_if_exists.sql drop_operator.sql enum.sql equivclass.sql errors.sql event_trigger.sql expressions.sql float4.sql float8.sql foreign_data.sql foreign_key.sql functional_deps.sql geometry.sql gin.sql gist.sql groupingsets.sql guc.sql hash_index.sql horology.sql hs_primary_extremes.sql hs_primary_setup.sql hs_standby_allowed.sql hs_standby_check.sql hs_standby_disallowed.sql hs_standby_functions.sql identity.sql indirect_toast.sql inet.sql inherit.sql init_privs.sql insert.sql insert_conflict.sql int2.sql int4.sql int8.sql interval.sql join.sql json.sql json_encoding.sql jsonb.sql limit.sql line.sql lock.sql lseg.sql macaddr.sql macaddr8.sql matview.sql misc_functions.sql misc_sanity.sql money.sql name.sql namespace.sql numeric.sql numeric_big.sql numerology.sql object_address.sql oid.sql oidjoins.sql opr_sanity.sql password.sql path.sql pg_lsn.sql plancache.sql plpgsql.sql point.sql polygon.sql polymorphism.sql portals.sql portals_p2.sql prepare.sql prepared_xacts.sql privileges.sql psql.sql psql_crosstab.sql publication.sql random.sql rangefuncs.sql rangetypes.sql regex.linux.utf8.sql regex.sql regproc.sql reindex_catalog.sql reltime.sql replica_identity.sql returning.sql roleattributes.sql rolenames.sql rowsecurity.sql rowtypes.sql rules.sql sanity_check.sql security_label.sql select.sql select_distinct.sql select_distinct_on.sql select_having.sql select_implicit.sql select_into.sql select_parallel.sql select_views.sql sequence.sql spgist.sql stats.sql stats_ext.sql strings.sql subscription.sql subselect.sql sysviews.sql tablesample.sql temp.sql text.sql tidscan.sql time.sql timestamp.sql timestamptz.sql timetz.sql tinterval.sql transactions.sql triggers.sql truncate.sql tsdicts.sql tsearch.sql tsrf.sql tstypes.sql txid.sql type_sanity.sql typed_table.sql union.sql updatable_views.sql update.sql uuid.sql vacuum.sql varchar.sql window.sql with.sql without_oid.sql xml.sql xmlmap.sql /usr/lib/postgresql10/ /usr/lib/postgresql10/test/ /usr/lib/postgresql10/test/regress/ /usr/lib/postgresql10/test/regress/data/ /usr/lib/postgresql10/test/regress/expected/ /usr/lib/postgresql10/test/regress/input/ /usr/lib/postgresql10/test/regress/output/ /usr/lib/postgresql10/test/regress/sql/ -fmessage-length=0 -grecord-gcc-switches -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector-strong -funwind-tables -fasynchronous-unwind-tables -fstack-clash-protection -g obs://build.suse.de/SUSE:Maintenance:21242/SUSE_SLE-15-SP1_Update/df6f3529ce696cbf2ce2a253961fa4e8-postgresql10.SUSE_SLE-15-SP1_Update cpio xz 5 ppc64le-suse-linux
directory ELF 64-bit LSB shared object, 64-bit PowerPC or cisco 7500, version 1 (SYSV), dynamically linked, BuildID[sha1]=fab34acbcb1ee105f5376e5a159ae6a6f88eb291, stripped ASCII text ASCII text, with very long lines UTF-8 Unicode text Algol 68 source, ASCII text C source, ASCII text exported SGML document, ASCII text, with very long lines ELF 64-bit LSB shared object, 64-bit PowerPC or cisco 7500, version 1 (SYSV), dynamically linked, interpreter /lib64/ld64.so.2, BuildID[sha1]=6a0092022595ef014a70607e58be36a9cafc20fc, for GNU/Linux 3.10.0, stripped ELF 64-bit LSB shared object, 64-bit PowerPC or cisco 7500, version 1 (SYSV), dynamically linked, BuildID[sha1]=6a4a1aa0a1183146969d7b1e777011d72ef8a0eb, stripped ELF 64-bit LSB shared object, 64-bit PowerPC or cisco 7500, version 1 (SYSV), dynamically linked, BuildID[sha1]=c71ed5064ed5831baf4552d93b9f6969f8dc6ea4, stripped R R R R R R R R R R sRB!w}*W utf-8 bcc733c7bbd7d23488485fab7b71f97880524c161f6011167def5f0201fddc58 ? 7zXZ
! t/㍻]
crt:bLL
y̧,l
ݠ!/TWbt +.$57@ k@1ƶj-uPemHwwa1 (f|0 .mF;[cd>lOHo
~w/jXV_% b3݂P+!/O
:?<ȒJ˫+;}v*bbp[IV ݷ=hKe?h9{.M&\\ˬԑ~RW(|V61ne`CܔLtQ'g $i"C;}r[>/L{cL9rg?XWBU Y\Q /6/x&AcA7X >,?T;Ӂ!7Y?\[7 o=Q}Y
X