Hello community,
here is the log from the commit of package postgresql91.1091 for
openSUSE:12.1:Update checked in at 2012-11-22 11:34:31
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:12.1:Update/postgresql91.1091 (Old)
and /work/SRC/openSUSE:12.1:Update/.postgresql91.1091.new (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "postgresql91.1091", Maintainer is ""
Changes:
--------
New Changes file:
--- /dev/null 2012-10-22 00:44:18.403455820 +0200
+++
/work/SRC/openSUSE:12.1:Update/.postgresql91.1091.new/postgresql91-libs.changes
2012-11-22 11:34:34.000000000 +0100
@@ -0,0 +1,1959 @@
+-------------------------------------------------------------------
+Wed Nov 14 12:12:48 UTC 2012 - [email protected]
+
+- obsolete postgresql-devel before version 9.1.6 to avoid dependency
+ issues of -devel (bnc#789562)
+
+-------------------------------------------------------------------
+Mon Oct 1 08:28:51 UTC 2012 - [email protected]
+
+- Bugfix release 9.1.6 (bnc#782251) to fix data corruption issues.
+ * Users who upgrade from a previous 9.1 release should run
+ REINDEX after applying this update.
+ See also: http://wiki.postgresql.org/wiki/20120924updaterelease
+ * For the full list of changes, see
+ http://www.postgresql.org/docs/9.1/static/release.html
+
+- Change the base name of all PostgreSQL packages from postgresql
+ to postgresql91 and adopt the new packaging schema, which allows
+ the parallel installation of multiple PostgreSQL versions to
+ simplify and speedup migration.
+
+- Move init script, sysconfig file and firewall configuration into
+ a new package called postgresql-init which can work with
+ different PostgreSQL versions.
+
+-------------------------------------------------------------------
+Mon Sep 17 13:06:26 UTC 2012 - [email protected]
+- Security and bugfix release 9.1.5:
+ * Ignore SECURITY DEFINER and SET attributes for a procedural
+ language's call handler (CVE-2012-2655)
+ * Fix incorrect password transformation in "contrib/pgcrypto"'s DES
+ crypt() function (CVE-2012-2143)
+ * Prevent access to external files/URLs via "contrib/xml2"'s
+ xslt_process() (CVE-2012-3488)
+ * Prevent access to external files/URLs via XML entity references
+ (CVE-2012-3489)
+ * See the release notes for the rest of the changes:
+ http://www.postgresql.org/docs/9.1/static/release.html
+ /usr/share/doc/packages/postgresql/HISTORY
+
+-------------------------------------------------------------------
+Mon Mar 12 08:54:39 UTC 2012 - [email protected]
+
+- Security and bugfix release 9.1.3:
+ * Require execute permission on the trigger function for "CREATE
+ TRIGGER" (CVE-2012-0866, bnc#749299).
+ * Remove arbitrary limitation on length of common name in SSL
+ certificates (CVE-2012-0867, bnc#749301).
+ * Convert newlines to spaces in names written in pg_dump
+ comments (CVE-2012-0868, bnc#749303).
+ * See the release notes for the rest of the changes:
+ http://www.postgresql.org/docs/9.1/static/release.html
+ /usr/share/doc/packages/postgresql/HISTORY
+- This also fixes bnc#701489.
+
+-------------------------------------------------------------------
+Wed Oct 5 16:41:31 UTC 2011 - [email protected]
+
+- New version 9.1.1. For detailed release notes, see:
+ http://www.postgresql.org/docs/9.1/static/release-9-1-1.html
+- Stop using deprecated silent_mode in default config.
+- postgresql-perl514.patch is no longer needed.
+- Use %_smp_mflags for parallel make
+- Keep the rpath when linking plperl [bnc#578053].
+
+-------------------------------------------------------------------
+Fri Sep 16 17:17:08 UTC 2011 - [email protected]
+
+- Add postgresql-devel to baselibs
+
+-------------------------------------------------------------------
+Wed Jun 8 16:40:03 UTC 2011 - [email protected]
+
+- Revert the postgresql-libs package split for SLE in preparation
+ of submitting the package to SLE11-SP1.
+
+-------------------------------------------------------------------
+Wed May 25 13:06:16 UTC 2011 - [email protected]
+
+- Fix file name of last added patch and remove overlong comment.
+
+-------------------------------------------------------------------
+Wed May 25 08:06:44 UTC 2011 - [email protected]
+
+- Add postgresql-9.0.4-perl514.patch: For Perl 5.14 GvCV(sv) is no
+ longer an lvalue and needs to be replaced by GvCV_set(sv, value)
+
+-------------------------------------------------------------------
+Thu Apr 21 10:06:45 UTC 2011 - [email protected]
+
+- Bugfix release: 9.0.4:
+ * This update contains a critical fix to the pg_upgrade utility
+ which prevents significant downtime issues. Do not use
+ pg_upgrade without installing this update first.
+ http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
+ * change SQLSTATE for Hot Standby warnings
+ * prevent bgwriter hang during recovery
+ * prevent recursive composite type creation
+ * disallow dropping tables whose triggers are still pending
+ * allow use of "replication" as a user name
+ * prevent a crash during GEQO planning
+ * improve join plans for tables with missing statistics
+ * fix error with SELECT FOR UPDATE in a subselect
+ * close PL/python array slice memory leak
+ * allow SSL connections for users with no home directory
+- http://www.postgresql.org/docs/9.0/static/release-9-0-4.html
+
+-------------------------------------------------------------------
+Fri Apr 1 10:23:05 UTC 2011 - [email protected]
+
+- enabled --with-ossp-uuid
+
+-------------------------------------------------------------------
+Fri Mar 4 15:02:11 UTC 2011 - [email protected]
+
+- Fix the fix of the fix for the successors of postgresql-libs.
+
+-------------------------------------------------------------------
+Mon Feb 21 01:09:08 CET 2011 - [email protected]
+
+- provide postgresql-libs in the specfile that actually builds
+ the libs package
+
+-------------------------------------------------------------------
+Sat Feb 19 20:11:07 UTC 2011 - [email protected]
+
+- fix update of libs
+
+-------------------------------------------------------------------
+Thu Feb 17 11:38:42 UTC 2011 - [email protected]
+
+- Move all of pgxs into the devel package to fix build of server
+ extensions.
+
+-------------------------------------------------------------------
+Wed Feb 16 19:10:54 UTC 2011 - [email protected]
+
+- Move pg_config from -server to -devel to fix build of certain
+ client apps and language bindings, but using pg_config on the
+ client side is still considered broken, because it tells what
+ got linked into the server binary not what got linked into libpq.
+
+-------------------------------------------------------------------
+Tue Feb 8 18:23:22 UTC 2011 - [email protected]
+
+- Remove unneeded PreReq from postgresql on postgresql-libs.
+
+-------------------------------------------------------------------
+Fri Feb 4 11:40:12 UTC 2011 - [email protected]
+
+- New version: 9.0.3. For the complete release notes, see
+ http://www.postgresql.org/docs/9.0/static/release.html
+- Build libs and devel separate from the main package.
+- Build the PL subpackages as part of the main package.
+- Have separate packages for libpq and libecpg.
+- Generate the main and lib spec files from postgresql.spec.in.
+
+-------------------------------------------------------------------
+Wed Dec 8 13:00:12 UTC 2010 - [email protected]
+
+- Fix LSB conformance of the init script (bnc#658014).
+
+-------------------------------------------------------------------
+Thu Oct 7 17:34:57 CEST 2010 - [email protected]
+
+- Security and bugfix release 8.4.5 (bnc#643771):
+
+ * Use a separate interpreter for each calling SQL userid in
+ PL/Perl and PL/Tcl (CVE-2010-3433).
+
+ * Prevent possible crashes in pg_get_expr() by disallowing it
+ from being called with an argument that is not one of the
+ system catalog columns it's intended to be used with.
+
+ * Fix incorrect placement of placeholder evaluation.
+
+ * Fix possible duplicate scans of UNION ALL member relations.
+
+ * Fix "cannot handle unplanned sub-select" error.
+
+ * Fix mishandling of whole-row Vars that reference a view or
+ sub-select and appear within a nested sub-select.
+
+ * Fix mishandling of cross-type IN comparisons.
+
+ * Fix computation of ANALYZE statistics for tsvector columns.
+
+ * Improve planner's estimate of memory used by array_agg(),
+ string_agg(), and similar aggregate functions.
+
+ * Fix failure to mark cached plans as transient.
+
+ * Reduce PANIC to ERROR in some occasionally-reported btree
+ failure cases, and provide additional detail in the resulting
+ error messages.
+
+ * Fix incorrect search logic for partial-match queries with GIN
++++ 1762 more lines (skipped)
++++ between /dev/null
++++ and
/work/SRC/openSUSE:12.1:Update/.postgresql91.1091.new/postgresql91-libs.changes
New Changes file:
--- /dev/null 2012-10-22 00:44:18.403455820 +0200
+++ /work/SRC/openSUSE:12.1:Update/.postgresql91.1091.new/postgresql91.changes
2012-11-22 11:34:34.000000000 +0100
@@ -0,0 +1,1959 @@
+-------------------------------------------------------------------
+Wed Nov 14 12:12:14 UTC 2012 - [email protected]
+
+- obsolete postgresql-devel before version 9.1.6 to avoid dependency
+ issues of -devel (bnc#789562)
+
+-------------------------------------------------------------------
+Mon Oct 1 08:28:51 UTC 2012 - [email protected]
+
+- Bugfix release 9.1.6 (bnc#782251) to fix data corruption issues.
+ * Users who upgrade from a previous 9.1 release should run
+ REINDEX after applying this update.
+ See also: http://wiki.postgresql.org/wiki/20120924updaterelease
+ * For the full list of changes, see
+ http://www.postgresql.org/docs/9.1/static/release.html
+
+- Change the base name of all PostgreSQL packages from postgresql
+ to postgresql91 and adopt the new packaging schema, which allows
+ the parallel installation of multiple PostgreSQL versions to
+ simplify and speedup migration.
+
+- Move init script, sysconfig file and firewall configuration into
+ a new package called postgresql-init which can work with
+ different PostgreSQL versions.
+
+-------------------------------------------------------------------
+Mon Sep 17 13:06:26 UTC 2012 - [email protected]
+- Security and bugfix release 9.1.5:
+ * Ignore SECURITY DEFINER and SET attributes for a procedural
+ language's call handler (CVE-2012-2655)
+ * Fix incorrect password transformation in "contrib/pgcrypto"'s DES
+ crypt() function (CVE-2012-2143)
+ * Prevent access to external files/URLs via "contrib/xml2"'s
+ xslt_process() (CVE-2012-3488)
+ * Prevent access to external files/URLs via XML entity references
+ (CVE-2012-3489)
+ * See the release notes for the rest of the changes:
+ http://www.postgresql.org/docs/9.1/static/release.html
+ /usr/share/doc/packages/postgresql/HISTORY
+
+-------------------------------------------------------------------
+Mon Mar 12 08:54:39 UTC 2012 - [email protected]
+
+- Security and bugfix release 9.1.3:
+ * Require execute permission on the trigger function for "CREATE
+ TRIGGER" (CVE-2012-0866, bnc#749299).
+ * Remove arbitrary limitation on length of common name in SSL
+ certificates (CVE-2012-0867, bnc#749301).
+ * Convert newlines to spaces in names written in pg_dump
+ comments (CVE-2012-0868, bnc#749303).
+ * See the release notes for the rest of the changes:
+ http://www.postgresql.org/docs/9.1/static/release.html
+ /usr/share/doc/packages/postgresql/HISTORY
+- This also fixes bnc#701489.
+
+-------------------------------------------------------------------
+Wed Oct 5 16:41:31 UTC 2011 - [email protected]
+
+- New version 9.1.1. For detailed release notes, see:
+ http://www.postgresql.org/docs/9.1/static/release-9-1-1.html
+- Stop using deprecated silent_mode in default config.
+- postgresql-perl514.patch is no longer needed.
+- Use %_smp_mflags for parallel make
+- Keep the rpath when linking plperl [bnc#578053].
+
+-------------------------------------------------------------------
+Fri Sep 16 17:17:08 UTC 2011 - [email protected]
+
+- Add postgresql-devel to baselibs
+
+-------------------------------------------------------------------
+Wed Jun 8 16:40:03 UTC 2011 - [email protected]
+
+- Revert the postgresql-libs package split for SLE in preparation
+ of submitting the package to SLE11-SP1.
+
+-------------------------------------------------------------------
+Wed May 25 13:06:16 UTC 2011 - [email protected]
+
+- Fix file name of last added patch and remove overlong comment.
+
+-------------------------------------------------------------------
+Wed May 25 08:06:44 UTC 2011 - [email protected]
+
+- Add postgresql-9.0.4-perl514.patch: For Perl 5.14 GvCV(sv) is no
+ longer an lvalue and needs to be replaced by GvCV_set(sv, value)
+
+-------------------------------------------------------------------
+Thu Apr 21 10:06:45 UTC 2011 - [email protected]
+
+- Bugfix release: 9.0.4:
+ * This update contains a critical fix to the pg_upgrade utility
+ which prevents significant downtime issues. Do not use
+ pg_upgrade without installing this update first.
+ http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
+ * change SQLSTATE for Hot Standby warnings
+ * prevent bgwriter hang during recovery
+ * prevent recursive composite type creation
+ * disallow dropping tables whose triggers are still pending
+ * allow use of "replication" as a user name
+ * prevent a crash during GEQO planning
+ * improve join plans for tables with missing statistics
+ * fix error with SELECT FOR UPDATE in a subselect
+ * close PL/python array slice memory leak
+ * allow SSL connections for users with no home directory
+- http://www.postgresql.org/docs/9.0/static/release-9-0-4.html
+
+-------------------------------------------------------------------
+Fri Apr 1 10:23:05 UTC 2011 - [email protected]
+
+- enabled --with-ossp-uuid
+
+-------------------------------------------------------------------
+Fri Mar 4 15:02:11 UTC 2011 - [email protected]
+
+- Fix the fix of the fix for the successors of postgresql-libs.
+
+-------------------------------------------------------------------
+Mon Feb 21 01:09:08 CET 2011 - [email protected]
+
+- provide postgresql-libs in the specfile that actually builds
+ the libs package
+
+-------------------------------------------------------------------
+Sat Feb 19 20:11:07 UTC 2011 - [email protected]
+
+- fix update of libs
+
+-------------------------------------------------------------------
+Thu Feb 17 11:38:42 UTC 2011 - [email protected]
+
+- Move all of pgxs into the devel package to fix build of server
+ extensions.
+
+-------------------------------------------------------------------
+Wed Feb 16 19:10:54 UTC 2011 - [email protected]
+
+- Move pg_config from -server to -devel to fix build of certain
+ client apps and language bindings, but using pg_config on the
+ client side is still considered broken, because it tells what
+ got linked into the server binary not what got linked into libpq.
+
+-------------------------------------------------------------------
+Tue Feb 8 18:23:22 UTC 2011 - [email protected]
+
+- Remove unneeded PreReq from postgresql on postgresql-libs.
+
+-------------------------------------------------------------------
+Fri Feb 4 11:40:12 UTC 2011 - [email protected]
+
+- New version: 9.0.3. For the complete release notes, see
+ http://www.postgresql.org/docs/9.0/static/release.html
+- Build libs and devel separate from the main package.
+- Build the PL subpackages as part of the main package.
+- Have separate packages for libpq and libecpg.
+- Generate the main and lib spec files from postgresql.spec.in.
+
+-------------------------------------------------------------------
+Wed Dec 8 13:00:12 UTC 2010 - [email protected]
+
+- Fix LSB conformance of the init script (bnc#658014).
+
+-------------------------------------------------------------------
+Thu Oct 7 17:34:57 CEST 2010 - [email protected]
+
+- Security and bugfix release 8.4.5 (bnc#643771):
+
+ * Use a separate interpreter for each calling SQL userid in
+ PL/Perl and PL/Tcl (CVE-2010-3433).
+
+ * Prevent possible crashes in pg_get_expr() by disallowing it
+ from being called with an argument that is not one of the
+ system catalog columns it's intended to be used with.
+
+ * Fix incorrect placement of placeholder evaluation.
+
+ * Fix possible duplicate scans of UNION ALL member relations.
+
+ * Fix "cannot handle unplanned sub-select" error.
+
+ * Fix mishandling of whole-row Vars that reference a view or
+ sub-select and appear within a nested sub-select.
+
+ * Fix mishandling of cross-type IN comparisons.
+
+ * Fix computation of ANALYZE statistics for tsvector columns.
+
+ * Improve planner's estimate of memory used by array_agg(),
+ string_agg(), and similar aggregate functions.
+
+ * Fix failure to mark cached plans as transient.
+
+ * Reduce PANIC to ERROR in some occasionally-reported btree
+ failure cases, and provide additional detail in the resulting
+ error messages.
+
+ * Fix incorrect search logic for partial-match queries with GIN
++++ 1762 more lines (skipped)
++++ between /dev/null
++++ and
/work/SRC/openSUSE:12.1:Update/.postgresql91.1091.new/postgresql91.changes
New:
----
baselibs.conf
postgresql-9.1.6.tar.bz2
postgresql-README.SUSE
postgresql-bashprofile
postgresql-conf.patch
postgresql-pg_upgrade.patch
postgresql-plperl.patch
postgresql-regress.patch
postgresql-rpmlintrc
postgresql-sle10-timestamptz.patch
postgresql91-full.spec.in
postgresql91-libs.changes
postgresql91-libs.spec
postgresql91.changes
postgresql91.spec
pre_checkin.sh
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Other differences:
------------------
++++++ postgresql91-libs.spec ++++++
++++ 640 lines (skipped)
postgresql91.spec: same change
++++++ baselibs.conf ++++++
libpq5
provides "postgresql-libs-<targettype> = <version>"
obsoletes "postgresql-libs-<targettype> < <version>"
conflicts "postgresql-libs-<targettype> < 9.1.6"
libecpg6
postgresql91-devel
requires -postgresql91-<targettype>
requires "libpq5-<targettype> = <version>"
provides "postgresql-devel-<targettype> = <version>"
obsoletes "postgresql-devel-<targettype> < <version>"
conflicts "postgresql-devel-<targettype> < 9.1.6"
++++++ postgresql-README.SUSE ++++++
Newer versions of PostgreSQL come with the pg_upgrade tool that
simplifies and speeds up the migration of a PostgreSQL installation to
a new version. Formerly dump and restore was needed that was much
slower.
pg_upgrade needs to have the server binaries of both versions
available. To allow this, we had to change the way PostgreSQL is
packaged as well as the naming of the packages, so that two or more
versions of PostgreSQL can be installed in parallel.
Starting with version 9.1, PostgreSQL package names contain numbers
indicating the major version. In PostgreSQL terms the major version
consists of the first two components of the version number, i.e. 8.3,
8.4, 9.0, or 9.1. So, the packages for Postgresql 9.1 are named
postgresql91, postgresql91-server, etc. Inside the packages the files
were moved from their standard locations to a versioned location such
as /usr/lib/postgresql83/bin or /usr/lib/postgresql91/bin to avoid
file conflicts if packages are installed in parallel. The
update-alternatives mechanism creates and maintains symbolic links
that cause one version (by default the highest installed version) to
re-appear in the standard locations. By default, database data are
stored under /var/lib/pgsql/data on SUSE Linux.
The following preconditions have to be fulfilled before data migration
can be started:
1. If not already done, the packages of the old PostgreSQL version
must be upgraded to the new packaging scheme through a maintenance
update. For SLE11 this means to install the patch that upgrades
PostgreSQL from version 8.3.14 to 8.3.19 or higher.
2. The packages of the new PostgreSQL major version need to be
installed. For SLE11 this means to install postgresql91-server and
all the packages it depends on. As pg_upgrade is contained in
postgresql91-contrib, that one has to be installed as well, at least
until the migration is done.
3. Unless pg_upgrade is used in link mode, the server must have
enough free disk space to temporarily hold a copy of the database
files. If the database instance was installed in the default
location, the needed space in megabytes can be determined by running
the follwing command as root: "du -hs /var/lib/pgsql/data". If space
is tight, it might help to run the "VACUUM FULL" SQL command on each
database in the instance to be migrated, but be aware that it might
take very long.
Upstream documentation about pg_upgrade including step by step
instructions for performing a database migration can be found under
file:///usr/share/doc/packages/postgresql91/html/pgupgrade.html (if
the postgresql91-docs package is installed), or online under
http://www.postgresql.org/docs/9.1/static/pgupgrade.html .
NOTE: The online documentation starts with explaining how you can
install PostgreSQL from the upstream sources (which is not necessary
on SLES) and also uses other directory names (/usr/local instead of
the update-alternatives based path as described above).
For background information about the inner workings of pg_admin and a
performance comparison with the old dump and restore method, see
http://momjian.us/main/writings/pgsql/pg_upgrade.pdf .++++++
postgresql-bashprofile ++++++
# Get PGDATA from /etc/sysconfig/postgresql
if test -f /etc/sysconfig/postgresql; then
eval eval $(sed -n '/^POSTGRES_DATADIR=/s//PGDATA=/p'
/etc/sysconfig/postgresql)
export PGDATA
fi
++++++ postgresql-conf.patch ++++++
Index: src/backend/utils/misc/postgresql.conf.sample
===================================================================
--- src/backend/utils/misc/postgresql.conf.sample.orig
+++ src/backend/utils/misc/postgresql.conf.sample
@@ -273,13 +273,13 @@
# - Where to Log -
-#log_destination = 'stderr' # Valid values are combinations of
+log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog, and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.
# This is used when logging to stderr:
-#logging_collector = off # Enable capturing of stderr and csvlog
+logging_collector = on # Enable capturing of stderr and csvlog
# into log files. Required to be on for
# csvlogs.
# (change requires restart)
@@ -374,7 +374,8 @@
#log_duration = off
#log_error_verbosity = default # terse, default, or verbose messages
#log_hostname = off
-#log_line_prefix = '' # special values:
+log_line_prefix = '%t %d %u '
+ # special values:
# %a = application name
# %u = user name
# %d = database name
++++++ postgresql-pg_upgrade.patch ++++++
--- contrib/pg_upgrade/exec.c
+++ contrib/pg_upgrade/exec.c
@@ -210,7 +210,6 @@ check_bin_dir(ClusterInfo *cluster)
if (cluster == &new_cluster)
{
/* these are only needed in the new cluster */
- validate_exec(cluster->bindir, "pg_config");
validate_exec(cluster->bindir, "psql");
validate_exec(cluster->bindir, "pg_dumpall");
}
++++++ postgresql-plperl.patch ++++++
Index: config/perl.m4
===================================================================
--- config/perl.m4.orig
+++ config/perl.m4
@@ -57,9 +57,7 @@ AC_DEFUN([PGAC_CHECK_PERL_CONFIGS],
AC_DEFUN([PGAC_CHECK_PERL_EMBED_LDFLAGS],
[AC_REQUIRE([PGAC_PATH_PERL])
AC_MSG_CHECKING(for flags to link embedded Perl)
-pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
-pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
-perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%"
-e ["s/ -arch [-a-zA-Z0-9_]*//g"]`
+perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
AC_SUBST(perl_embed_ldflags)dnl
if test -z "$perl_embed_ldflags" ; then
AC_MSG_RESULT(no)
Index: configure
===================================================================
--- configure.orig
+++ configure
@@ -7218,9 +7218,7 @@ $as_echo "$perl_useshrplib" >&6; }
{ $as_echo "$as_me:$LINENO: checking for flags to link embedded Perl" >&5
$as_echo_n "checking for flags to link embedded Perl... " >&6; }
-pgac_tmp1=`$PERL -MExtUtils::Embed -e ldopts`
-pgac_tmp2=`$PERL -MConfig -e 'print $Config{ccdlflags}'`
-perl_embed_ldflags=`echo X"$pgac_tmp1" | sed -e "s/^X//" -e "s%$pgac_tmp2%%"
-e "s/ -arch [-a-zA-Z0-9_]*//g"`
+perl_embed_ldflags=`$PERL -MExtUtils::Embed -e ldopts`
if test -z "$perl_embed_ldflags" ; then
{ $as_echo "$as_me:$LINENO: result: no" >&5
$as_echo "no" >&6; }
++++++ postgresql-regress.patch ++++++
Index: src/test/regress/expected/horology.out
===================================================================
--- src/test/regress/expected/horology.out.orig
+++ src/test/regress/expected/horology.out
@@ -616,26 +616,26 @@ SELECT (timestamp with time zone 'tomorr
(1 row)
-- timestamp with time zone, interval arithmetic around DST change
-SET TIME ZONE 'CST7CDT';
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as
"Apr 3, 12:00";
+SET TIME ZONE 'CST6CDT';
+SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '1 day' as
"Apr 3, 12:00";
Apr 3, 12:00
------------------------------
Sun Apr 03 12:00:00 2005 CDT
(1 row)
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as
"Apr 3, 13:00";
+SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '24 hours' as
"Apr 3, 13:00";
Apr 3, 13:00
------------------------------
Sun Apr 03 13:00:00 2005 CDT
(1 row)
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as
"Apr 2, 12:00";
+SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '1 day' as
"Apr 2, 12:00";
Apr 2, 12:00
------------------------------
Sat Apr 02 12:00:00 2005 CST
(1 row)
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as
"Apr 2, 11:00";
+SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '24 hours' as
"Apr 2, 11:00";
Apr 2, 11:00
------------------------------
Sat Apr 02 11:00:00 2005 CST
Index: src/test/regress/pg_regress.c
===================================================================
--- src/test/regress/pg_regress.c.orig
+++ src/test/regress/pg_regress.c
@@ -72,7 +72,7 @@ static char *shellprog = SHELLPROG;
*/
#ifndef WIN32
const char *basic_diff_opts = "";
-const char *pretty_diff_opts = "-C3";
+const char *pretty_diff_opts = "-U5";
#else
const char *basic_diff_opts = "-w";
const char *pretty_diff_opts = "-w -C3";
Index: src/test/regress/sql/horology.sql
===================================================================
--- src/test/regress/sql/horology.sql.orig
+++ src/test/regress/sql/horology.sql
@@ -116,11 +116,11 @@ SELECT (timestamp with time zone 'tomorr
SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
-- timestamp with time zone, interval arithmetic around DST change
-SET TIME ZONE 'CST7CDT';
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as
"Apr 3, 12:00";
-SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as
"Apr 3, 13:00";
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as
"Apr 2, 12:00";
-SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as
"Apr 2, 11:00";
+SET TIME ZONE 'CST6CDT';
+SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '1 day' as
"Apr 3, 12:00";
+SELECT timestamp with time zone '2005-04-02 12:00-06' + interval '24 hours' as
"Apr 3, 13:00";
+SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '1 day' as
"Apr 2, 12:00";
+SELECT timestamp with time zone '2005-04-03 12:00-05' - interval '24 hours' as
"Apr 2, 11:00";
RESET TIME ZONE;
++++++ postgresql-rpmlintrc ++++++
addFilter("useless-explicit-provides")
addFilter("unnecessary-buildrequires")
addFilter("patch-not-applied")
addFilter("non-standard-uid")
addFilter("file-not-in-%lang")
addFilter("no-dependency-on")
++++++ postgresql-sle10-timestamptz.patch ++++++
Only for SLE10. On other platforms, the test works.
poeml, Mon Jul 27 19:12:40 CEST 2009
diff -uNr postgresql-8.4.0.orig/src/test/regress/expected/timestamptz.out
postgresql-8.4.0/src/test/regress/expected/timestamptz.out
--- postgresql-8.4.0.orig/src/test/regress/expected/timestamptz.out
2009-03-22 02:12:32.000000000 +0100
+++ postgresql-8.4.0/src/test/regress/expected/timestamptz.out 2009-07-27
19:11:39.280087000 +0200
@@ -153,7 +153,7 @@
SELECT '20500710 173201 Europe/Helsinki'::timestamptz; -- DST
timestamptz
------------------------------
- Sun Jul 10 07:32:01 2050 PDT
+ Sun Jul 10 07:32:01 2050 PST
(1 row)
SELECT '20500110 173201 Europe/Helsinki'::timestamptz; -- non-DST
@@ -165,7 +165,7 @@
SELECT '205000-07-10 17:32:01 Europe/Helsinki'::timestamptz; -- DST
timestamptz
--------------------------------
- Thu Jul 10 07:32:01 205000 PDT
+ Thu Jul 10 07:32:01 205000 PST
(1 row)
SELECT '205000-01-10 17:32:01 Europe/Helsinki'::timestamptz; -- non-DST
++++++ postgresql91-full.spec.in ++++++
++++ 646 lines (skipped)
++++++ pre_checkin.sh ++++++
#!/bin/bash
SPEC=postgresql*-full.spec.in
VERSION=$(awk '/define packageversion/{print $3}' $SPEC)
cp -a postgresql$VERSION.changes postgresql$VERSION-libs.changes
for f in postgresql$VERSION postgresql$VERSION-libs; do
sed "s/^\(Name: *\).*/\\1 $f/" $SPEC > $f.spec
done
sed -i \
-e 's/%define buildmain .*/%define buildmain 1/' \
-e 's/%define buildlibs .*/%define buildlibs 0/' \
postgresql$VERSION.spec
sed -i \
-e 's/%define buildmain .*/%define buildmain 0/' \
-e 's/%define buildlibs .*/%define buildlibs 1/' \
postgresql$VERSION-libs.spec
--
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
