Re: Porting/platforms/buildfarm open issues

First, we still do not have any test with 8.0 on the following platforms:

HP-UX
IRIX
Tru64 UNIX
SCO OpenServer

Second, we have regressions (vs. 7.4) on the following platforms:

Linux Alpha (buildfarm hare)
Linux ARM (see http://archives.postgresql.org/pgsql-hackers/2005-01/msg00094.php)

Other open targets can be found here:

http://developer.postgresql.org/docs/postgres/supported-platforms.html

but those were the most important ones.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

On Thursday 06 Jan 2005 3:52 pm, Peter Eisentraut wrote:
> First, we still do not have any test with 8.0 on the following platforms:
>
> HP-UX

All the 96 tests are passed on RC3. I can rerun the tests with additional
configure flags if required..But I can not install anything new on HP-UX
machine.

$ ./configure --without-readline --without-zlib;gmake;gmake check
$ uname -a
HP-UX machine B.11.00 A 9000/785 2005950738 two-user license

FWIW, I also ran on my Linux machine. It passes there as well..

$ ./configure;make;make check
$ uname -a
Linux machine 2.6.7 #1 Wed Jun 16 16:23:03 PDT 2004 i686 unknown unknown
GNU/Linux
$ cat /etc/slackware-version
Slackware 10.0.0

Shridhar

Hello.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: [HACKERS] Porting/platforms/buildfarm open issues
Date: Thu, 6 Jan 2005 11:22:56 +0100

> Tru64 UNIX
I tried RC3 on Tru64 box with cc(Compaq C V6.1-011). There are some errors
to build and install. All tests (make installcheck) are passed.

bash-2.05b$ uname -a
OSF1 kiss.my.domain V5.0 910 alpha
bash-2.05b$ make installcheck
...
======================
All 96 tests passed.
======================

Error Reports:
(Sorry for my poor English.)
1) configure?
I got below error when simply configure and make:
/usr/bin/ld -shared -expect_unresolved '*' fe-auth.o fe-connect.o fe-exec.o fe-misc.o fe-print.o fe-lobj.o fe-protocol2.o fe-protocol3.o pqexpbuffer.o pqsignal.o fe-secure.o md5.o ip.o wchar.o encnames.o noblock.o pgstrcasecmp.o thread.o getaddrinfo.o -L../../../src/port -lresolv -Wl,-rpath -Wl,/usr/local/pgsql/lib -o libpq.so.3.2
/usr/bin/ld:
Invalid flag usage: Wl,-rpath, -Wx,-option must appear after -_SYSTYPE_SVR4
/usr/bin/ld: Usage: /usr/bin/ld [options] file [...]
make[3]: *** [libpq.so.3.2] Error 1

In Makefile.osf, rpath are defined as 'rpath = -Wl,-rpath -Wl,$(rpathdir)'. But,
Makefile.global were set LD to /usr/bin/ld by configure script:
bash-2.05b$ grep "LD " Makefile.global
LD = /usr/bin/ld

So, I need a patch to build:
bash-2.05b$ diff Makefile.osf.DIST Makefile.osf
4c4
< rpath = -Wl,-rpath -Wl,$(rpathdir)
---
> rpath = -rpath $(rpathdir)

(Because LDREL=-r is fixed in Makefile.global.in and cc command can not pass "-r"
flag to linker, I did not set LD environment vriable to "/usr/bin/cc".)

I believe that it will be no problem if I had used gcc.

2) mkdir?
Due to odd behavior of 'mkdir -p' command, I got below error when 'make install':
mkdir -p -- /usr/local/pgsql/bin /usr/local/pgsql/share
mkdir: cannot create /usr/local/pgsql/share.
/usr/local/pgsql/share: File exists
make[2]: *** [installdirs] Error 2

So, i needed patches below:
bash-2.05b$ diff include/Makefile.DIST include/Makefile
21c21
< nodes optimizer parser port regex rewrite storage tcop utils \
---
> nodes optimizer parser regex rewrite storage tcop utils \
(port directory were specified twice.)

bash-2.05b$ diff backend/Makefile.DIST backend/Makefile
184c184
< $(mkinstalldirs) $(DESTDIR)$(bindir) $(DESTDIR)$(datadir)
---
> $(mkinstalldirs) $(DESTDIR)$(datadir) $(DESTDIR)$(bindir)

(The mkdir command(of OS standard) fail if there are no-existing directory in middle
of paths of the argument. For example,
bash-2.05b$ mkdir abc --- success.
bash-2.05b$ mkdir -p abc abc2 --- success. the last 'abc2' don't exist.
bash-2.05b$ mkdir -p abc3 abc abc2 --- failure. the first 'abc3' don't exist
mkdir: cannot create abc.
abc: File exists
bash-2.05b$ mkdir -p abc5 abc5 --- failuer. both of 'abc5' don't exist
mkdir: cannot create abc5.
abc5: File exists
)

regards,
--
Shigehiro Honda

Shridhar Daithankar <ghodechhap(at)ghodechhap(dot)net> writes:
> On Thursday 06 Jan 2005 3:52 pm, Peter Eisentraut wrote:
>> First, we still do not have any test with 8.0 on the following platforms:
>>
>> HP-UX

> All the 96 tests are passed on RC3. I can rerun the tests with additional
> configure flags if required..But I can not install anything new on HP-UX
> machine.

> $ ./configure --without-readline --without-zlib;gmake;gmake check
> $ uname -a
> HP-UX machine B.11.00 A 9000/785 2005950738 two-user license

I can assure you it works on 10.20 as well ;-)

$ uname -a
HP-UX sss2 B.10.20 C 9000/780 2004473515 32-user license

I have done port testing using both gcc and vendor's cc on HPUX 11.11
(PA-RISC) and 11.23 (Itanium) at HP's testdrive farm. The last time was
a month or two back, so it's possible that something broke since then,
but it seems highly unlikely. It's also been a month or two since I
last tried vendor's cc on 10.20, but I doubt that broke either.

regards, tom lane

Peter Eisentraut wrote:

>
>Second, we have regressions (vs. 7.4) on the following platforms:
>
>Linux Alpha (buildfarm hare)
>
>
>

This was apparently an old Alpha chip, and Jim was going to try on a
more modern machine not known to have FP problems. So take this result
with many grains of salt.

cheers

andrew

Honda Shigehiro <fwif0083(at)mb(dot)infoweb(dot)ne(dot)jp> writes:
> So, I need a patch to build:
> bash-2.05b$ diff Makefile.osf.DIST Makefile.osf
> 4c4
> < rpath = -Wl,-rpath -Wl,$(rpathdir)
> ---
> > rpath = -rpath $(rpathdir)

OK; this simply reverts a cosmetic change I made awhile ago. Evidently
that wasn't a good idea on all platforms after all :-(

> Due to odd behavior of 'mkdir -p' command, I got below error when 'make install':
> mkdir -p -- /usr/local/pgsql/bin /usr/local/pgsql/share
> mkdir: cannot create /usr/local/pgsql/share.

I think you ought to report this as a bug in the local version of mkdir.

> bash-2.05b$ diff backend/Makefile.DIST backend/Makefile
> 184c184
> < $(mkinstalldirs) $(DESTDIR)$(bindir) $(DESTDIR)$(datadir)
> ---
> > $(mkinstalldirs) $(DESTDIR)$(datadir) $(DESTDIR)$(bindir)

I'm not following the point of this change?

regards, tom lane

Am Donnerstag, 6. Januar 2005 16:30 schrieb Honda Shigehiro:
> 2) mkdir?
> Due to odd behavior of 'mkdir -p' command, I got below error when 'make
> install': mkdir -p -- /usr/local/pgsql/bin /usr/local/pgsql/share
> mkdir: cannot create /usr/local/pgsql/share.
> /usr/local/pgsql/share: File exists
> make[2]: *** [installdirs] Error 2

Would you place the attached version of mkinstalldirs in the config/ directory
in the PostgreSQL source tree and try installing again? (Of course, you
might need to delete /usr/local/pgsql first to have the same preconditions.)
Please report whether it works better.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Hello,

This installdirs are worked well. 'make install' succeeds without
modifying Makefiles.
Thank you.

regards,
--
Shigehiro Honda

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: [HACKERS] Porting/platforms/buildfarm open issues
Date: Fri, 7 Jan 2005 10:53:56 +0100

> Am Donnerstag, 6. Januar 2005 16:30 schrieb Honda Shigehiro:
> > 2) mkdir?
> > Due to odd behavior of 'mkdir -p' command, I got below error when 'make
> > install': mkdir -p -- /usr/local/pgsql/bin /usr/local/pgsql/share
> > mkdir: cannot create /usr/local/pgsql/share.
> > /usr/local/pgsql/share: File exists
> > make[2]: *** [installdirs] Error 2
>
> Would you place the attached version of mkinstalldirs in the config/ directory
> in the PostgreSQL source tree and try installing again? (Of course, you
> might need to delete /usr/local/pgsql first to have the same preconditions.)
> Please report whether it works better.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/

Am Freitag, 7. Januar 2005 13:10 schrieb Honda Shigehiro:
> This installdirs are worked well. 'make install' succeeds without
> modifying Makefiles.

Does anyone object to installing the new mkinstalldirs? I took the latest
version from the automake CVS. The important change was apparently to use
mkdir -p only with GNU mkdir.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Does anyone object to installing the new mkinstalldirs? I took the latest
> version from the automake CVS. The important change was apparently to use
> mkdir -p only with GNU mkdir.

Could you post a diff against what we have now?

regards, tom lane

Am Freitag, 7. Januar 2005 17:20 schrieb Tom Lane:
> > Does anyone object to installing the new mkinstalldirs? I took the
> > latest version from the automake CVS. The important change was
> > apparently to use mkdir -p only with GNU mkdir.
>
> Could you post a diff against what we have now?

Attached.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

Hello

We made Compiere (Open source ERP system) to Firebird (Fyracle)
This is special version of Firebird with added Oracle compatibility (Oracle
PL/SQL).
It made porting much easier, but our experience show that it
would be now also not very difficult with other databases like PostgreSQL.

Compiere contained lot of PL/SQL which size is now largely reduced.
Main problem is some SQL constructions which are not supported.
Particulary something like this is very important:
UPDATE sometable set (col1,col2) = (select col_a,col_b from another_table
where ....)
This construction seems to be quite useful in another cases.

Would be it diffcult and possible to add such syntax to PostgreSQL ?

Marek Mosiewicz
http://www.jotel.com.pl

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Am Freitag, 7. Januar 2005 17:20 schrieb Tom Lane:
>> Could you post a diff against what we have now?

> Attached.

Looks ok to me.

regards, tom lane