This patch should be sent to SuSE, not PostgreSQL. ---------------------------------------------------------------------------
Weberhofer GmbH wrote: > Dear Steve, > > I have had the same problem related SuSE 8.2. A thing that additionally can > be wrong is the LC_CTYPE setting in the environment. Running a SuSE system > this can be set in /etc/sysconfig/language. I am using RC_LANG="de_DE.UTF-8", > but other valid values should be fine, too. > > For SuSE 8.2 I am currently using the source rpm files from > ftp://ftp.suse.com/pub/projects/postgresql/postgresql-8.1.1/postgresql-8.1.1-1.src.rpm > and the appended patches for the spec files to build the rpms. > > Best regards, > Johannes Weberhofer > > > > --- postgres.811-suse/postgresql.spec 2005-12-14 15:31:48.000000000 +0100 > +++ postgres.811/postgresql.spec 2005-12-15 08:48:18.000000000 +0100 > @@ -10,7 +10,7 @@ > > # norootforbuild > # neededforbuild kerberos-devel-packages openssl openssl-devel pam-devel > readline readline-devel > -# usedforbuild aaa_base acl attr bash bind-utils bison bzip2 coreutils > cpio cpp cvs cyrus-sasl db devs diffutils e2fsprogs file filesystem fillup > findutils flex gawk gdbm-devel glibc glibc-devel glibc-locale gpm grep groff > gzip info insserv kbd less libacl libattr libgcc libstdc++ libxcrypt m4 make > man mktemp modutils ncurses ncurses-devel net-tools netcfg openldap2-client > openssl pam pam-devel pam-modules patch permissions popt ps rcs readline sed > sendmail shadow strace syslogd sysvinit tar texinfo timezone unzip util-linux > vim zlib zlib-devel autoconf automake binutils cracklib e2fsprogs-devel gcc > gdbm gettext heimdal heimdal-devel heimdal-lib libtool openssl-devel perl > readline-devel rpm > +# usedforbuild aaa_base acl attr bash bind9-utils bison bzip2 coreutils > cpio cpp cracklib cvs cyrus-sasl2 db devs diffutils e2fsprogs file filesystem > fillup findutils flex gawk gdbm-devel glibc glibc-devel glibc-locale gpm grep > groff gzip info insserv less libacl libattr libgcc libstdc++ libxcrypt m4 > make man mktemp modutils ncurses ncurses-devel net-tools netcfg > openldap2-client openssl pam pam-modules patch permissions popt ps shadow rcs > readline sed strace syslogd sysvinit tar tcpd texinfo timezone unzip > util-linux vim zlib zlib-devel autoconf automake binutils gcc gdbm gettext > heimdal-devel heimdal-lib libtool openssl-devel pam-devel perl readline-devel > rpm > > Name: postgresql > Summary: PostgreSQL - the Database > @@ -78,7 +78,7 @@ > %package libs > Summary: The shared libraries required for any PostgreSQL clients > Group: Productivity/Databases/Clients > -Provides: pg_ifa pg_lib postgresql-lib postgresql-libs = 8.0.1 > +Provides: pg_ifa pg_lib postgresql-lib postgresql-libs = %{version} > Obsoletes: pg_ifa pg_lib postgresql-lib > PreReq: sh-utils fileutils > > @@ -241,7 +241,16 @@ > # Run the regression tests. > # > %ifnarch %arm > -make check || { > +%if %suse_version < 900 > +if test -z "`grep '^testuser:' /etc/passwd`" ; then > + useradd testuser > +fi > +chown -R testuser. src/test/ > +SUCMD="su testuser -c" > +%else > +SUCMD="" > +%endif > +$SUCMD "make check" || { > cat regression.diffs > exit 1 > } > @@ -280,7 +289,10 @@ > gcc -shared -o %buildroot%_libdir/postgresql/backup/libreadline.so.4 > -lreadline > gcc -shared -o %buildroot%_libdir/postgresql/backup/libssl.so.0.9.6 -lssl > gcc -shared -o %buildroot%_libdir/postgresql/backup/libcrypto.so.0.9.6 > -lcrypto > +%if %suse_version < 1000 > # This hack is needed because the soname major version was bumped in a > patchlevel release > +gcc -shared -Wl,-soname,libpq.so.3 -o %buildroot%_libdir/libpq.so.3 > -L%buildroot%_libdir -lpq > +%endif > cp doc/FAQ doc/KNOWN_BUGS doc/MISSING_FEATURES doc/README* COPYRIGHT \ > README HISTORY doc/bug.template %buildroot%_docdir/postgresql > cp -a %SOURCE2 %buildroot%_docdir/postgresql/README.SuSE.de > @@ -462,6 +474,8 @@ > %doc %_mandir/man1/pg_config.1* > > %changelog -n postgresql > +* Thu Dec 15 2005 - [EMAIL PROTECTED] > +- fixed some incompatibilities with SuSE 8.2 and SuSE 9.0 > * Wed Dec 14 2005 - max@suse.de > - New version: 8.1.1 > * Fri Jun 17 2005 - max@suse.de > > > --- postgres.811-suse/postgresql-pl.spec 2005-12-14 15:25:17.000000000 > +0100 > +++ postgres.811/postgresql-pl.spec 2005-12-15 08:46:43.000000000 +0100 > @@ -1,5 +1,5 @@ > # > -# spec file for package postgresql-pl (Version 8.0.3) > +# spec file for package postgresql-pl (Version 8.1.1) > # > # Copyright (c) 2005 SUSE LINUX Products GmbH, Nuernberg, Germany. > # This file and all modifications and additions to the pristine > @@ -11,7 +11,7 @@ > # norootforbuild > # neededforbuild kerberos-devel-packages openssl openssl-devel pam-devel > python python-devel tcl tcl-devel > > -BuildRequires: aaa_base acl attr bash bind-utils bison bzip2 coreutils cpio > cpp cracklib cvs cyrus-sasl db devs diffutils e2fsprogs file filesystem > fillup findutils flex gawk gdbm-devel gettext-devel glibc glibc-devel > glibc-locale gpm grep groff gzip info insserv klogd less libacl libattr > libcom_err libgcc libnscd libselinux libstdc++ libxcrypt libzio m4 make man > mktemp module-init-tools ncurses ncurses-devel net-tools netcfg > openldap2-client openssl pam pam-modules patch permissions popt procinfo > procps psmisc pwdutils rcs readline sed strace sysvinit tar tcpd texinfo > timezone unzip util-linux vim zlib zlib-devel autoconf automake binutils > e2fsprogs-devel gcc gdbm gettext krb5 krb5-devel libtool openssl-devel > pam-devel perl python python-devel rpm tcl tcl-devel > +# usedforbuild aaa_base acl attr bash bind9-utils bison bzip2 coreutils > cpio cpp cracklib cvs cyrus-sasl2 db devs diffutils e2fsprogs file filesystem > fillup findutils flex gawk gdbm-devel gettext glibc glibc-devel glibc-locale > gpm grep groff gzip info insserv syslogd less libacl libattr libgcc libstdc++ > libxcrypt m4 make man mktemp modutils ncurses ncurses-devel net-tools netcfg > openldap2-client openssl pam pam-modules patch permissions popt ps shadow rcs > readline sed strace sysvinit tar tcpd texinfo timezone unzip util-linux vim > zlib zlib-devel autoconf automake binutils gcc gdbm heimdal-devel heimdal-lib > gettext libtool openssl-devel pam-devel perl python python-devel rpm tcl > tcl-devel > > Name: postgresql-pl > Summary: The PL/Tcl, PL/Perl, and PL/Python Procedural Languages for > PostgreSQL > > > > > -- > > > |--------------------------------- > | weberhofer GmbH | Johannes Weberhofer > | information technologies, Austria > | > | phone : +43 (0)1 5454421 0 | email: [EMAIL PROTECTED] > | fax : +43 (0)1 5454421 19 | web : http://weberhofer.at > | mobile: +43 (0)699 11998315 > |----------------------------------------------------------->> > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
