Thread: Porting/platforms/buildfarm open issues

Porting/platforms/buildfarm open issues

From
Peter Eisentraut
Date:
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/


Re: Porting/platforms/buildfarm open issues

From
Shridhar Daithankar
Date:
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


Re: Porting/platforms/buildfarm open issues

From
Honda Shigehiro
Date:
Hello.

From: Peter Eisentraut <peter_e@gmx.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.ofe-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.oencnames.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
environmentvriable 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/sharemkdir: 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
existmkdir: cannot create abc.abc: File existsbash-2.05b$ mkdir -p abc5 abc5      --- failuer. both of 'abc5' don't
existmkdir:cannot create abc5.abc5: File exists
 
)

regards, 
--  Shigehiro Honda


Re: Porting/platforms/buildfarm open issues

From
Tom Lane
Date:
Shridhar Daithankar <ghodechhap@ghodechhap.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


Re: Porting/platforms/buildfarm open issues

From
Andrew Dunstan
Date:

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


Re: Porting/platforms/buildfarm open issues

From
Tom Lane
Date:
Honda Shigehiro <fwif0083@mb.infoweb.ne.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


Re: Porting/platforms/buildfarm open issues

From
Peter Eisentraut
Date:
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/

Re: Porting/platforms/buildfarm open issues

From
Honda Shigehiro
Date:
Hello,

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

regards, 
--  Shigehiro Honda

From: Peter Eisentraut <peter_e@gmx.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/


Re: Porting/platforms/buildfarm open issues

From
Peter Eisentraut
Date:
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/


Re: Porting/platforms/buildfarm open issues

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.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


Re: Porting/platforms/buildfarm open issues

From
Peter Eisentraut
Date:
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/

Compiere ERP and SQL quirks

From
"Marek Mosiewicz"
Date:
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



Re: Porting/platforms/buildfarm open issues

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.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