Hello community, here is the log from the commit of package postgresql.863 for openSUSE:12.2:Update checked in at 2012-09-14 13:42:02 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:12.2:Update/postgresql.863 (Old) and /work/SRC/openSUSE:12.2:Update/.postgresql.863.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "postgresql.863", Maintainer is "" Changes: -------- New Changes file: --- /dev/null 2012-08-23 02:41:28.555381587 +0200 +++ /work/SRC/openSUSE:12.2:Update/.postgresql.863.new/postgresql-libs.changes 2012-09-14 13:42:04.000000000 +0200 @@ -0,0 +1,1919 @@ +------------------------------------------------------------------- +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 + indexes. + + * Prevent show_session_authorization() from crashing within + autovacuum processes. + + * Defend against functions returning setof record where not all + the returned rows are actually of the same rowtype. + + * Fix possible corruption of pending trigger event lists during + subtransaction rollback. + + * Fix possible failure when hashing a pass-by-reference function + result. + + * Improve merge join's handling of NULLs in the join columns. + + * Take care to fsync the contents of lockfiles (both + postmaster.pid and the socket lockfile) while writing them. + + * Avoid recursion while assigning XIDs to heavily-nested + subtransactions. + + * Avoid holding open old WAL segments in the walwriter process. + + * Fix log_line_prefix's %i escape, which could produce junk + early in backend startup. + + * Prevent misinterpretation of partially-specified relation + options for TOAST tables. + + * Fix inheritance count tracking in ALTER TABLE ... ADD + CONSTRAINT. + + * Fix possible data corruption in ALTER TABLE ... SET TABLESPACE + when archiving is enabled. + + * Allow CREATE DATABASE and ALTER DATABASE ... SET TABLESPACE to + be interrupted by query-cancel. + + * Improve CREATE INDEX's checking of whether proposed index ++++ 1722 more lines (skipped) ++++ between /dev/null ++++ and /work/SRC/openSUSE:12.2:Update/.postgresql.863.new/postgresql-libs.changes New Changes file: postgresql.changes: same change New: ---- baselibs.conf postgresql-9.1.3.tar.bz2 postgresql-README.SuSE.de postgresql-README.SuSE.en postgresql-bashprofile postgresql-conf.patch postgresql-firewall postgresql-init postgresql-libs.changes postgresql-libs.spec postgresql-mkspecfiles postgresql-plperl.patch postgresql-regress.patch postgresql-rpmlintrc postgresql-sle10-timestamptz.patch postgresql-sysconfig postgresql.changes postgresql.spec postgresql.spec.in ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ postgresql-libs.spec ++++++ # # spec file for package postgresql-libs # # Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed # upon. The license for this file, and modifications and additions to the # file, is the same license as for the pristine package itself (unless the # license for the pristine package is not an Open Source License, in which # case the license is the MIT License). An "Open Source License" is a # license that conforms to the Open Source Definition (Version 1.9) # published by the Open Source Initiative. # Please submit bugfixes or comments via http://bugs.opensuse.org/ # %if 0%{?sles_version} && %sles_version <= 11 %define libs_package 1 %else %define libs_package 0 %endif Name: postgresql-libs %define _name postgresql %define libpq libpq5 %define libecpg libecpg6 %define buildall 0 %define extensiondir %_datadir/postgresql/extension %if 0%{?suse_version} > 910 BuildRequires: krb5-devel BuildRequires: libxslt-devel %endif BuildRequires: openldap2-devel BuildRequires: openssl-devel Summary: Basic Clients and Utilities for PostgreSQL License: BSD-3-Clause Group: Productivity/Databases/Tools Version: 9.1.3 Release: 0 %define pg_minor_version %(echo %version | sed -r 's/^([0-9]+\\.[0-9]+).*/\\1/') Source0: postgresql-%version.tar.bz2 Source1: baselibs.conf Source2: postgresql-README.SuSE.de Source3: postgresql-README.SuSE.en Source8: postgresql-sysconfig Source9: postgresql-init Source15: postgresql-bashprofile Source16: postgresql-firewall Source17: postgresql-rpmlintrc Source100: postgresql-mkspecfiles Source101: postgresql.spec.in Patch1: postgresql-conf.patch Patch2: postgresql-regress.patch Patch3: postgresql-sle10-timestamptz.patch Patch4: postgresql-plperl.patch Url: http://www.postgresql.org/ BuildRoot: %{_tmppath}/%{name}-%{version}-build Provides: postgresql = %pg_minor_version %description PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the basic utility and client programs necessary to maintain and work with local or remote PostgreSQL databases as well as manual pages for the SQL commands that PostgreSQL supports. Full HTML documentation for PostgreSQL can be found in the postgresql-docs package. %if %libs_package %package libs Summary: Shared Libraries Required for PostgreSQL Clients Group: Productivity/Databases/Clients # bug437293 %ifarch ppc64 Obsoletes: postgresql-libs-64bit %endif # Provides: postgresql-libs = %pg_minor_version PreReq: sh-utils fileutils %description libs PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This package provides the essential shared libraries for (almost) any PostgreSQL client program or interface. You will need to install this package in order to use any other PostgreSQL package or any clients that need to connect to a PostgreSQL server. %else %package -n %libpq Summary: Shared Libraries Required for PostgreSQL Clients Group: Productivity/Databases/Clients Provides: postgresql-libs = %version Obsoletes: postgresql-libs < %version # bug437293 %ifarch ppc64 Obsoletes: postgresql-libs-64bit %endif %description -n %libpq PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This package provides the client library that most PostgreSQL client program or language bindings are using. %package -n %libecpg Summary: Shared Libraries Required for PostgreSQL Clients Group: Productivity/Databases/Clients Provides: postgresql-libs:%_libdir/libecpg.so.6 %description -n %libecpg PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This package provides the runtime library of the embedded SQL C preprocessor for PostgreSQL. %endif %package -n %_name-devel Summary: PostgreSQL development header files and libraries Group: Productivity/Databases/Tools %if %libs_package Requires: postgresql-libs %else Requires: %libecpg Requires: %libpq %endif %description -n %_name-devel PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the header files and libraries needed to compile C applications which will directly interact with a PostgreSQL database management server and the ECPG Embedded C Postgres preprocessor. You need to install this package if you want to develop applications in C which will interact with a PostgreSQL server. %prep %setup -q -n %_name-%version # Keep the timestamp of configure, because patching it would otherwise # confuse PostgreSQL's build system touch -r configure tmp %patch1 %patch2 # apply the following patch only on SLE10 %if 0%{?suse_version} == 1010 %patch3 -p1 %endif %patch4 touch -r tmp configure rm tmp %build export CFLAGS="%optflags $SP" # uncomment the following line to enable the stack protector # CFLAGS="$CFLAGS -fstack-protector" %configure \ --includedir=%_includedir/pgsql \ --datadir=%_datadir/postgresql \ --docdir=%_docdir \ --disable-rpath \ --enable-nls \ --enable-thread-safety \ --enable-integer-datetimes \ --without-readline \ --with-openssl \ --with-ldap \ %if 0%{?suse_version} > 910 --with-gssapi \ --with-libxml \ --with-libxslt \ --with-krb5 \ %endif --with-system-tzdata=/usr/share/zoneinfo make -C src/backend %{?jobs:-j%jobs} libpq-recursive make -C src/interfaces %{?jobs:-j%jobs} make -C src/port %{?jobs:-j%jobs} libpgport.a make -C src/bin/pg_config %{?jobs:-j%jobs} pg_config %install SUBINSTALL=install install -d %buildroot%_mandir/man1 install doc/src/sgml/man1/{ecpg,pg_config}.1 %buildroot%_mandir/man1 if test -n "$SUBINSTALL"; then # Install them for postgresql-libs and uninstall them for postgresql make -C src DESTDIR=%buildroot $SUBINSTALL-local for dir in \ config \ src/bin/pg_config \ src/interfaces \ src/include \ src/makefiles \ src/port \ src/test/regress do make -C $dir DESTDIR=%buildroot $SUBINSTALL done fi # Don't ship static libraries, libpgport.a is needed, though. rm -f $(ls %buildroot/%_libdir/*.a | grep -F -v libpgport.a) %find_lang libpq5-%{pg_minor_version} %libpq.lang %find_lang ecpglib6-%{pg_minor_version} %libecpg.lang cat %libpq.lang %libecpg.lang > postgresql-libs.lang %find_lang ecpg-%{pg_minor_version} %_name-devel.lang %find_lang pg_config-%{pg_minor_version} %_name-devel.lang %if %libs_package %post -n postgresql-libs -p /sbin/ldconfig %postun -n postgresql-libs -p /sbin/ldconfig %else %post -n %libpq -p /sbin/ldconfig %postun -n %libpq -p /sbin/ldconfig %post -n %libecpg -p /sbin/ldconfig %postun -n %libecpg -p /sbin/ldconfig %endif %clean rm -rf %buildroot rm -f %my_provides %if %libs_package %files -n postgresql-libs -f postgresql-libs.lang %else %files -n %libpq -f %libpq.lang %endif %defattr(-,root,root) %_libdir/libpq.so.* %if !%libs_package %files -n %libecpg -f %libecpg.lang %defattr(-,root,root) %endif %_libdir/libecpg*.so.* %_libdir/libpgtypes.so.* %files -n %_name-devel -f %_name-devel.lang %defattr(-,root,root) %doc %_mandir/man1/ecpg.1* %_bindir/pg_config %doc %_mandir/man1/pg_config.1* %_bindir/ecpg %_libdir/libpgport.a %_libdir/lib*.so %dir %_libdir/postgresql %_libdir/postgresql/pgxs %_includedir/pgsql %dir %_datadir/postgresql %_datadir/postgresql/pg_service.conf.sample %changelog ++++++ postgresql.spec ++++++ # # spec file for package postgresql # # Copyright (c) 2012 SUSE LINUX Products GmbH, Nuernberg, Germany. # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed # upon. The license for this file, and modifications and additions to the # file, is the same license as for the pristine package itself (unless the # license for the pristine package is not an Open Source License, in which # case the license is the MIT License). An "Open Source License" is a # license that conforms to the Open Source Definition (Version 1.9) # published by the Open Source Initiative. # Please submit bugfixes or comments via http://bugs.opensuse.org/ # %if 0%{?sles_version} && %sles_version <= 11 %define libs_package 1 %else %define libs_package 0 %endif Name: postgresql BuildRequires: gettext-devel BuildRequires: ncurses-devel BuildRequires: pam-devel BuildRequires: python-devel BuildRequires: readline-devel BuildRequires: tcl-devel BuildRequires: uuid-devel BuildRequires: zlib-devel %if 0%{?suse_version} >= 1110 BuildRequires: fdupes %else %define fdupes # %endif %define _name postgresql %define libpq libpq5 %define libecpg libecpg6 %define buildall 0 %define extensiondir %_datadir/postgresql/extension %if 0%{?suse_version} > 910 BuildRequires: krb5-devel BuildRequires: libxslt-devel %endif BuildRequires: openldap2-devel BuildRequires: openssl-devel Summary: Basic Clients and Utilities for PostgreSQL License: BSD-3-Clause Group: Productivity/Databases/Tools Version: 9.1.3 Release: 0 %define pg_minor_version %(echo %version | sed -r 's/^([0-9]+\\.[0-9]+).*/\\1/') Source0: postgresql-%version.tar.bz2 Source1: baselibs.conf Source2: postgresql-README.SuSE.de Source3: postgresql-README.SuSE.en Source8: postgresql-sysconfig Source9: postgresql-init Source15: postgresql-bashprofile Source16: postgresql-firewall Source17: postgresql-rpmlintrc Source100: postgresql-mkspecfiles Source101: postgresql.spec.in Patch1: postgresql-conf.patch Patch2: postgresql-regress.patch Patch3: postgresql-sle10-timestamptz.patch Patch4: postgresql-plperl.patch Url: http://www.postgresql.org/ BuildRoot: %{_tmppath}/%{name}-%{version}-build Provides: postgresql = %pg_minor_version %description PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the basic utility and client programs necessary to maintain and work with local or remote PostgreSQL databases as well as manual pages for the SQL commands that PostgreSQL supports. Full HTML documentation for PostgreSQL can be found in the postgresql-docs package. %if %libs_package %package libs Summary: Shared Libraries Required for PostgreSQL Clients Group: Productivity/Databases/Clients # bug437293 %ifarch ppc64 Obsoletes: postgresql-libs-64bit %endif # Provides: postgresql-libs = %pg_minor_version PreReq: sh-utils fileutils %description libs PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This package provides the essential shared libraries for (almost) any PostgreSQL client program or interface. You will need to install this package in order to use any other PostgreSQL package or any clients that need to connect to a PostgreSQL server. %else %package -n %libpq Summary: Shared Libraries Required for PostgreSQL Clients Group: Productivity/Databases/Clients Provides: postgresql-libs = %version Obsoletes: postgresql-libs < %version # bug437293 %ifarch ppc64 Obsoletes: postgresql-libs-64bit %endif %description -n %libpq PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This package provides the client library that most PostgreSQL client program or language bindings are using. %package -n %libecpg Summary: Shared Libraries Required for PostgreSQL Clients Group: Productivity/Databases/Clients Provides: postgresql-libs:%_libdir/libecpg.so.6 %description -n %libecpg PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions. This package provides the runtime library of the embedded SQL C preprocessor for PostgreSQL. %endif %package server Summary: The Programs Needed to Create and Run a PostgreSQL Server Group: Productivity/Databases/Servers PreReq: %insserv_prereq %fillup_prereq PreReq: /usr/sbin/useradd /usr/sbin/groupadd /sbin/chkconfig PreReq: /usr/bin/strings /bin/sed PreReq: postgresql = %pg_minor_version Requires: glibc-locale Provides: postgresql-server = %pg_minor_version %package docs Summary: HTML Documentation for PostgreSQL Group: Productivity/Databases/Tools %if 0%{?suse_version} >= 1120 BuildArch: noarch %endif %description docs PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the HTML documentation for PostgreSQL. The start page is: file:///usr/share/doc/packages/postgresql/html/index.html . Manual pages for the PostgreSQL SQL statements can be found in the postgresql package. %package contrib Summary: Contributed Extensions and Additions to PostgreSQL Group: Productivity/Databases/Tools Requires: postgresql-server = %pg_minor_version %description contrib PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. The postgresql-contrib package includes extensions and additions that are distributed along with the PostgreSQL sources, but are not (yet) officially part of the PostgreSQL core. Documentation for the modules contained in this package can be found in /usr/share/doc/packages/postgresql/contrib. %description server PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, sub-queries, triggers, and user-defined types and functions. This package includes the programs needed to create and run a PostgreSQL server, which will in turn allow you to create and maintain PostgreSQL databases. %package -n %_name-devel Summary: PostgreSQL development header files and libraries Group: Productivity/Databases/Tools %if %libs_package Requires: postgresql-libs %else Requires: %libecpg Requires: %libpq %endif %description -n %_name-devel PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the header files and libraries needed to compile C applications which will directly interact with a PostgreSQL database management server and the ECPG Embedded C Postgres preprocessor. You need to install this package if you want to develop applications in C which will interact with a PostgreSQL server. %package plperl Summary: The PL/Tcl, PL/Perl, and PL/Python procedural languages for PostgreSQL Group: Productivity/Databases/Servers Requires: perl = %perl_version Obsoletes: postgresql-pl Provides: postgresql-pl:%_libdir/postgresql/plperl.so Requires: postgresql-server = %pg_minor_version %description plperl PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the PL/Perl procedural language for PostgreSQL. With this module one can use Perl to write stored procedures, functions, and triggers. %package plpython Summary: The PL/Python Procedural Languages for PostgreSQL Group: Productivity/Databases/Servers Obsoletes: postgresql-pl Provides: postgresql-pl:%_libdir/postgresql/plpython.so Requires: postgresql-server = %pg_minor_version Requires: python %description plpython PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the PL/Python procedural language for PostgreSQL. With this module one can use Python to write stored procedures, functions, and triggers. %package pltcl Summary: PL/Tcl Procedural Language for PostgreSQL Group: Productivity/Databases/Tools Obsoletes: postgresql-pl Provides: postgresql-pl:%_libdir/postgresql/pltcl.so Requires: postgresql-server = %pg_minor_version Requires: tcl %description pltcl PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, and user-defined types and functions. This package contains the PL/Tcl procedural language for PostgreSQL. With thie module one can use Tcl to write stored procedures, functions, and triggers. %prep %setup -q -n %_name-%version # Keep the timestamp of configure, because patching it would otherwise # confuse PostgreSQL's build system touch -r configure tmp %patch1 %patch2 # apply the following patch only on SLE10 %if 0%{?suse_version} == 1010 %patch3 -p1 %endif %patch4 touch -r tmp configure rm tmp %build export CFLAGS="%optflags $SP" # uncomment the following line to enable the stack protector # CFLAGS="$CFLAGS -fstack-protector" %configure \ --includedir=%_includedir/pgsql \ --datadir=%_datadir/postgresql \ --docdir=%_docdir \ --disable-rpath \ --enable-nls \ --enable-thread-safety \ --enable-integer-datetimes \ --with-python \ --with-perl \ --with-tcl \ --with-tclconfig=%_libdir \ --with-pam \ --with-ossp-uuid \ --with-openssl \ --with-ldap \ %if 0%{?suse_version} > 910 --with-gssapi \ --with-libxml \ --with-libxslt \ --with-krb5 \ %endif --with-system-tzdata=/usr/share/zoneinfo make %{?_smp_mflags} world %ifnarch %arm %if 0%{?suse_version} > 910 %check # # Run the regression tests. # make check || { for f in src/test/regress/log/* regression.diffs; do if test -f $f; then cat $f fi done exit 1 } %endif %endif %install make DESTDIR=%buildroot install install-docs SUBINSTALL=uninstall %if !%buildall rm -f %buildroot%_mandir/*/ecpg* rm -f %buildroot%_mandir/*/pg_config* %endif if test -n "$SUBINSTALL"; then # Install them for postgresql-libs and uninstall them for postgresql make -C src DESTDIR=%buildroot $SUBINSTALL-local for dir in \ config \ src/bin/pg_config \ src/interfaces \ src/include \ src/makefiles \ src/port \ src/test/regress do make -C $dir DESTDIR=%buildroot $SUBINSTALL done fi # Don't ship static libraries, libpgport.a is needed, though. rm -f $(ls %buildroot/%_libdir/*.a | grep -F -v libpgport.a) # # Install and collect the contrib stuff # touch flag; sleep 1 # otherwise we have installed files that are not newer than flag make DESTDIR=%buildroot -C contrib install find %buildroot -type f -cnewer flag -printf "/%%P\n" | grep -v %_docdir > files.contrib rm flag for f in /etc/init.d /var/adm/fillup-templates /usr/sbin \ /etc/sysconfig/SuSEfirewall2.d/services do install -d %buildroot/$f done install -m 755 %{SOURCE9} %buildroot/etc/init.d/postgresql install -m 644 %{SOURCE8} %buildroot/var/adm/fillup-templates/sysconfig.postgresql %if 0%{?suse_version} > 1020 install -m 644 %SOURCE16 %buildroot/etc/sysconfig/SuSEfirewall2.d/services/postgresql %endif ln -s ../../etc/init.d/postgresql %buildroot/usr/sbin/rcpostgresql install -d -m 750 %buildroot/var/lib/pgsql install -d -m 700 %buildroot/var/lib/pgsql/data sed 's,@LIBDIR@,%_libdir,g' %{SOURCE15} > \ %buildroot/var/lib/pgsql/.bash_profile # Backup directory for old version binaries install -d %buildroot%_libdir/postgresql/backup cp doc/KNOWN_BUGS doc/MISSING_FEATURES COPYRIGHT \ README HISTORY doc/bug.template %buildroot%_docdir/postgresql cp -a %SOURCE2 %buildroot%_docdir/postgresql/README.SuSE.de cp -a %SOURCE3 %buildroot%_docdir/postgresql/README.SuSE.en for appname in pg_dump pgscripts psql;do %find_lang $appname-%{pg_minor_version} %{name}.lang done %if %buildall %find_lang libpq5-%{pg_minor_version} %libpq.lang %find_lang ecpglib6-%{pg_minor_version} %libecpg.lang cat %libpq.lang %libecpg.lang > postgresql-libs.lang %find_lang ecpg-%{pg_minor_version} %_name-devel.lang %find_lang pg_config-%{pg_minor_version} %_name-devel.lang %endif for serverapp in initdb postgres pg_controldata pg_ctl pg_resetxlog plpgsql pg_basebackup;do %find_lang $serverapp-%{pg_minor_version} %{name}-server.lang done for pl in plperl plpython pltcl; do %find_lang $pl-%{pg_minor_version} $pl.lang done %fdupes %buildroot %post server %fillup_and_insserv %postun server %restart_on_update postgresql %insserv_cleanup exit 0 %preun server %stop_on_removal postgresql exit 0 %pre server groupadd -g 26 -o -r postgres >/dev/null 2>/dev/null || : useradd -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \ -c "PostgreSQL Server" -u 26 postgres 2>/dev/null || : %if %libs_package %post -n postgresql-libs -p /sbin/ldconfig %postun -n postgresql-libs -p /sbin/ldconfig %else %post -n %libpq -p /sbin/ldconfig %postun -n %libpq -p /sbin/ldconfig %post -n %libecpg -p /sbin/ldconfig %postun -n %libecpg -p /sbin/ldconfig %endif %clean rm -rf %buildroot rm -f %my_provides %files -f %{name}.lang %defattr(-,root,root) %doc %_mandir/man7/* %docdir %_docdir/postgresql %dir %_docdir/postgresql %_docdir/postgresql/[[:upper:]]* %_docdir/postgresql/bug.template # command line tools %_bindir/createdb %doc %_mandir/man1/createdb.1* %_bindir/clusterdb %doc %_mandir/man1/clusterdb.1* %_bindir/createlang %doc %_mandir/man1/createlang.1* %_bindir/createuser %doc %_mandir/man1/createuser.1* %_bindir/dropdb %doc %_mandir/man1/dropdb.1* %_bindir/droplang %doc %_mandir/man1/droplang.1* %_bindir/dropuser %doc %_mandir/man1/dropuser.1* %_bindir/pg_dump %doc %_mandir/man1/pg_dump.1* %_bindir/pg_dumpall %doc %_mandir/man1/pg_dumpall.1* %_bindir/pg_restore %doc %_mandir/man1/pg_restore.1* %_bindir/psql %doc %_mandir/man1/psql.1* %_bindir/vacuumdb %doc %_mandir/man1/vacuumdb.1* %_bindir/reindexdb %doc %_mandir/man1/reindexdb.1.* %_bindir/pg_basebackup %doc %_mandir/man1/pg_basebackup.1.* %files docs %defattr(-,root,root) %doc %_mandir/man3/* %docdir %_docdir/postgresql %dir %_docdir/postgresql %_docdir/postgresql/html %files contrib -f files.contrib %defattr(-,root,root) %docdir %_docdir/postgresql %dir %_docdir/postgresql %_docdir/postgresql/extension %dir %_datadir/postgresql %files server -f %{name}-server.lang %defattr(-,root,root) %dir %extensiondir %config /etc/init.d/postgresql %config /var/adm/fillup-templates/sysconfig.postgresql %if 0%{?suse_version} > 1020 %config /etc/sysconfig/SuSEfirewall2.d/services/postgresql %endif %_sbindir/rcpostgresql %dir %_libdir/postgresql %_libdir/postgresql/backup %_libdir/postgresql/plpgsql.so %_libdir/postgresql/dict_snowball.so %_datadir/postgresql/tsearch_data %exclude %_datadir/postgresql/tsearch_data/unaccent.rules %exclude %_datadir/postgresql/tsearch_data/xsyn_sample.rules %_bindir/initdb %doc %_mandir/man1/initdb.1* %_bindir/pg_ctl %doc %_mandir/man1/pg_ctl.1* %_bindir/pg_controldata %doc %_mandir/man1/pg_controldata.1* %_bindir/pg_resetxlog %doc %_mandir/man1/pg_resetxlog.1* %_bindir/postgres %doc %_mandir/man1/postgres.1* %_bindir/postmaster %doc %_mandir/man1/postmaster.1* %dir %_datadir/postgresql %_datadir/postgresql/timezone* %_datadir/postgresql/*.* %exclude %_datadir/postgresql/*.pltcl %_libdir/postgresql/*_and_*.so %_libdir/postgresql/euc2004_sjis2004.so %_libdir/postgresql/libpqwalreceiver.so %extensiondir/plpgsql* %attr(750,postgres,postgres) %dir /var/lib/pgsql %attr(700,postgres,postgres) %dir /var/lib/pgsql/data %attr(640,postgres,postgres) %config(noreplace) /var/lib/pgsql/.bash_profile %files pltcl -f pltcl.lang %defattr(-,root,root) %extensiondir/pltcl* %_libdir/postgresql/pltcl.so %_datadir/postgresql/*.pltcl %_bindir/pltcl* %files plperl -f plperl.lang %defattr(-,root,root) %extensiondir/plperl* %_libdir/postgresql/plperl.so %files plpython -f plpython.lang %defattr(-,root,root) %extensiondir/plpython* %_libdir/postgresql/plpython*.so %if %buildall %if %libs_package %files -n postgresql-libs -f postgresql-libs.lang %else %files -n %libpq -f %libpq.lang %endif %defattr(-,root,root) %_libdir/libpq.so.* %if !%libs_package %files -n %libecpg -f %libecpg.lang %defattr(-,root,root) %endif %_libdir/libecpg*.so.* %_libdir/libpgtypes.so.* %files -n %_name-devel -f %_name-devel.lang %defattr(-,root,root) %doc %_mandir/man1/ecpg.1* %_bindir/pg_config %doc %_mandir/man1/pg_config.1* %_bindir/ecpg %_libdir/libpgport.a %_libdir/lib*.so %dir %_libdir/postgresql %_libdir/postgresql/pgxs %_includedir/pgsql %dir %_datadir/postgresql %_datadir/postgresql/pg_service.conf.sample %endif %changelog ++++++ baselibs.conf ++++++ libpq5 postgresql-devel requires -postgresql-<targettype> requires "libpq5-<targettype> = <version>" ++++++ postgresql-README.SuSE.de ++++++ Die Konfigurationsvariablen für den PostgreSQL Server sind jetzt in der Datei /etc/sysconfig/postgresql zu finden. Viele der Kommandozeilenparameter können inzwischen auch in /var/lib/pgsql/data/postgresql.conf gesetzt werden. Vor einem Update der PostgreSQL Pakete, bei dem sich die Version zumindest an der zweiten Stelle ändert (z.B. 7.3 auf 7.4) müssen Ihre PostgreSQL Datenbanken mit dem Programm pg_dumpall gesichert werden. Der übliche Aufruf hierfür sieht so aus: pg_dumpall > SAVE Die Sicherung sollte als Benutzer "postgres" durchgeführt werden. Wenn die Sicherung erfolgreich war, kann der PostgreSQL-Server angehalten werden (als root: "rcpostgresql stop"). Eventuell müssen zusätzlich noch einige Konfigurationsdateien aus /var/lib/pgsql/data gesichert werden, z.B. pg_hba.conf und postgresql.conf . Achtung: seit Version 8.4 muss in pg_hba.conf "ident sameuser" durch "ident" ersetzt werden. Danach können Sie die bisherigen Datenbankdateien löschen rm -r /var/lib/pgsql/data/* oder falls der Platz ausreicht verschieben, mv /var/lib/pgsql/data /var/lib/pgsql/data.old damit unter /var/lib/pgsql/data die neue Datenbankstruktur angelegt werden kann. Diese wird beim ersten Start des neuen Datenbankservers (als root:"rcpostgresql start") automatisch erstellt. Das Zurückspielen der gesicherten Datenbankinhalte und Konfigurationsdateien muß wieder als Benutzer postgres durchgeführt werden: psql template1 -f SAVE Wenn Sie nach eingehenden Tests sicher sind, daß nach der Migration noch alles vorhanden ist und funktioniert, können Sie die Sicherungsdatei und gegebenenfalls die bei Seite geschobenen alten Datenbankdateien löschen. ++++++ postgresql-README.SuSE.en ++++++ The configuration variables for the PostgreSQL server are now stored in the /etc/sysconfig/postgresql file. Now, you can set many commando line parameters in /var/lib/pgsql/data/postgresql.conf. Before updating PostgreSQL packages whose version numbers are to increase by at least the second decimal place or higher (for example, 6.4.x to 7.0.x or 7.1.x to 7.2.x), use the pg_dumpall program to back up your PostgreSQL databases. A typical command for doing this is: pg_dumpall > SAVE Backups should be performed as user "postgres". Once the backup is completed successfully, shut down the PostgreSQL server (as root: "rcpostgresql stop"). Further configuration files in /var/lib/pgsql/data, including pg_hba.conf and postgresql.conf, may need to be backed up as well. Note: since version 8.4, "ident sameuser" needs to be replaced with "ident" in pg_hba.conf. Afterwards, delete the previous database files rm -r /var/lib/pgsql/data/* or, if you have enough space, move it to mv /var/lib/pgsql/data /var/lib/pgsql/data.old so that the new database structure can be created under /var/lib/pgsql/data when you start the new database server for the first time (as root:"rcpostgresql start"). The saved contents of the database and the configuration files will then have to be played back as user postgres: psql template1 -f SAVE If, following exhaustive testing, you are certain that everything is still available and functioning properly after the migration, delete the backup file and the old database files. ++++++ 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-firewall ++++++ ## Name: PostgreSQL Server ## Description: Opens TCP port 5432 to allow remote connections to the PostgreSQL server. TCP="5432" ++++++ postgresql-init ++++++ #!/bin/sh # Copyright (c) 1995-2004 SUSE Linux AG, Nuernberg, Germany. # All rights reserved. # # Author: Kurt Garloff # Please send feedback to http://www.suse.de/feedback/ # # /etc/init.d/postgresql # and its symbolic link # /(usr/)sbin/rcpostgresql # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. # # System startup script for PostgreSQL # # LSB compatible service control script; see http://www.linuxbase.org/spec/ # ### BEGIN INIT INFO # Provides: postgresql # Required-Start: $network $remote_fs # Required-Stop: $network $remote_fs # Default-Start: 3 5 # Default-Stop: # Description: Start the PostgreSQL master daemon ### END INIT INFO # Source SuSE config PG_SYSCONFIG=/etc/sysconfig/postgresql test -f $PG_SYSCONFIG && . $PG_SYSCONFIG # Shell functions sourced from /etc/rc.status: # rc_check check and set local and overall rc status # rc_status check and set local and overall rc status # rc_status -v ditto but be verbose in local rc status # rc_status -v -r ditto and clear the local rc status # rc_failed set local and overall rc status to failed # rc_reset clear local rc status (overall remains) # rc_exit exit appropriate to overall rc status . /etc/rc.status eval DATADIR=${POSTGRES_DATADIR:-~postgres/data} OPTIONS=${POSTGRES_OPTIONS} H=/usr/bin/postmaster test -x $H || exit 5 PIDFILE=$DATADIR/postmaster.pid # The echo return value for success (defined in /etc/rc.config). rc_reset # Return values acc. to LSB for all commands but status: # 0 - success # 1 - generic or unspecified error # 2 - invalid or excess argument(s) # 3 - unimplemented feature (e.g. "reload") # 4 - insufficient privilege # 5 - program is not installed # 6 - program is not configured # 7 - program is not running # # Note that starting an already running service, stopping # or restarting a not-running service as well as the restart # with force-reload (in case signalling is not supported) are # considered a success. pg_ctl () { CMD="/usr/bin/pg_ctl $@" su - postgres -c "LD_LIBRARY_PATH=$LD_LIBRARY_PATH $CMD" } case "$1" in start) if [ ! -f $DATADIR/PG_VERSION ]; then echo -n "Initializing the PostgreSQL database at location ${DATADIR}" LANG_SYSCONFIG=/etc/sysconfig/language test -f "$LANG_SYSCONFIG" && . $LANG_SYSCONFIG LANG=${POSTGRES_LANG:-$RC_LANG} INITDB=/usr/bin/initdb install -d -o postgres -g postgres -m 700 ${DATADIR} && su - postgres -c \ "$INITDB --locale=$LANG --auth=\"ident\" $DATADIR &> initlog" || rc_failed rc_status -v rc_status || { echo "You can find a log of the initialisation in ~postgres/initlog ." rc_exit } fi echo -n "Starting PostgreSQL" ## remove old socket and pidfile, if they exist ## and no daemon is running. checkproc -p $PIDFILE $H || { rm -f /tmp/.s.PGSQL.* $PIDFILE } pg_ctl start -s -w -p $H -D $DATADIR -o "\"$OPTIONS\"" rc_status -v ;; stop) echo -n "Shutting down PostgreSQL" if pg_ctl status -s -D $DATADIR >/dev/null then pg_ctl stop -s -D $DATADIR -m fast else rc_failed 0 fi rc_status -v ;; try-restart) ## Stop the service and if this succeeds (i.e. the ## service was running before), start it again. ## Note: try-restart is not (yet) part of LSB (as of 0.7.5) $0 status && $0 restart ;; restart) ## Stop the service and regardless of whether it was ## running or not, start it again. $0 stop $0 start rc_status ;; force-reload | reload) echo -n "Reloading configuration for PostgreSQL" pg_ctl reload -s -D $DATADIR rc_status -v ;; status) echo -n "Checking for PostgreSQL: " ## Check status with checkproc(8), if process is running ## checkproc will return with exit status 0. # Status has a slightly different for the status command: # 0 - service running # 1 - service dead, but /var/run/ pid file exists # 2 - service dead, but /var/lock/ lock file exists # 3 - service not running # NOTE: checkproc returns LSB compliant status values. pg_ctl status -s -D $DATADIR >/dev/null if ! pg_ctl status -s -D $DATADIR >/dev/null then if test -f $DATADIR/postmaster.pid; then rc_failed 1 else rc_failed 3 fi fi rc_status -v ;; probe) rc_failed 3 rc_status -v ;; *) echo "Usage: $0 {start|stop|status|try-restart|restart|force-reload|reload|probe}" exit 1 ;; esac # Inform the caller not only verbosely and set an exit status. rc_exit ++++++ postgresql-mkspecfiles ++++++ #!/bin/bash sed '/IF_LIBS/,/FI_LIBS/d /IF_POSTGRES/d /FI_POSTGRES/d ' postgresql.spec.in > postgresql.spec sed '/^Name: /s/$/-libs/ /IF_POSTGRES/,/FI_POSTGRES/d /IF_LIBS/d /FI_LIBS/d ' postgresql.spec.in > postgresql-libs.spec ++++++ 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 @@ -7157,9 +7157,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 ++++++ postgresql-sysconfig ++++++ ## Path: Applications/PostgreSQL ## Description: The PostgreSQL Database System ## Type: string() ## Default: "~postgres/data" ## ServiceRestart: postgresql # # In which directory should the PostgreSQL database reside? # POSTGRES_DATADIR="~postgres/data" ## Path: Applications/PostgreSQL ## Description: The PostgreSQL Database System ## Type: string() ## Default: "" ## ServiceRestart: postgresql # # The options that are given to the PostgreSQL master daemon on startup. # See the manual pages for postmaster and postgres for valid options. # # Don't put "-D datadir" here since it is set by the startup script # based on the variable POSTGRES_DATADIR above. # POSTGRES_OPTIONS="" ## Path: Applications/PostgreSQL ## Description: The PostgreSQL Database System ## Type: string() ## Default: "C" ## ServiceRestart: "" # # Specifies the locale under which the PostgreSQL database location # should be initialized and run. If needed, it has to be changed # before PostgreSQL is started for the first time. To change the # locale of an existsing PostgreSQL database location, it must be # dumped, removed and initialized from scratch using the new locale. # # If unset or empty $RC_LANG from /etc/sysconfig/language is used. # POSTGRES_LANG="" ++++++ postgresql.spec.in ++++++ ++++ 611 lines (skipped) -- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
