Hi, I have encountered a really strange problem with PostgreSQL 7.0 on
Solaris 2.6/Sparc. The problem is that createdb command or create
database SQL always fails. Inspecting the output of truss shows that
system() call in createdb() (commands/dbcomand.c) fails because
waitid() system call in system() returns error no. 10 (ECHILD).

This problem was not in 6.5.3, so I checked the source of it. The
reason why 6.5.3's createdb worked was that it just ignored the return
code of system()!

It seems that we need to ignore an error from system() if the error is
ECHILD on Solaris.

Any idea?

BTW, I have compiled PostgreSQL with egcs 2.95 with/without
optimization.
--
Tatsuo Ishii

Wed, 24 May 2000 18:28:25 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Solaris 2.6 problems
Tatsuo Ishii writes:

> It seems that we need to ignore an error from system() if the error is
> ECHILD on Solaris.

Seems reasonable. I vaguely recall something about child process
bogosities on Solaris/SunOS, perhaps that is related to this.

-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Thu, 25 May 2000 00:00:27 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: Solaris 2.6 problems
> > It seems that we need to ignore an error from system() if the error is
> > ECHILD on Solaris.
> 
> Seems reasonable. I vaguely recall something about child process
> bogosities on Solaris/SunOS, perhaps that is related to this.

Ok, fix committed.
--
Tatsuo Ishii

Thu, 25 May 2000 15:55:38 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: Solaris 2.6 problems