@@ -3,7 +3,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL V7.0
33SCO UnixWare and OpenServer Specific
44TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
55=======================================================
6- last updated: $Date: 2000/08/26 19:34:24 $
6+ last updated: $Date: 2000/10/09 03:49:42 $
77
88current maintainer: Billy G. Allie (Bill.Allie@mug.org)
99original author: Andrew Merrill (andrew@compclass.com)
@@ -28,29 +28,28 @@ Topics:
2828***************************************************************************
2929*) Skunkware
3030
31- You should locate your copy of the SCO Skunkware CD. The Skunkware CD
32- is included with UnixWare 7 and current versions of OpenServer 5.
31+ You should locate your copy of the SCO Skunkware CD. The Skunkware CD is
32+ included with UnixWare 7 and current versions of OpenServer 5.
3333
3434Skunkware includes ready-to-install versions of many popular programs that
3535are available on the Internet. For example, gzip, gunzip, GNU make, flex,
3636and bison are all included.
3737
38- If you do not have this CD, the software on it
39- is available via anonymous ftp from ftp.sco.com/skunkware.
38+ If you do not have this CD, the software on it is available via anonymous
39+ ftp from ftp.sco.com/skunkware.
4040
4141For UnixWare 7.1, this CD is now labeled "Open License Software Supplement".
4242
43- Skunkware has different versions for UnixWare and
44- OpenServer. Make sure you install the correct version for your
45- operating system, except as noted below.
46-
43+ Skunkware has different versions for UnixWare and OpenServer. Make sure
44+ you install the correct version for your operating system, except as noted
45+ below.
4746
4847***************************************************************************
4948*) GNU Make
5049
51- You need to use the GNU make program, which is on the Skunkware CD.
52- By default, it installs as /usr/local/bin/make. To avoid confusion
53- with the SCO make program, you may want to rename GNU make to gmake.
50+ You need to use the GNU make program, which is on the Skunkware CD. By
51+ default, it installs as /usr/local/bin/make. To avoid confusion with the
52+ SCO make program, you may want to rename GNU make to gmake.
5453
5554
5655***************************************************************************
@@ -74,19 +73,19 @@ configure --without-CXX
7473***************************************************************************
7574*) Readline
7675
77- If you install the readline library, then psql (the PostgreSQL command
78- line SQL interpreter) remembers each command you type, and allows
79- you to use arrow keys to recall and edit previous commands. This is
80- very helpful, and is strongly recommended. The readline library is
81- on the Skunkware CD.
76+ If you install the readline library, then psql (the PostgreSQL command line
77+ SQL interpreter) remembers each command you type, and allows you to use
78+ arrow keys to recall and edit previous commands. This is very helpful, and
79+ is strongly recommended. The readline library is on the Skunkware CD.
8280
8381The readline library is not included on the UnixWare 7.1 Skunkware CD. If
84- you have the UnixWare 7.0.0 or 7.0.1 Skunkware CDs, you can install it
85- from there. Otherwise, try ftp.sco.com/skunkware.
82+ you have the UnixWare 7.0.0 or 7.0.1 Skunkware CDs, you can install it from
83+ there. Otherwise, try ftp.sco.com/skunkware.
8684
8785By default, readline installs into /usr/local/lib and /usr/local/include.
8886However, the PostgreSQL configure program will not find it there without
89- help. If you installed readline, then use the following options to configure:
87+ help. If you installed readline, then use the following options to
88+ configure:
9089
9190configure --with-libs=/usr/local/lib --with-includes=/usr/local/include
9291
@@ -117,41 +116,67 @@ Putting these together with the no-C++ and readline options from above:
117116*) Compiling PostgreSQL 7.0 with the UDK
118117
119118The program, backend/utils/adt/int8.c, tickles a compiler bug with in the
120- followingversion of the C compiler:
119+ followingversions (and probably others as well) of the C compiler:
121120
122- Optimizing C Compilation System (CCS) 3.2 08/18/98 (u701)
121+ Optimizing C Compilation System (CCS) 3.2 08/18/98
122+ Optimizing C Compilation System (CCS) 3.2 09/28/99
123123
124124If you encounter an error compiling backend/utils/adt/int8.c, please apply
125125the following patch:
126126
127127------------------------------8< CUT HERE >8------------------------------
128- ***./ src/backend/utils/adt/int8.c.origMon Apr 3 13:24:12 2000
129- ---./ src/backend/utils/adt/int8.cMon Apr 3 13:28:47 2000
128+ *** src/backend/utils/adt/int8.c.origSat Oct 7 20:48:17 2000
129+ --- src/backend/utils/adt/int8.cSat Oct 7 20:52:03 2000
130130***************
131- ***410,416 ****
132- if (* arg1 < 1)
133- * result = 0;
131+ ***489,495 ****
132+ if (arg1 < 1)
133+ result = 0;
134134 else
135- ! for (i =* arg1,* result = 1; i > 0; --i)
136- * result *= i;
135+ ! for (i = arg1, result = 1; i > 0; --i)
136+ result *= i;
137137
138- return result;
139- ---410,416 ----
140- if (* arg1 < 1)
141- * result = 0;
138+ PG_RETURN_INT64( result) ;
139+ ---489,495 ----
140+ if (arg1 < 1)
141+ result = 0;
142142 else
143- ! for (i = *arg1, *result = 1; 0 < i; --i)
144- *result *= i;
143+ ! for (i = arg1, result = 1; i; --i)
144+ result *= i;
145+
146+ PG_RETURN_INT64(result);
147+ ------------------------------8< CUT HERE >8------------------------------
148+
149+ The bind function in UnixWare 7.1+ has a problem when used with the AF_UNIX
150+ family. The following patch provides a work-around for the problem (thanks
151+ go to Oliver PRENANT <ohp@pyrenet.fre> for this patch).
152+
153+ ------------------------------8< CUT HERE >8------------------------------
154+ *** src/backend/libpq/pqcomm.c.origSun Oct 8 02:21:25 2000
155+ --- src/backend/libpq/pqcomm.cSun Oct 8 02:42:57 2000
156+ ***************
157+ *** 329,334 ****
158+ --- 329,341 ----
159+ return STATUS_ERROR;
160+ }
145161
146- return result;
162+ + /* Work around a bug in UnixWare 7.1.x - accept is not returning the
163+ + * correct family when the family is AF_UNIX.
164+ + */
165+ +
166+ + if (port->raddr.sa.sa_family == 0)
167+ + port->raddr.sa.sa_family = AF_UNIX;
168+ +
169+ /* fill in the server (local) address */
170+ addrlen = sizeof(port->laddr);
171+ if (getsockname(port->sock, (struct sockaddr *) & port->laddr,
147172------------------------------8< CUT HERE >8------------------------------
148173
149174***************************************************************************
150175*) Reading the PostgreSQL man pages on UnixWare
151176
152177By default, the PostgreSQL man pages are installed into /usr/local/pgsql/man.
153- By default, UnixWare does not look there for man pages, so you will not
154- be able to read them.
178+ By default, UnixWare does not look there for man pages, so you will not be
179+ able to read them.
155180
156181You need to make the following changes to access the PostgreSQL man pages
157182from UnixWare.