@@ -3,7 +3,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL V7.0
3
3
SCO UnixWare and OpenServer Specific
4
4
TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
5
5
=======================================================
6
- last updated: $Date: 2000/08/26 19:34:24 $
6
+ last updated: $Date: 2000/10/09 03:49:42 $
7
7
8
8
current maintainer: Billy G. Allie (Bill.Allie@mug.org)
9
9
original author: Andrew Merrill (andrew@compclass.com)
@@ -28,29 +28,28 @@ Topics:
28
28
***************************************************************************
29
29
*) Skunkware
30
30
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.
33
33
34
34
Skunkware includes ready-to-install versions of many popular programs that
35
35
are available on the Internet. For example, gzip, gunzip, GNU make, flex,
36
36
and bison are all included.
37
37
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.
40
40
41
41
For UnixWare 7.1, this CD is now labeled "Open License Software Supplement".
42
42
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.
47
46
48
47
***************************************************************************
49
48
*) GNU Make
50
49
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.
54
53
55
54
56
55
***************************************************************************
@@ -74,19 +73,19 @@ configure --without-CXX
74
73
***************************************************************************
75
74
*) Readline
76
75
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.
82
80
83
81
The 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.
86
84
87
85
By default, readline installs into /usr/local/lib and /usr/local/include.
88
86
However, 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:
90
89
91
90
configure --with-libs=/usr/local/lib --with-includes=/usr/local/include
92
91
@@ -117,41 +116,67 @@ Putting these together with the no-C++ and readline options from above:
117
116
*) Compiling PostgreSQL 7.0 with the UDK
118
117
119
118
The 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:
121
120
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
123
123
124
124
If you encounter an error compiling backend/utils/adt/int8.c, please apply
125
125
the following patch:
126
126
127
127
------------------------------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
130
130
***************
131
- ***410,416 ****
132
- if (* arg1 < 1)
133
- * result = 0;
131
+ ***489,495 ****
132
+ if (arg1 < 1)
133
+ result = 0;
134
134
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;
137
137
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;
142
142
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
+ }
145
161
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,
147
172
------------------------------8< CUT HERE >8------------------------------
148
173
149
174
***************************************************************************
150
175
*) Reading the PostgreSQL man pages on UnixWare
151
176
152
177
By 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.
155
180
156
181
You need to make the following changes to access the PostgreSQL man pages
157
182
from UnixWare.