Sorry for the package, but the following patch need to be applied to get the new verion compiled on SCO Openserver 5.0.5 and Unixware 7.1.1
Tue, 26 Mar 2002 17:21:31 +1100
"Nicolas Bazin" <nbazin@ingenico.com.au>
build of 7.2.1 on SCO Openserver and Unixware 7.1.1

We am going to need an explaination on these changes.  Why move
the socket test?  Why change pow()?  The TCL stuff is going to
effect other platforms and probably will not be applied without a
good reason.

---------------------------------------------------------------------------

Nicolas Bazin wrote:
> Sorry for the package, but the following patch need to be applied
> to get the new verion compiled on SCO Openserver 5.0.5 and
> Unixware 7.1.1

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 26 Mar 2002 08:08:31 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: build of 7.2.1 on SCO Openserver and Unixware 7.1.1
Bruce,

The reason to move the socket library is that during configuration script
execution, the binary created core dumps if not in the order I gave. You can
check in the port list, some people have been complaining that they could
not even go any further than the configure step and that is the reason.
Here is the message you get otherwise:

checking test program... failed
configure: error:
*** Could not execute a simple test program.  This may be a problem
*** related to locating shared libraries.  Check the file 'config.log'
*** for the exact reason.

In config.log the last lines are:

configure:7516: checking test program
configure:7525: gcc -o conftest -O2



 conftest.c -lz -lPW -lgen -lld -lnsl -lsocket -ldl -lm -lreadline -ltermcap
1>&5
configure: failed program was:
#line 7521 "configure"
#include "confdefs.h"
int main() { return 0; }



pow is in the static library libm and SCO Openserver linker does not accept
to link it in a so file. The modification I provide works whithout changing
the way the code works. If there is another way to get libm linked in so
Here is the message I get:

gcc -shared -Wl,-z,text -Wl,-h,libpsqlodbc.so.0 -Wl,-Bsymbolic info.o bind.o
columninfo.o connection.o convert.o drvconn.o environ.o execute.o lobj.o
md5.o misc.o options.o pgtypes.o psqlodbc.o qresult.o results.o socket.o
parse.o statement.o tuple.o tuplelist.o dlg_specific.o odbcapi.o
pps.o  -lsocket -lnsl -lm  -o libpsqlodbc.so.0.27
relocations referenced
        from file(s)
        /usr/ccs/lib/libm.a(pow.o)
        /usr/ccs/lib/libm.a(fmod.o)
        /usr/ccs/lib/libm.a(merr.o)
 fatal error: relocations remain against allocatable but non-writable
section: .text

collect2: ld returned 1 exit status



The TCL stuff is because Caldera distribution of TCL is compiled with their
compiler. If you happen to use another compiler on your platform (gcc) it
doesn't work anymore. Caldera compiler has -belf -Kpic options which are
fully incompatible with gcc. That's why I though best to leave the TCL
packages been compiled with the compiler used for postgresql.

Note that I have the same issue for perl modules, but I haven't found a
proper way to correct the make files automatically generated. I understand
that we would want the same compilation options but if you install TCL or
PERL from packages you may not have the same compiler.

Appart these points the regression tests work fine for these platforms. They
are still a few warnings during the compilation process, when I get some
time, I'll try to correct them.

Nicolas

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Nicolas Bazin" <nbazin@ingenico.com.au>
Cc: "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Sent: Wednesday, March 27, 2002 12:08 AM
Subject: Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 7.1.1


>
> We am going to need an explaination on these changes.  Why move
> the socket test?  Why change pow()?  The TCL stuff is going to
> effect other platforms and probably will not be applied without a
> good reason.
>
> --------------------------------------------------------------------------
-
>
> Nicolas Bazin wrote:
> > Sorry for the package, but the following patch need to be applied
> > to get the new verion compiled on SCO Openserver 5.0.5 and
> > Unixware 7.1.1
>
> [ Attachment, skipping... ]
>
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>



Wed, 27 Mar 2002 09:38:57 +1100
"Nicolas Bazin" <nbazin@ingenico.com.au>
Re: build of 7.2.1 on SCO Openserver and Unixware 7.1.1

Thanks.  This is exactly the detail I needed.  Let me comment on each
item.


Nicolas Bazin wrote:
> Bruce,
> 
> The reason to move the socket library is that during configuration script
> execution, the binary created core dumps if not in the order I gave. You can
> check in the port list, some people have been complaining that they could
> not even go any further than the configure step and that is the reason.
> Here is the message you get otherwise:
> 
> checking test program... failed
> configure: error:
> *** Could not execute a simple test program.  This may be a problem
> *** related to locating shared libraries.  Check the file 'config.log'
> *** for the exact reason.
> 
> In config.log the last lines are:
> 
> configure:7516: checking test program
> configure:7525: gcc -o conftest -O2
> 
> 
> 
>  conftest.c -lz -lPW -lgen -lld -lnsl -lsocket -ldl -lm -lreadline -ltermcap
> 1>&5
> configure: failed program was:
> #line 7521 "configure"
> #include "confdefs.h"
> int main() { return 0; }

 From your link line, it seems -lnls is needed by -lsocket.  What I don't
know is whether there are other platforms that where -lnls needs
-lsocket.

	... $CFLAGS $CPPFLAGS $LDFLAGS conftest.$ac_ext $LIBS

That last LIBS grows as configure runs, so that is why reordering fixes
things for SCO.

I don't see any immediate downside to moving it so I will apply the
change to 7.3.  Any platforms problems with the reordering will show up
during 7.3 beta testing.  I would need someone else to agree before
making this change in 7.2.X.


> pow is in the static library libm and SCO Openserver linker does not accept
> to link it in a so file. The modification I provide works whithout changing
> the way the code works. If there is another way to get libm linked in so
> Here is the message I get:
> 
> gcc -shared -Wl,-z,text -Wl,-h,libpsqlodbc.so.0 -Wl,-Bsymbolic info.o bind.o
> columninfo.o connection.o convert.o drvconn.o environ.o execute.o lobj.o
> md5.o misc.o options.o pgtypes.o psqlodbc.o qresult.o results.o socket.o
> parse.o statement.o tuple.o tuplelist.o dlg_specific.o odbcapi.o
> pps.o  -lsocket -lnsl -lm  -o libpsqlodbc.so.0.27
> relocations referenced
>         from file(s)
>         /usr/ccs/lib/libm.a(pow.o)
>         /usr/ccs/lib/libm.a(fmod.o)
>         /usr/ccs/lib/libm.a(merr.o)
>  fatal error: relocations remain against allocatable but non-writable
> section: .text
> 
> collect2: ld returned 1 exit status

Yes, the patch replaces pow(8,*) with a lookup table of 4 8^X values. 
So SCO provides a library you can't link to?  Or you can't mix *.so
libraries and static *.a libraries?  I am inclined ot add this patch to
the doc/FAQ_SCO file.  We really try to avoid major code uglyness to
work around operating system things that should work on their own.



> The TCL stuff is because Caldera distribution of TCL is compiled with their
> compiler. If you happen to use another compiler on your platform (gcc) it
> doesn't work anymore. Caldera compiler has -belf -Kpic options which are
> fully incompatible with gcc. That's why I though best to leave the TCL
> packages been compiled with the compiler used for postgresql.
> 
> Note that I have the same issue for perl modules, but I haven't found a
> proper way to correct the make files automatically generated. I understand
> that we would want the same compilation options but if you install TCL or
> PERL from packages you may not have the same compiler.

Not sure how to deal with this one.  Can you add something to FAQ_SCO or
should I add this patch.  Clearly this is very OS specific and probably
only true for certain versions of SCO.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 27 Mar 2002 06:21:59 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: build of 7.2.1 on SCO Openserver and Unixware 7.1.1

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Nicolas Bazin" <nbazin@ingenico.com.au>
Cc: "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Sent: Wednesday, March 27, 2002 10:21 PM
Subject: Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 7.1.1


>
> Thanks.  This is exactly the detail I needed.  Let me comment on each
> item.
>
>
> Nicolas Bazin wrote:
> > Bruce,
> >
> > The reason to move the socket library is that during configuration
script
> > execution, the binary created core dumps if not in the order I gave. You
can
> > check in the port list, some people have been complaining that they
could
> > not even go any further than the configure step and that is the reason.
> > Here is the message you get otherwise:
> >
> > checking test program... failed
> > configure: error:
> > *** Could not execute a simple test program.  This may be a problem
> > *** related to locating shared libraries.  Check the file 'config.log'
> > *** for the exact reason.
> >
> > In config.log the last lines are:
> >
> > configure:7516: checking test program
> > configure:7525: gcc -o conftest -O2
> >
> >
> >
> >
 conftest.c -lz -lPW -lgen -lld -lnsl -lsocket -ldl -lm -lreadline -ltermcap
> > 1>&5
> > configure: failed program was:
> > #line 7521 "configure"
> > #include "confdefs.h"
> > int main() { return 0; }
>
> From your link line, it seems -lnls is needed by -lsocket.  What I don't
> know is whether there are other platforms that where -lnls needs
> -lsocket.
>
> ... $CFLAGS $CPPFLAGS $LDFLAGS conftest.$ac_ext $LIBS
>
> That last LIBS grows as configure runs, so that is why reordering fixes
> things for SCO.
>
> I don't see any immediate downside to moving it so I will apply the
> change to 7.3.  Any platforms problems with the reordering will show up
> during 7.3 beta testing.  I would need someone else to agree before
> making this change in 7.2.X.
The other possibility is to have configure to test the order of the library,
then there won't be any effect on any platform.
Try the existing order, if it fails try the other order.

>
>
> > pow is in the static library libm and SCO Openserver linker does not
accept
> > to link it in a so file. The modification I provide works whithout
changing
> > the way the code works. If there is another way to get libm linked in so
> > Here is the message I get:
> >
> > gcc -shared -Wl,-z,text -Wl,-h,libpsqlodbc.so.0 -Wl,-Bsymbolic info.o
bind.o
> > columninfo.o connection.o convert.o drvconn.o environ.o execute.o lobj.o
> > md5.o misc.o options.o pgtypes.o psqlodbc.o qresult.o results.o socket.o
> > parse.o statement.o tuple.o tuplelist.o dlg_specific.o odbcapi.o
> > pps.o  -lsocket -lnsl -lm  -o libpsqlodbc.so.0.27
> > relocations referenced
> >         from file(s)
> >         /usr/ccs/lib/libm.a(pow.o)
> >         /usr/ccs/lib/libm.a(fmod.o)
> >         /usr/ccs/lib/libm.a(merr.o)
> >  fatal error: relocations remain against allocatable but non-writable
> > section: .text
> >
> > collect2: ld returned 1 exit status
>
> Yes, the patch replaces pow(8,*) with a lookup table of 4 8^X values.
> So SCO provides a library you can't link to?  Or you can't mix *.so
> libraries and static *.a libraries?  I am inclined ot add this patch to
> the doc/FAQ_SCO file.  We really try to avoid major code uglyness to
> work around operating system things that should work on their own.
>
My guess is that this library has not been compiled as a pic code then it's
not relocatable. This must be a bug in SCO, and I only have seen this
problem with libm only yet.

>
>
> > The TCL stuff is because Caldera distribution of TCL is compiled with
their
> > compiler. If you happen to use another compiler on your platform (gcc)
it
> > doesn't work anymore. Caldera compiler has -belf -Kpic options which are
> > fully incompatible with gcc. That's why I though best to leave the TCL
> > packages been compiled with the compiler used for postgresql.
> >
> > Note that I have the same issue for perl modules, but I haven't found a
> > proper way to correct the make files automatically generated. I
understand
> > that we would want the same compilation options but if you install TCL
or
> > PERL from packages you may not have the same compiler.
>
> Not sure how to deal with this one.  Can you add something to FAQ_SCO or
> should I add this patch.  Clearly this is very OS specific and probably
> only true for certain versions of SCO.
>
I don't know much about other platforms. This is more a compiler
incompatibility then a platform problem. The problem comes from the fact
that one compiler was used to create a package and another one is used to
compile postgres. I know that your are supposed to be able to recompile the
code you installl on your server, but first sometimes it helps using
preconfigured packages and also it may not be so easy to recompile from the
public distribution that may need specific patches.

> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>
>



Wed, 27 Mar 2002 23:08:23 +1100
"Nicolas Bazin" <nbazin@ingenico.com.au>
Re: build of 7.2.1 on SCO Openserver and Unixware 7.1.1
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Yes, the patch replaces pow(8,*) with a lookup table of 4 8^X values. 
> So SCO provides a library you can't link to?  Or you can't mix *.so
> libraries and static *.a libraries?  I am inclined ot add this patch to
> the doc/FAQ_SCO file.  We really try to avoid major code uglyness to
> work around operating system things that should work on their own.

Actually, the existing coding in odbc is just plain stupid: why are we
using a transcendental function call to emulate an integer shift?
Even the table-based implementation that Nicolas proposed is doing it
the hard way.  Try converting, eg,

	for (i = 1; i <= 3; i++)
		y += (s[i] - 48) * (int) pow(8, 3 - i);

to

	for (i = 1; i <= 3; i++)
		y += (s[i] - '0') << (3 * (3 - i));

and you can get the patch accepted just on efficiency and readability
grounds, never mind whether it avoids SCO library breakage.

>> The TCL stuff is because Caldera distribution of TCL is compiled with their
>> compiler. If you happen to use another compiler on your platform (gcc) it
>> doesn't work anymore. Caldera compiler has -belf -Kpic options which are
>> fully incompatible with gcc. That's why I though best to leave the TCL
>> packages been compiled with the compiler used for postgresql.

We've been around on this a couple of times now; the current theory is
that we should stop using the TCL-supplied switches altogether.  There
is a patch in the works to change libpgtcl and pltcl to be built the
same way we build everything else in the distribution.

			regards, tom lane

Wed, 27 Mar 2002 10:30:06 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: build of 7.2.1 on SCO Openserver and Unixware 7.1.1 

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Bruce Momjian" <pgman@candle.pha.pa.us>
Cc: "Nicolas Bazin" <nbazin@ingenico.com.au>; "PostgreSQL-development"
<pgsql-hackers@postgresql.org>
Sent: Thursday, March 28, 2002 2:30 AM
Subject: Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 7.1.1


> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Yes, the patch replaces pow(8,*) with a lookup table of 4 8^X values.
> > So SCO provides a library you can't link to?  Or you can't mix *.so
> > libraries and static *.a libraries?  I am inclined ot add this patch to
> > the doc/FAQ_SCO file.  We really try to avoid major code uglyness to
> > work around operating system things that should work on their own.
>
> Actually, the existing coding in odbc is just plain stupid: why are we
> using a transcendental function call to emulate an integer shift?
> Even the table-based implementation that Nicolas proposed is doing it
> the hard way.  Try converting, eg,
>
> for (i = 1; i <= 3; i++)
> y += (s[i] - 48) * (int) pow(8, 3 - i);
>
> to
>
> for (i = 1; i <= 3; i++)
> y += (s[i] - '0') << (3 * (3 - i));
>
> and you can get the patch accepted just on efficiency and readability
> grounds, never mind whether it avoids SCO library breakage.
>
> >> The TCL stuff is because Caldera distribution of TCL is compiled with
their
> >> compiler. If you happen to use another compiler on your platform (gcc)
it
> >> doesn't work anymore. Caldera compiler has -belf -Kpic options which
are
> >> fully incompatible with gcc. That's why I though best to leave the TCL
> >> packages been compiled with the compiler used for postgresql.
>
> We've been around on this a couple of times now; the current theory is
> that we should stop using the TCL-supplied switches altogether.  There
> is a patch in the works to change libpgtcl and pltcl to be built the
> same way we build everything else in the distribution.
Perls modules have the same problems. Is there a patch also ?

>
> regards, tom lane
>
>



Thu, 28 Mar 2002 09:34:53 +1100
"Nicolas Bazin" <nbazin@ingenico.com.au>
Re: build of 7.2.1 on SCO Openserver and Unixware 7.1.1
Nicolas Bazin wrote:
> Sorry for the package, but the following patch need to be applied
> to get the new verion compiled on SCO Openserver 5.0.5 and
> Unixware 7.1.1

Reworked patch attached.  I reordered configure.in (autoconf will need
to be run).  I fixed the ODBC pow() call as Tom suggested, and the
regression script.  I did not touch TCL because that should be reworked
for 7.3 anyway.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Index: configure.in
===================================================================
RCS file: /cvsroot/pgsql/configure.in,v
retrieving revision 1.178
diff -c -r1.178 configure.in
*** configure.in	14 Apr 2002 17:23:20 -0000	1.178
--- configure.in	18 Apr 2002 01:14:14 -0000
***************
*** 696,703 ****
  AC_CHECK_LIB(util,     setproctitle)
  AC_CHECK_LIB(m,        main)
  AC_CHECK_LIB(dl,       main)
- AC_CHECK_LIB(socket,   main)
  AC_CHECK_LIB(nsl,      main)
  AC_CHECK_LIB(ipc,      main)
  AC_CHECK_LIB(IPC,      main)
  AC_CHECK_LIB(lc,       main)
--- 696,703 ----
  AC_CHECK_LIB(util,     setproctitle)
  AC_CHECK_LIB(m,        main)
  AC_CHECK_LIB(dl,       main)
  AC_CHECK_LIB(nsl,      main)
+ AC_CHECK_LIB(socket,   main)
  AC_CHECK_LIB(ipc,      main)
  AC_CHECK_LIB(IPC,      main)
  AC_CHECK_LIB(lc,       main)
Index: src/interfaces/odbc/convert.c
===================================================================
RCS file: /cvsroot/pgsql/src/interfaces/odbc/convert.c,v
retrieving revision 1.78
diff -c -r1.78 convert.c
*** src/interfaces/odbc/convert.c	1 Apr 2002 03:01:14 -0000	1.78
--- src/interfaces/odbc/convert.c	18 Apr 2002 01:14:29 -0000
***************
*** 2717,2723 ****
  				y = 0;
  
  	for (i = 1; i <= 3; i++)
! 		y += (s[i] - 48) * (int) pow(8, 3 - i);
  
  	return y;
  
--- 2717,2723 ----
  				y = 0;
  
  	for (i = 1; i <= 3; i++)
! 		y += (s[i] - '0') << (3  * (3 - i));
  
  	return y;
  
***************
*** 2740,2746 ****
  		else
  			val = s[i] - '0';
  
! 		y += val * (int) pow(16, 2 - i);
  	}
  
  	return y;
--- 2740,2746 ----
  		else
  			val = s[i] - '0';
  
! 		y += val << (4 * (2 - i));
  	}
  
  	return y;
***************
*** 2795,2801 ****
  
  	for (i = 4; i > 1; i--)
  	{
! 		x[i] = (val & 7) + 48;
  		val >>= 3;
  	}
  
--- 2795,2801 ----
  
  	for (i = 4; i > 1; i--)
  	{
! 		x[i] = (val & 7) + '0';
  		val >>= 3;
  	}
  
Index: src/test/regress/pg_regress.sh
===================================================================
RCS file: /cvsroot/pgsql/src/test/regress/pg_regress.sh,v
retrieving revision 1.23
diff -c -r1.23 pg_regress.sh
*** src/test/regress/pg_regress.sh	3 Jan 2002 21:52:05 -0000	1.23
--- src/test/regress/pg_regress.sh	18 Apr 2002 01:14:30 -0000
***************
*** 161,167 ****
  # ----------
  
  case $host_platform in
!     *-*-qnx* | *beos*)
          unix_sockets=no;;
      *)
          unix_sockets=yes;;
--- 161,167 ----
  # ----------
  
  case $host_platform in
!     *-*-qnx* | *beos* | *-*-sco3.2v5* | *-*-sysv5)
          unix_sockets=no;;
      *)
          unix_sockets=yes;;
Wed, 17 Apr 2002 21:17:52 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 7.1.1
The have_unix_sockets test in the regression test script should NOT
include sysv5.  They work fine in UnixWare 7.1.1 and OU8.



On Wed, 2002-04-17 at 20:17, Bruce Momjian wrote:
> Nicolas Bazin wrote:
> > Sorry for the package, but the following patch need to be applied
> > to get the new verion compiled on SCO Openserver 5.0.5 and
> > Unixware 7.1.1
> 
> Reworked patch attached.  I reordered configure.in (autoconf will need
> to be run).  I fixed the ODBC pow() call as Tom suggested, and the
> regression script.  I did not touch TCL because that should be reworked
> for 7.3 anyway.
> 
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> ----
> 

> Index: configure.in
> ===================================================================
> RCS file: /cvsroot/pgsql/configure.in,v
> retrieving revision 1.178
> diff -c -r1.178 configure.in
> *** configure.in	14 Apr 2002 17:23:20 -0000	1.178
> --- configure.in	18 Apr 2002 01:14:14 -0000
> ***************
> *** 696,703 ****
>   AC_CHECK_LIB(util,     setproctitle)
>   AC_CHECK_LIB(m,        main)
>   AC_CHECK_LIB(dl,       main)
> - AC_CHECK_LIB(socket,   main)
>   AC_CHECK_LIB(nsl,      main)
>   AC_CHECK_LIB(ipc,      main)
>   AC_CHECK_LIB(IPC,      main)
>   AC_CHECK_LIB(lc,       main)
> --- 696,703 ----
>   AC_CHECK_LIB(util,     setproctitle)
>   AC_CHECK_LIB(m,        main)
>   AC_CHECK_LIB(dl,       main)
>   AC_CHECK_LIB(nsl,      main)
> + AC_CHECK_LIB(socket,   main)
>   AC_CHECK_LIB(ipc,      main)
>   AC_CHECK_LIB(IPC,      main)
>   AC_CHECK_LIB(lc,       main)
> Index: src/interfaces/odbc/convert.c
> ===================================================================
> RCS file: /cvsroot/pgsql/src/interfaces/odbc/convert.c,v
> retrieving revision 1.78
> diff -c -r1.78 convert.c
> *** src/interfaces/odbc/convert.c	1 Apr 2002 03:01:14 -0000	1.78
> --- src/interfaces/odbc/convert.c	18 Apr 2002 01:14:29 -0000
> ***************
> *** 2717,2723 ****
>   				y = 0;
>   
>   	for (i = 1; i <= 3; i++)
> ! 		y += (s[i] - 48) * (int) pow(8, 3 - i);
>   
>   	return y;
>   
> --- 2717,2723 ----
>   				y = 0;
>   
>   	for (i = 1; i <= 3; i++)
> ! 		y += (s[i] - '0') << (3  * (3 - i));
>   
>   	return y;
>   
> ***************
> *** 2740,2746 ****
>   		else
>   			val = s[i] - '0';
>   
> ! 		y += val * (int) pow(16, 2 - i);
>   	}
>   
>   	return y;
> --- 2740,2746 ----
>   		else
>   			val = s[i] - '0';
>   
> ! 		y += val << (4 * (2 - i));
>   	}
>   
>   	return y;
> ***************
> *** 2795,2801 ****
>   
>   	for (i = 4; i > 1; i--)
>   	{
> ! 		x[i] = (val & 7) + 48;
>   		val >>= 3;
>   	}
>   
> --- 2795,2801 ----
>   
>   	for (i = 4; i > 1; i--)
>   	{
> ! 		x[i] = (val & 7) + '0';
>   		val >>= 3;
>   	}
>   
> Index: src/test/regress/pg_regress.sh
> ===================================================================
> RCS file: /cvsroot/pgsql/src/test/regress/pg_regress.sh,v
> retrieving revision 1.23
> diff -c -r1.23 pg_regress.sh
> *** src/test/regress/pg_regress.sh	3 Jan 2002 21:52:05 -0000	1.23
> --- src/test/regress/pg_regress.sh	18 Apr 2002 01:14:30 -0000
> ***************
> *** 161,167 ****
>   # ----------
>   
>   case $host_platform in
> !     *-*-qnx* | *beos*)
>           unix_sockets=no;;
>       *)
>           unix_sockets=yes;;
> --- 161,167 ----
>   # ----------
>   
>   case $host_platform in
> !     *-*-qnx* | *beos* | *-*-sco3.2v5* | *-*-sysv5)
>           unix_sockets=no;;
>       *)
>           unix_sockets=yes;;
> ----
> 

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


17 Apr 2002 20:21:45 -0500
Larry Rosenman <ler@lerctr.org>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and

OK, new code is:

	!     *-*-qnx* | *beos* | *-*-sco3.2v5*)            

---------------------------------------------------------------------------

Larry Rosenman wrote:
> The have_unix_sockets test in the regression test script should NOT
> include sysv5.  They work fine in UnixWare 7.1.1 and OU8.
> 
> 
> 
> On Wed, 2002-04-17 at 20:17, Bruce Momjian wrote:
> > Nicolas Bazin wrote:
> > > Sorry for the package, but the following patch need to be applied
> > > to get the new verion compiled on SCO Openserver 5.0.5 and
> > > Unixware 7.1.1
> > 
> > Reworked patch attached.  I reordered configure.in (autoconf will need
> > to be run).  I fixed the ODBC pow() call as Tom suggested, and the
> > regression script.  I did not touch TCL because that should be reworked
> > for 7.3 anyway.
> > 
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> > ----
> > 
> 
> > Index: configure.in
> > ===================================================================
> > RCS file: /cvsroot/pgsql/configure.in,v
> > retrieving revision 1.178
> > diff -c -r1.178 configure.in
> > *** configure.in	14 Apr 2002 17:23:20 -0000	1.178
> > --- configure.in	18 Apr 2002 01:14:14 -0000
> > ***************
> > *** 696,703 ****
> >   AC_CHECK_LIB(util,     setproctitle)
> >   AC_CHECK_LIB(m,        main)
> >   AC_CHECK_LIB(dl,       main)
> > - AC_CHECK_LIB(socket,   main)
> >   AC_CHECK_LIB(nsl,      main)
> >   AC_CHECK_LIB(ipc,      main)
> >   AC_CHECK_LIB(IPC,      main)
> >   AC_CHECK_LIB(lc,       main)
> > --- 696,703 ----
> >   AC_CHECK_LIB(util,     setproctitle)
> >   AC_CHECK_LIB(m,        main)
> >   AC_CHECK_LIB(dl,       main)
> >   AC_CHECK_LIB(nsl,      main)
> > + AC_CHECK_LIB(socket,   main)
> >   AC_CHECK_LIB(ipc,      main)
> >   AC_CHECK_LIB(IPC,      main)
> >   AC_CHECK_LIB(lc,       main)
> > Index: src/interfaces/odbc/convert.c
> > ===================================================================
> > RCS file: /cvsroot/pgsql/src/interfaces/odbc/convert.c,v
> > retrieving revision 1.78
> > diff -c -r1.78 convert.c
> > *** src/interfaces/odbc/convert.c	1 Apr 2002 03:01:14 -0000	1.78
> > --- src/interfaces/odbc/convert.c	18 Apr 2002 01:14:29 -0000
> > ***************
> > *** 2717,2723 ****
> >   				y = 0;
> >   
> >   	for (i = 1; i <= 3; i++)
> > ! 		y += (s[i] - 48) * (int) pow(8, 3 - i);
> >   
> >   	return y;
> >   
> > --- 2717,2723 ----
> >   				y = 0;
> >   
> >   	for (i = 1; i <= 3; i++)
> > ! 		y += (s[i] - '0') << (3  * (3 - i));
> >   
> >   	return y;
> >   
> > ***************
> > *** 2740,2746 ****
> >   		else
> >   			val = s[i] - '0';
> >   
> > ! 		y += val * (int) pow(16, 2 - i);
> >   	}
> >   
> >   	return y;
> > --- 2740,2746 ----
> >   		else
> >   			val = s[i] - '0';
> >   
> > ! 		y += val << (4 * (2 - i));
> >   	}
> >   
> >   	return y;
> > ***************
> > *** 2795,2801 ****
> >   
> >   	for (i = 4; i > 1; i--)
> >   	{
> > ! 		x[i] = (val & 7) + 48;
> >   		val >>= 3;
> >   	}
> >   
> > --- 2795,2801 ----
> >   
> >   	for (i = 4; i > 1; i--)
> >   	{
> > ! 		x[i] = (val & 7) + '0';
> >   		val >>= 3;
> >   	}
> >   
> > Index: src/test/regress/pg_regress.sh
> > ===================================================================
> > RCS file: /cvsroot/pgsql/src/test/regress/pg_regress.sh,v
> > retrieving revision 1.23
> > diff -c -r1.23 pg_regress.sh
> > *** src/test/regress/pg_regress.sh	3 Jan 2002 21:52:05 -0000	1.23
> > --- src/test/regress/pg_regress.sh	18 Apr 2002 01:14:30 -0000
> > ***************
> > *** 161,167 ****
> >   # ----------
> >   
> >   case $host_platform in
> > !     *-*-qnx* | *beos*)
> >           unix_sockets=no;;
> >       *)
> >           unix_sockets=yes;;
> > --- 161,167 ----
> >   # ----------
> >   
> >   case $host_platform in
> > !     *-*-qnx* | *beos* | *-*-sco3.2v5* | *-*-sysv5)
> >           unix_sockets=no;;
> >       *)
> >           unix_sockets=yes;;
> > ----
> > 
> 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> -- 
> Larry Rosenman                     http://www.lerctr.org/~ler
> Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
> 
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 17 Apr 2002 21:23:19 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware
On Wed, 2002-04-17 at 20:23, Bruce Momjian wrote:
> 
> OK, new code is:
> 
> 	!     *-*-qnx* | *beos* | *-*-sco3.2v5*)            
Thank You.

LER

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


17 Apr 2002 20:25:27 -0500
Larry Rosenman <ler@lerctr.org>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and
On Wed, 2002-04-17 at 22:16, Peter Eisentraut wrote:
> Bruce Momjian writes:
> 
> > OK, new code is:
> >
> > 	!     *-*-qnx* | *beos* | *-*-sco3.2v5*)
>                                   ^^^^^^^^^^^^^
> 
> I would like to see an explanation for this.
I personally can't comment on SCO OpenServer.  I do know that the
original patch for sysv5 was wrong.  (from personal experience). 

LER

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


17 Apr 2002 22:14:20 -0500
Larry Rosenman <ler@lerctr.org>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and
Peter Eisentraut wrote:
> Bruce Momjian writes:
> 
> > OK, new code is:
> >
> > 	!     *-*-qnx* | *beos* | *-*-sco3.2v5*)
>                                   ^^^^^^^^^^^^^
> 
> I would like to see an explanation for this.

The patch section is below.  Not knowing the platform, I have no idea
why.

  case $host_platform in
!     *-*-qnx* | *beos* | *-*-sco3.2v5*)
          unix_sockets=no;;
      *)
          unix_sockets=yes;;

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 17 Apr 2002 23:15:30 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware
Bruce Momjian writes:

> OK, new code is:
>
> 	!     *-*-qnx* | *beos* | *-*-sco3.2v5*)
                                  ^^^^^^^^^^^^^

I would like to see an explanation for this.

-- 
Peter Eisentraut   peter_e@gmx.net


Wed, 17 Apr 2002 23:16:01 -0400 (EDT)
Peter Eisentraut <peter_e@gmx.net>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware
The patch from Bruce does not correct the proper thing. The original patch I
submitted was :
*** postgresql-7.2.1-rc/src/test/regress/pg_regress.sh Tue Mar 26 16:49:04
2002
--- postgresql-7.2.1/src/test/regress/pg_regress.sh Tue Mar 26 17:03:39 2002
***************
*** 173,179 ****
# ----------
case $host_platform in
! *-*-qnx*)
DIFFFLAGS=-b;;
*)
DIFFFLAGS=-w;;
--- 173,179 ----
# ----------
case $host_platform in
! *-*-qnx* | *-*-sco3.2v5* | *-*-sysv5)
DIFFFLAGS=-b;;
*)
DIFFFLAGS=-w;;

Because the diff tool that comes with Openserver or Unixware does not suppor
the -w option but the -b option to remove blank characters.
There is nothing wrong with unix sockets on both platforms.

Nicolas

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Peter Eisentraut" <peter_e@gmx.net>
Cc: "Larry Rosenman" <ler@lerctr.org>; "Nicolas Bazin"
<nbazin@ingenico.com.au>; "PostgreSQL-patches"
<pgsql-patches@postgresql.org>
Sent: Thursday, April 18, 2002 1:15 PM
Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver and
Unixware


> Peter Eisentraut wrote:
> > Bruce Momjian writes:
> >
> > > OK, new code is:
> > >
> > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> >                                   ^^^^^^^^^^^^^
> >
> > I would like to see an explanation for this.
>
> The patch section is below.  Not knowing the platform, I have no idea
> why.
>
>   case $host_platform in
> !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
>           unix_sockets=no;;
>       *)
>           unix_sockets=yes;;
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>



Thu, 18 Apr 2002 17:13:24 +1000
"Nicolas Bazin" <nbazin@ingenico.com.au>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware
Per the man page on OpenUNIX 8, the UnixWare diff ***DOES*** support -w.

see the man page at http://www.lerctr.org:457/

LER


On Thu, 2002-04-18 at 02:13, Nicolas Bazin wrote:
> The patch from Bruce does not correct the proper thing. The original patch I
> submitted was :
> *** postgresql-7.2.1-rc/src/test/regress/pg_regress.sh Tue Mar 26 16:49:04
> 2002
> --- postgresql-7.2.1/src/test/regress/pg_regress.sh Tue Mar 26 17:03:39 2002
> ***************
> *** 173,179 ****
> # ----------
> case $host_platform in
> ! *-*-qnx*)
> DIFFFLAGS=-b;;
> *)
> DIFFFLAGS=-w;;
> --- 173,179 ----
> # ----------
> case $host_platform in
> ! *-*-qnx* | *-*-sco3.2v5* | *-*-sysv5)
> DIFFFLAGS=-b;;
> *)
> DIFFFLAGS=-w;;
> 
> Because the diff tool that comes with Openserver or Unixware does not suppor
> the -w option but the -b option to remove blank characters.
> There is nothing wrong with unix sockets on both platforms.
> 
> Nicolas
> 
> ----- Original Message -----
> From: "Bruce Momjian" <pgman@candle.pha.pa.us>
> To: "Peter Eisentraut" <peter_e@gmx.net>
> Cc: "Larry Rosenman" <ler@lerctr.org>; "Nicolas Bazin"
> <nbazin@ingenico.com.au>; "PostgreSQL-patches"
> <pgsql-patches@postgresql.org>
> Sent: Thursday, April 18, 2002 1:15 PM
> Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver and
> Unixware
> 
> 
> > Peter Eisentraut wrote:
> > > Bruce Momjian writes:
> > >
> > > > OK, new code is:
> > > >
> > > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > >                                   ^^^^^^^^^^^^^
> > >
> > > I would like to see an explanation for this.
> >
> > The patch section is below.  Not knowing the platform, I have no idea
> > why.
> >
> >   case $host_platform in
> > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> >           unix_sockets=no;;
> >       *)
> >           unix_sockets=yes;;
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
> >
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


18 Apr 2002 09:38:06 -0500
Larry Rosenman <ler@lerctr.org>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and
Sorry, here is an updated patch.  I didn't realize there were two QNX
tests in the file.

The patch has:

	case  $host_platform in
	    *-*-qnx* | *-*-sco3.2v5*)
	        DIFFFLAGS=-b;;
	    *)
	        DIFFFLAGS=-w;;
	esac

Is this correct.  We don't need the sysv5?  It is my understanding that
sysv5 is much more than Open Server 8.

---------------------------------------------------------------------------

Nicolas Bazin wrote:
> The patch from Bruce does not correct the proper thing. The original patch I
> submitted was :
> *** postgresql-7.2.1-rc/src/test/regress/pg_regress.sh Tue Mar 26 16:49:04
> 2002
> --- postgresql-7.2.1/src/test/regress/pg_regress.sh Tue Mar 26 17:03:39 2002
> ***************
> *** 173,179 ****
> # ----------
> case $host_platform in
> ! *-*-qnx*)
> DIFFFLAGS=-b;;
> *)
> DIFFFLAGS=-w;;
> --- 173,179 ----
> # ----------
> case $host_platform in
> ! *-*-qnx* | *-*-sco3.2v5* | *-*-sysv5)
> DIFFFLAGS=-b;;
> *)
> DIFFFLAGS=-w;;
> 
> Because the diff tool that comes with Openserver or Unixware does not suppor
> the -w option but the -b option to remove blank characters.
> There is nothing wrong with unix sockets on both platforms.
> 
> Nicolas
> 
> ----- Original Message -----
> From: "Bruce Momjian" <pgman@candle.pha.pa.us>
> To: "Peter Eisentraut" <peter_e@gmx.net>
> Cc: "Larry Rosenman" <ler@lerctr.org>; "Nicolas Bazin"
> <nbazin@ingenico.com.au>; "PostgreSQL-patches"
> <pgsql-patches@postgresql.org>
> Sent: Thursday, April 18, 2002 1:15 PM
> Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver and
> Unixware
> 
> 
> > Peter Eisentraut wrote:
> > > Bruce Momjian writes:
> > >
> > > > OK, new code is:
> > > >
> > > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > >                                   ^^^^^^^^^^^^^
> > >
> > > I would like to see an explanation for this.
> >
> > The patch section is below.  Not knowing the platform, I have no idea
> > why.
> >
> >   case $host_platform in
> > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> >           unix_sockets=no;;
> >       *)
> >           unix_sockets=yes;;
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
> >
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Index: configure.in
===================================================================
RCS file: /cvsroot/pgsql/configure.in,v
retrieving revision 1.178
diff -c -r1.178 configure.in
*** configure.in	14 Apr 2002 17:23:20 -0000	1.178
--- configure.in	18 Apr 2002 15:26:08 -0000
***************
*** 696,703 ****
  AC_CHECK_LIB(util,     setproctitle)
  AC_CHECK_LIB(m,        main)
  AC_CHECK_LIB(dl,       main)
- AC_CHECK_LIB(socket,   main)
  AC_CHECK_LIB(nsl,      main)
  AC_CHECK_LIB(ipc,      main)
  AC_CHECK_LIB(IPC,      main)
  AC_CHECK_LIB(lc,       main)
--- 696,703 ----
  AC_CHECK_LIB(util,     setproctitle)
  AC_CHECK_LIB(m,        main)
  AC_CHECK_LIB(dl,       main)
  AC_CHECK_LIB(nsl,      main)
+ AC_CHECK_LIB(socket,   main)
  AC_CHECK_LIB(ipc,      main)
  AC_CHECK_LIB(IPC,      main)
  AC_CHECK_LIB(lc,       main)
Index: src/interfaces/odbc/convert.c
===================================================================
RCS file: /cvsroot/pgsql/src/interfaces/odbc/convert.c,v
retrieving revision 1.78
diff -c -r1.78 convert.c
*** src/interfaces/odbc/convert.c	1 Apr 2002 03:01:14 -0000	1.78
--- src/interfaces/odbc/convert.c	18 Apr 2002 15:26:23 -0000
***************
*** 2717,2723 ****
  				y = 0;
  
  	for (i = 1; i <= 3; i++)
! 		y += (s[i] - 48) * (int) pow(8, 3 - i);
  
  	return y;
  
--- 2717,2723 ----
  				y = 0;
  
  	for (i = 1; i <= 3; i++)
! 		y += (s[i] - '0') << (3  * (3 - i));
  
  	return y;
  
***************
*** 2740,2746 ****
  		else
  			val = s[i] - '0';
  
! 		y += val * (int) pow(16, 2 - i);
  	}
  
  	return y;
--- 2740,2746 ----
  		else
  			val = s[i] - '0';
  
! 		y += val << (4 * (2 - i));
  	}
  
  	return y;
***************
*** 2795,2801 ****
  
  	for (i = 4; i > 1; i--)
  	{
! 		x[i] = (val & 7) + 48;
  		val >>= 3;
  	}
  
--- 2795,2801 ----
  
  	for (i = 4; i > 1; i--)
  	{
! 		x[i] = (val & 7) + '0';
  		val >>= 3;
  	}
  
Index: src/test/regress/pg_regress.sh
===================================================================
RCS file: /cvsroot/pgsql/src/test/regress/pg_regress.sh,v
retrieving revision 1.23
diff -c -r1.23 pg_regress.sh
*** src/test/regress/pg_regress.sh	3 Jan 2002 21:52:05 -0000	1.23
--- src/test/regress/pg_regress.sh	18 Apr 2002 15:26:24 -0000
***************
*** 173,179 ****
  # ----------
  
  case $host_platform in
!     *-*-qnx*)
          DIFFFLAGS=-b;;
      *)
          DIFFFLAGS=-w;;
--- 173,179 ----
  # ----------
  
  case $host_platform in
!     *-*-qnx* | *-*-sco3.2v5*)
          DIFFFLAGS=-b;;
      *)
          DIFFFLAGS=-w;;
Thu, 18 Apr 2002 11:31:24 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware
Bruce Momjian writes:

> The patch has:
>
> 	case  $host_platform in
> 	    *-*-qnx* | *-*-sco3.2v5*)
> 	        DIFFFLAGS=-b;;
> 	    *)
> 	        DIFFFLAGS=-w;;
> 	esac
>
> Is this correct.  We don't need the sysv5?  It is my understanding that
> sysv5 is much more than Open Server 8.

Do we need this at all?  Why not simply fix the expected files to remove
the whitespace differences?

-- 
Peter Eisentraut   peter_e@gmx.net


Thu, 18 Apr 2002 12:33:48 -0400 (EDT)
Peter Eisentraut <peter_e@gmx.net>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware
Peter Eisentraut <peter_e@gmx.net> writes:
> Do we need this at all?  Why not simply fix the expected files to remove
> the whitespace differences?

There shouldn't *be* any whitespace differences in a successful test.
The point of the -w switch is not to make any difference in a successful
test, it is to reduce the amount of irrelevant stuff printed in a failed
test.  If you have one bogus output item that is wider than the correct
value, that can cause psql to reformat the display wider in all rows.
The point of using -w is to not show those other rows as changed.

			regards, tom lane

Thu, 18 Apr 2002 12:57:17 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 
Well I use Unixware 7.1.1. I cannot check again right now whether 7.1.1
supports -w but if I made the effort to change the shell, I guess I had a
good reason. Next time I put my hand on my Unixware PC I'll double check.

Nicolas

----- Original Message -----
From: "Larry Rosenman" <ler@lerctr.org>
To: "Nicolas Bazin" <nbazin@ingenico.com.au>
Cc: "Bruce Momjian" <pgman@candle.pha.pa.us>; "Peter Eisentraut"
<peter_e@gmx.net>; "PostgreSQL-patches" <pgsql-patches@postgresql.org>
Sent: Friday, April 19, 2002 12:38 AM
Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver
andUnixware


> Per the man page on OpenUNIX 8, the UnixWare diff ***DOES*** support -w.
>
> see the man page at http://www.lerctr.org:457/
>
> LER
>
>
> On Thu, 2002-04-18 at 02:13, Nicolas Bazin wrote:
> > The patch from Bruce does not correct the proper thing. The original
patch I
> > submitted was :
> > *** postgresql-7.2.1-rc/src/test/regress/pg_regress.sh Tue Mar 26
16:49:04
> > 2002
> > --- postgresql-7.2.1/src/test/regress/pg_regress.sh Tue Mar 26 17:03:39
2002
> > ***************
> > *** 173,179 ****
> > # ----------
> > case $host_platform in
> > ! *-*-qnx*)
> > DIFFFLAGS=-b;;
> > *)
> > DIFFFLAGS=-w;;
> > --- 173,179 ----
> > # ----------
> > case $host_platform in
> > ! *-*-qnx* | *-*-sco3.2v5* | *-*-sysv5)
> > DIFFFLAGS=-b;;
> > *)
> > DIFFFLAGS=-w;;
> >
> > Because the diff tool that comes with Openserver or Unixware does not
suppor
> > the -w option but the -b option to remove blank characters.
> > There is nothing wrong with unix sockets on both platforms.
> >
> > Nicolas
> >
> > ----- Original Message -----
> > From: "Bruce Momjian" <pgman@candle.pha.pa.us>
> > To: "Peter Eisentraut" <peter_e@gmx.net>
> > Cc: "Larry Rosenman" <ler@lerctr.org>; "Nicolas Bazin"
> > <nbazin@ingenico.com.au>; "PostgreSQL-patches"
> > <pgsql-patches@postgresql.org>
> > Sent: Thursday, April 18, 2002 1:15 PM
> > Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver and
> > Unixware
> >
> >
> > > Peter Eisentraut wrote:
> > > > Bruce Momjian writes:
> > > >
> > > > > OK, new code is:
> > > > >
> > > > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > > >                                   ^^^^^^^^^^^^^
> > > >
> > > > I would like to see an explanation for this.
> > >
> > > The patch section is below.  Not knowing the platform, I have no idea
> > > why.
> > >
> > >   case $host_platform in
> > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > >           unix_sockets=no;;
> > >       *)
> > >           unix_sockets=yes;;
> > >
> > > --
> > >   Bruce Momjian                        |  http://candle.pha.pa.us
> > >   pgman@candle.pha.pa.us               |  (610) 853-3000
> > >   +  If your life is a hard drive,     |  830 Blythe Avenue
> > >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
19026
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 5: Have you checked our extensive FAQ?
> > >
> > > http://www.postgresql.org/users-lounge/docs/faq.html
> > >
> > >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> --
> Larry Rosenman                     http://www.lerctr.org/~ler
> Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
>
>
>
>




Fri, 19 Apr 2002 08:53:59 +1000
"Nicolas Bazin" <nbazin@ingenico.com.au>
Re: [HACKERS] build of 7.2.1 on SCO Openserver andUnixware
Well then it means that we will have to make a difference between Unixware
7.1.1 and OpenUnix 8.0.

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Nicolas Bazin" <nbazin@ingenico.com.au>
Cc: "Peter Eisentraut" <peter_e@gmx.net>; "Larry Rosenman" <ler@lerctr.org>;
"PostgreSQL-patches" <pgsql-patches@postgresql.org>
Sent: Friday, April 19, 2002 1:31 AM
Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver and
Unixware


>
> Sorry, here is an updated patch.  I didn't realize there were two QNX
> tests in the file.
>
> The patch has:
>
> case  $host_platform in
>     *-*-qnx* | *-*-sco3.2v5*)
>         DIFFFLAGS=-b;;
>     *)
>         DIFFFLAGS=-w;;
> esac
>
> Is this correct.  We don't need the sysv5?  It is my understanding that
> sysv5 is much more than Open Server 8.
>
> --------------------------------------------------------------------------
-
>
> Nicolas Bazin wrote:
> > The patch from Bruce does not correct the proper thing. The original
patch I
> > submitted was :
> > *** postgresql-7.2.1-rc/src/test/regress/pg_regress.sh Tue Mar 26
16:49:04
> > 2002
> > --- postgresql-7.2.1/src/test/regress/pg_regress.sh Tue Mar 26 17:03:39
2002
> > ***************
> > *** 173,179 ****
> > # ----------
> > case $host_platform in
> > ! *-*-qnx*)
> > DIFFFLAGS=-b;;
> > *)
> > DIFFFLAGS=-w;;
> > --- 173,179 ----
> > # ----------
> > case $host_platform in
> > ! *-*-qnx* | *-*-sco3.2v5* | *-*-sysv5)
> > DIFFFLAGS=-b;;
> > *)
> > DIFFFLAGS=-w;;
> >
> > Because the diff tool that comes with Openserver or Unixware does not
suppor
> > the -w option but the -b option to remove blank characters.
> > There is nothing wrong with unix sockets on both platforms.
> >
> > Nicolas
> >
> > ----- Original Message -----
> > From: "Bruce Momjian" <pgman@candle.pha.pa.us>
> > To: "Peter Eisentraut" <peter_e@gmx.net>
> > Cc: "Larry Rosenman" <ler@lerctr.org>; "Nicolas Bazin"
> > <nbazin@ingenico.com.au>; "PostgreSQL-patches"
> > <pgsql-patches@postgresql.org>
> > Sent: Thursday, April 18, 2002 1:15 PM
> > Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver and
> > Unixware
> >
> >
> > > Peter Eisentraut wrote:
> > > > Bruce Momjian writes:
> > > >
> > > > > OK, new code is:
> > > > >
> > > > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > > >                                   ^^^^^^^^^^^^^
> > > >
> > > > I would like to see an explanation for this.
> > >
> > > The patch section is below.  Not knowing the platform, I have no idea
> > > why.
> > >
> > >   case $host_platform in
> > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > >           unix_sockets=no;;
> > >       *)
> > >           unix_sockets=yes;;
> > >
> > > --
> > >   Bruce Momjian                        |  http://candle.pha.pa.us
> > >   pgman@candle.pha.pa.us               |  (610) 853-3000
> > >   +  If your life is a hard drive,     |  830 Blythe Avenue
> > >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
19026
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 5: Have you checked our extensive FAQ?
> > >
> > > http://www.postgresql.org/users-lounge/docs/faq.html
> > >
> > >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>


----------------------------------------------------------------------------
----


> Index: configure.in
> ===================================================================
> RCS file: /cvsroot/pgsql/configure.in,v
> retrieving revision 1.178
> diff -c -r1.178 configure.in
> *** configure.in 14 Apr 2002 17:23:20 -0000 1.178
> --- configure.in 18 Apr 2002 15:26:08 -0000
> ***************
> *** 696,703 ****
>   AC_CHECK_LIB(util,     setproctitle)
>   AC_CHECK_LIB(m,        main)
>   AC_CHECK_LIB(dl,       main)
> - AC_CHECK_LIB(socket,   main)
>   AC_CHECK_LIB(nsl,      main)
>   AC_CHECK_LIB(ipc,      main)
>   AC_CHECK_LIB(IPC,      main)
>   AC_CHECK_LIB(lc,       main)
> --- 696,703 ----
>   AC_CHECK_LIB(util,     setproctitle)
>   AC_CHECK_LIB(m,        main)
>   AC_CHECK_LIB(dl,       main)
>   AC_CHECK_LIB(nsl,      main)
> + AC_CHECK_LIB(socket,   main)
>   AC_CHECK_LIB(ipc,      main)
>   AC_CHECK_LIB(IPC,      main)
>   AC_CHECK_LIB(lc,       main)
> Index: src/interfaces/odbc/convert.c
> ===================================================================
> RCS file: /cvsroot/pgsql/src/interfaces/odbc/convert.c,v
> retrieving revision 1.78
> diff -c -r1.78 convert.c
> *** src/interfaces/odbc/convert.c 1 Apr 2002 03:01:14 -0000 1.78
> --- src/interfaces/odbc/convert.c 18 Apr 2002 15:26:23 -0000
> ***************
> *** 2717,2723 ****
>   y = 0;
>
>   for (i = 1; i <= 3; i++)
> ! y += (s[i] - 48) * (int) pow(8, 3 - i);
>
>   return y;
>
> --- 2717,2723 ----
>   y = 0;
>
>   for (i = 1; i <= 3; i++)
> ! y += (s[i] - '0') << (3  * (3 - i));
>
>   return y;
>
> ***************
> *** 2740,2746 ****
>   else
>   val = s[i] - '0';
>
> ! y += val * (int) pow(16, 2 - i);
>   }
>
>   return y;
> --- 2740,2746 ----
>   else
>   val = s[i] - '0';
>
> ! y += val << (4 * (2 - i));
>   }
>
>   return y;
> ***************
> *** 2795,2801 ****
>
>   for (i = 4; i > 1; i--)
>   {
> ! x[i] = (val & 7) + 48;
>   val >>= 3;
>   }
>
> --- 2795,2801 ----
>
>   for (i = 4; i > 1; i--)
>   {
> ! x[i] = (val & 7) + '0';
>   val >>= 3;
>   }
>
> Index: src/test/regress/pg_regress.sh
> ===================================================================
> RCS file: /cvsroot/pgsql/src/test/regress/pg_regress.sh,v
> retrieving revision 1.23
> diff -c -r1.23 pg_regress.sh
> *** src/test/regress/pg_regress.sh 3 Jan 2002 21:52:05 -0000 1.23
> --- src/test/regress/pg_regress.sh 18 Apr 2002 15:26:24 -0000
> ***************
> *** 173,179 ****
>   # ----------
>
>   case $host_platform in
> !     *-*-qnx*)
>           DIFFFLAGS=-b;;
>       *)
>           DIFFFLAGS=-w;;
> --- 173,179 ----
>   # ----------
>
>   case $host_platform in
> !     *-*-qnx* | *-*-sco3.2v5*)
>           DIFFFLAGS=-b;;
>       *)
>           DIFFFLAGS=-w;;
>


----------------------------------------------------------------------------
----


>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>



Fri, 19 Apr 2002 08:56:36 +1000
"Nicolas Bazin" <nbazin@ingenico.com.au>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware
Unixware 711 manual says diff supports -w as said in :
-w
	Ignores all blanks (<Space> and TAB characters) and treats all
	other strings of blanks as equivalent; for example,
	if ( a == b ) will compare eaqual to if(a==b).

Hope it helps,
On Fri, 19 Apr 2002, Nicolas Bazin wrote:

> Well I use Unixware 7.1.1. I cannot check again right now whether 7.1.1
> supports -w but if I made the effort to change the shell, I guess I had a
> good reason. Next time I put my hand on my Unixware PC I'll double check.
> 
> Nicolas
> 
> ----- Original Message -----
> From: "Larry Rosenman" <ler@lerctr.org>
> To: "Nicolas Bazin" <nbazin@ingenico.com.au>
> Cc: "Bruce Momjian" <pgman@candle.pha.pa.us>; "Peter Eisentraut"
> <peter_e@gmx.net>; "PostgreSQL-patches" <pgsql-patches@postgresql.org>
> Sent: Friday, April 19, 2002 12:38 AM
> Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver
> andUnixware
> 
> 
> > Per the man page on OpenUNIX 8, the UnixWare diff ***DOES*** support -w.
> >
> > see the man page at http://www.lerctr.org:457/
> >
> > LER
> >
> >
> > On Thu, 2002-04-18 at 02:13, Nicolas Bazin wrote:
> > > The patch from Bruce does not correct the proper thing. The original
> patch I
> > > submitted was :
> > > *** postgresql-7.2.1-rc/src/test/regress/pg_regress.sh Tue Mar 26
> 16:49:04
> > > 2002
> > > --- postgresql-7.2.1/src/test/regress/pg_regress.sh Tue Mar 26 17:03:39
> 2002
> > > ***************
> > > *** 173,179 ****
> > > # ----------
> > > case $host_platform in
> > > ! *-*-qnx*)
> > > DIFFFLAGS=-b;;
> > > *)
> > > DIFFFLAGS=-w;;
> > > --- 173,179 ----
> > > # ----------
> > > case $host_platform in
> > > ! *-*-qnx* | *-*-sco3.2v5* | *-*-sysv5)
> > > DIFFFLAGS=-b;;
> > > *)
> > > DIFFFLAGS=-w;;
> > >
> > > Because the diff tool that comes with Openserver or Unixware does not
> suppor
> > > the -w option but the -b option to remove blank characters.
> > > There is nothing wrong with unix sockets on both platforms.
> > >
> > > Nicolas
> > >
> > > ----- Original Message -----
> > > From: "Bruce Momjian" <pgman@candle.pha.pa.us>
> > > To: "Peter Eisentraut" <peter_e@gmx.net>
> > > Cc: "Larry Rosenman" <ler@lerctr.org>; "Nicolas Bazin"
> > > <nbazin@ingenico.com.au>; "PostgreSQL-patches"
> > > <pgsql-patches@postgresql.org>
> > > Sent: Thursday, April 18, 2002 1:15 PM
> > > Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver and
> > > Unixware
> > >
> > >
> > > > Peter Eisentraut wrote:
> > > > > Bruce Momjian writes:
> > > > >
> > > > > > OK, new code is:
> > > > > >
> > > > > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > > > >                                   ^^^^^^^^^^^^^
> > > > >
> > > > > I would like to see an explanation for this.
> > > >
> > > > The patch section is below.  Not knowing the platform, I have no idea
> > > > why.
> > > >
> > > >   case $host_platform in
> > > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > > >           unix_sockets=no;;
> > > >       *)
> > > >           unix_sockets=yes;;
> > > >
> > > > --
> > > >   Bruce Momjian                        |  http://candle.pha.pa.us
> > > >   pgman@candle.pha.pa.us               |  (610) 853-3000
> > > >   +  If your life is a hard drive,     |  830 Blythe Avenue
> > > >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
> 19026
> > > >
> > > > ---------------------------(end of
> broadcast)---------------------------
> > > > TIP 5: Have you checked our extensive FAQ?
> > > >
> > > > http://www.postgresql.org/users-lounge/docs/faq.html
> > > >
> > > >
> > >
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> > >
> > --
> > Larry Rosenman                     http://www.lerctr.org/~ler
> > Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
> > US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
> >
> >
> >
> >
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
Olivier PRENANT         	Tel:	+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


Fri, 19 Apr 2002 13:04:16 +0200 (MET DST)
Olivier PRENANT <ohp@pyrenet.fr>
Re: [HACKERS] build of 7.2.1 on SCO Openserver andUnixware

OK, I will apply the patch as it current stands and wait for additional
patches.



---------------------------------------------------------------------------

Nicolas Bazin wrote:
> Well then it means that we will have to make a difference between Unixware
> 7.1.1 and OpenUnix 8.0.
> 
> ----- Original Message -----
> From: "Bruce Momjian" <pgman@candle.pha.pa.us>
> To: "Nicolas Bazin" <nbazin@ingenico.com.au>
> Cc: "Peter Eisentraut" <peter_e@gmx.net>; "Larry Rosenman" <ler@lerctr.org>;
> "PostgreSQL-patches" <pgsql-patches@postgresql.org>
> Sent: Friday, April 19, 2002 1:31 AM
> Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver and
> Unixware
> 
> 
> >
> > Sorry, here is an updated patch.  I didn't realize there were two QNX
> > tests in the file.
> >
> > The patch has:
> >
> > case  $host_platform in
> >     *-*-qnx* | *-*-sco3.2v5*)
> >         DIFFFLAGS=-b;;
> >     *)
> >         DIFFFLAGS=-w;;
> > esac
> >
> > Is this correct.  We don't need the sysv5?  It is my understanding that
> > sysv5 is much more than Open Server 8.
> >
> > --------------------------------------------------------------------------
> -
> >
> > Nicolas Bazin wrote:
> > > The patch from Bruce does not correct the proper thing. The original
> patch I
> > > submitted was :
> > > *** postgresql-7.2.1-rc/src/test/regress/pg_regress.sh Tue Mar 26
> 16:49:04
> > > 2002
> > > --- postgresql-7.2.1/src/test/regress/pg_regress.sh Tue Mar 26 17:03:39
> 2002
> > > ***************
> > > *** 173,179 ****
> > > # ----------
> > > case $host_platform in
> > > ! *-*-qnx*)
> > > DIFFFLAGS=-b;;
> > > *)
> > > DIFFFLAGS=-w;;
> > > --- 173,179 ----
> > > # ----------
> > > case $host_platform in
> > > ! *-*-qnx* | *-*-sco3.2v5* | *-*-sysv5)
> > > DIFFFLAGS=-b;;
> > > *)
> > > DIFFFLAGS=-w;;
> > >
> > > Because the diff tool that comes with Openserver or Unixware does not
> suppor
> > > the -w option but the -b option to remove blank characters.
> > > There is nothing wrong with unix sockets on both platforms.
> > >
> > > Nicolas
> > >
> > > ----- Original Message -----
> > > From: "Bruce Momjian" <pgman@candle.pha.pa.us>
> > > To: "Peter Eisentraut" <peter_e@gmx.net>
> > > Cc: "Larry Rosenman" <ler@lerctr.org>; "Nicolas Bazin"
> > > <nbazin@ingenico.com.au>; "PostgreSQL-patches"
> > > <pgsql-patches@postgresql.org>
> > > Sent: Thursday, April 18, 2002 1:15 PM
> > > Subject: Re: [PATCHES] [HACKERS] build of 7.2.1 on SCO Openserver and
> > > Unixware
> > >
> > >
> > > > Peter Eisentraut wrote:
> > > > > Bruce Momjian writes:
> > > > >
> > > > > > OK, new code is:
> > > > > >
> > > > > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > > > >                                   ^^^^^^^^^^^^^
> > > > >
> > > > > I would like to see an explanation for this.
> > > >
> > > > The patch section is below.  Not knowing the platform, I have no idea
> > > > why.
> > > >
> > > >   case $host_platform in
> > > > !     *-*-qnx* | *beos* | *-*-sco3.2v5*)
> > > >           unix_sockets=no;;
> > > >       *)
> > > >           unix_sockets=yes;;
> > > >
> > > > --
> > > >   Bruce Momjian                        |  http://candle.pha.pa.us
> > > >   pgman@candle.pha.pa.us               |  (610) 853-3000
> > > >   +  If your life is a hard drive,     |  830 Blythe Avenue
> > > >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
> 19026
> > > >
> > > > ---------------------------(end of
> broadcast)---------------------------
> > > > TIP 5: Have you checked our extensive FAQ?
> > > >
> > > > http://www.postgresql.org/users-lounge/docs/faq.html
> > > >
> > > >
> > >
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> > >
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 853-3000
> >   +  If your life is a hard drive,     |  830 Blythe Avenue
> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> >
> 
> 
> ----------------------------------------------------------------------------
> ----
> 
> 
> > Index: configure.in
> > ===================================================================
> > RCS file: /cvsroot/pgsql/configure.in,v
> > retrieving revision 1.178
> > diff -c -r1.178 configure.in
> > *** configure.in 14 Apr 2002 17:23:20 -0000 1.178
> > --- configure.in 18 Apr 2002 15:26:08 -0000
> > ***************
> > *** 696,703 ****
> >   AC_CHECK_LIB(util,     setproctitle)
> >   AC_CHECK_LIB(m,        main)
> >   AC_CHECK_LIB(dl,       main)
> > - AC_CHECK_LIB(socket,   main)
> >   AC_CHECK_LIB(nsl,      main)
> >   AC_CHECK_LIB(ipc,      main)
> >   AC_CHECK_LIB(IPC,      main)
> >   AC_CHECK_LIB(lc,       main)
> > --- 696,703 ----
> >   AC_CHECK_LIB(util,     setproctitle)
> >   AC_CHECK_LIB(m,        main)
> >   AC_CHECK_LIB(dl,       main)
> >   AC_CHECK_LIB(nsl,      main)
> > + AC_CHECK_LIB(socket,   main)
> >   AC_CHECK_LIB(ipc,      main)
> >   AC_CHECK_LIB(IPC,      main)
> >   AC_CHECK_LIB(lc,       main)
> > Index: src/interfaces/odbc/convert.c
> > ===================================================================
> > RCS file: /cvsroot/pgsql/src/interfaces/odbc/convert.c,v
> > retrieving revision 1.78
> > diff -c -r1.78 convert.c
> > *** src/interfaces/odbc/convert.c 1 Apr 2002 03:01:14 -0000 1.78
> > --- src/interfaces/odbc/convert.c 18 Apr 2002 15:26:23 -0000
> > ***************
> > *** 2717,2723 ****
> >   y = 0;
> >
> >   for (i = 1; i <= 3; i++)
> > ! y += (s[i] - 48) * (int) pow(8, 3 - i);
> >
> >   return y;
> >
> > --- 2717,2723 ----
> >   y = 0;
> >
> >   for (i = 1; i <= 3; i++)
> > ! y += (s[i] - '0') << (3  * (3 - i));
> >
> >   return y;
> >
> > ***************
> > *** 2740,2746 ****
> >   else
> >   val = s[i] - '0';
> >
> > ! y += val * (int) pow(16, 2 - i);
> >   }
> >
> >   return y;
> > --- 2740,2746 ----
> >   else
> >   val = s[i] - '0';
> >
> > ! y += val << (4 * (2 - i));
> >   }
> >
> >   return y;
> > ***************
> > *** 2795,2801 ****
> >
> >   for (i = 4; i > 1; i--)
> >   {
> > ! x[i] = (val & 7) + 48;
> >   val >>= 3;
> >   }
> >
> > --- 2795,2801 ----
> >
> >   for (i = 4; i > 1; i--)
> >   {
> > ! x[i] = (val & 7) + '0';
> >   val >>= 3;
> >   }
> >
> > Index: src/test/regress/pg_regress.sh
> > ===================================================================
> > RCS file: /cvsroot/pgsql/src/test/regress/pg_regress.sh,v
> > retrieving revision 1.23
> > diff -c -r1.23 pg_regress.sh
> > *** src/test/regress/pg_regress.sh 3 Jan 2002 21:52:05 -0000 1.23
> > --- src/test/regress/pg_regress.sh 18 Apr 2002 15:26:24 -0000
> > ***************
> > *** 173,179 ****
> >   # ----------
> >
> >   case $host_platform in
> > !     *-*-qnx*)
> >           DIFFFLAGS=-b;;
> >       *)
> >           DIFFFLAGS=-w;;
> > --- 173,179 ----
> >   # ----------
> >
> >   case $host_platform in
> > !     *-*-qnx* | *-*-sco3.2v5*)
> >           DIFFFLAGS=-b;;
> >       *)
> >           DIFFFLAGS=-w;;
> >
> 
> 
> ----------------------------------------------------------------------------
> ----
> 
> 
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
> 
> 
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 23 Apr 2002 12:51:38 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware
 
Updated version applied.  Thanks.

---------------------------------------------------------------------------


Nicolas Bazin wrote:
> Sorry for the package, but the following patch need to be applied to get the new verion compiled on SCO Openserver 5.0.5 and Unixware 7.1.1

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 23 Apr 2002 21:57:17 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: build of 7.2.1 on SCO Openserver and Unixware 7.1.1