Обсуждение: Second call for platform testing

Поиск

Список

Период

Сортировка

Second call for platform testing

От

Thomas Lockhart

Дата:

28 ноября 2001 г., 23:04:13

OK, the list is getting smaller fast (thanks for all of the responses!).
Here is what I have left currently (note the addition of NetBSD/sparc,
which I had inadvertently omitted from the first list):

BeOS         Cyril Velter
Linux/arm    Mark Knox
Linux/s390   Neale Ferguson
NetBSD/arm32 Patrick Welche
NetBSD/m68k  Bill Studenmund (will test)
NetBSD/sparc Matthew Green (left off the first list)
NetBSD/VAX   Tom I. Helbekkmo
QNX          (did I get a definitive report for 4.x already?)
SunOS        Tatsuo Ishii (old release; still relevant?)
Windows/Cygwin Daniel Horak (OK in serial test, trouble with parallel
test?)
Windows/native Magnus Hagander (clients only)

I'm curious about the Windows/Cygwin trouble, and if others see it too,
since the -cygwin mailing list seems to report happiness with 7.1.3.

Tatsuo, do you think that we should still track SunOS explicitly?

Are there any other platforms we are running on?
                      - Thomas


The following platforms have been reported as successfully running
PostgreSQL 7.2:

AIX          Andreas Zeugswetter (Tatsuo working on 5L?)
BSD/OS       Bruce
FreeBSD      Chris Kings-Lynne
HPUX         Tom (anyone tested 11.0 or higher?)
IRIX         Luis Amigo
Linux/Alpha  Tom
Linux/MIPS   Hisao Shibuya
Linux/PPC    Tom
Linux/sparc  Doug McNaught
Linux/x86    Thomas (and many others ;)
MacOS-X      Gavin Sherry
NetBSD/Alpha Thomas Thai
NetBSD/PPC   Bill Studenmund
NetBSD/x86   Bill Studenmund
OpenBSD/sparc Brandon Palmer
OpenBSD/x86  Brandon Palmer
SCO OpenUnix Larry Rosenman
Solaris/sparc Andrew Sullivan
Solaris/x86  Martin Renters
Tru64        Alessio Bragadini (trouble with 5.1?)

Re: Second call for platform testing

От

Joe Conway

Дата:

29 ноября 2001 г., 00:04:15

Thomas Lockhart wrote:

> The following platforms have been reported as successfully running
> PostgreSQL 7.2:
> 
> AIX          Andreas Zeugswetter (Tatsuo working on 5L?)
> BSD/OS       Bruce
> FreeBSD      Chris Kings-Lynne
> HPUX         Tom (anyone tested 11.0 or higher?)

Are you still looking for HPUX 11.0+ ? I can arrange for access to one 
if we still need it (gcc though, I don't have access to HP's compiler).

-- Joe

Re: Second call for platform testing

От

"Cyril VELTER"

Дата:

29 ноября 2001 г., 05:34:21

   I just tested the BeOS port (and updated the regression test database).
   Two little tweaks are needed to make it compile and install :
       * int8/uint8 and int64/uint64 are not detected properly by configure
(they are declared in SupportDefs.h on beos).       * data dir is created with group and world access, preventing
postmaster from starting (a simple chmod og-rwx will do)
   The regression test pass without any error.
           cyril

> OK, the list is getting smaller fast (thanks for all of the responses!).
> Here is what I have left currently (note the addition of NetBSD/sparc,
> which I had inadvertently omitted from the first list):
>
> BeOS         Cyril Velter
> Linux/arm    Mark Knox
> Linux/s390   Neale Ferguson
> NetBSD/arm32 Patrick Welche
> NetBSD/m68k  Bill Studenmund (will test)
> NetBSD/sparc Matthew Green (left off the first list)
> NetBSD/VAX   Tom I. Helbekkmo
> QNX          (did I get a definitive report for 4.x already?)
> SunOS        Tatsuo Ishii (old release; still relevant?)
> Windows/Cygwin Daniel Horak (OK in serial test, trouble with parallel
> test?)
> Windows/native Magnus Hagander (clients only)
>
> I'm curious about the Windows/Cygwin trouble, and if others see it too,
> since the -cygwin mailing list seems to report happiness with 7.1.3.
>
> Tatsuo, do you think that we should still track SunOS explicitly?
>
> Are there any other platforms we are running on?
>
>                        - Thomas
>
>
> The following platforms have been reported as successfully running
> PostgreSQL 7.2:
>
> AIX          Andreas Zeugswetter (Tatsuo working on 5L?)
> BSD/OS       Bruce
> FreeBSD      Chris Kings-Lynne
> HPUX         Tom (anyone tested 11.0 or higher?)
> IRIX         Luis Amigo
> Linux/Alpha  Tom
> Linux/MIPS   Hisao Shibuya
> Linux/PPC    Tom
> Linux/sparc  Doug McNaught
> Linux/x86    Thomas (and many others ;)
> MacOS-X      Gavin Sherry
> NetBSD/Alpha Thomas Thai
> NetBSD/PPC   Bill Studenmund
> NetBSD/x86   Bill Studenmund
> OpenBSD/sparc Brandon Palmer
> OpenBSD/x86  Brandon Palmer
> SCO OpenUnix Larry Rosenman
> Solaris/sparc Andrew Sullivan
> Solaris/x86  Martin Renters
> Tru64        Alessio Bragadini (trouble with 5.1?)

Re: Second call for platform testing

От

Thomas Lockhart

Дата:

29 ноября 2001 г., 08:04:20

> Are you still looking for HPUX 11.0+ ? I can arrange for access to one
> if we still need it (gcc though, I don't have access to HP's compiler).

Yes, that would be great. 10.20 is pretty old afaik...
                   - Thomas

Re: Second call for platform testing

От

Thomas Lockhart

Дата:

29 ноября 2001 г., 08:15:09

>     I just tested the BeOS port (and updated the regression test database).
>     Two little tweaks are needed to make it compile and install :
>         * int8/uint8 and int64/uint64 are not detected properly by configure
> (they are declared in SupportDefs.h on beos).
>         * data dir is created with group and world access, preventing
> postmaster from starting (a simple chmod og-rwx will do)
>     The regression test pass without any error.

Great! Can the int8 detection be helped with a patch to get the right
include file?
                - Thomas

Re: Second call for platform testing

От

Larry Rosenman

Дата:

29 ноября 2001 г., 08:33:12

SCO OpenUNIX should be Caldera OpenUNIX....

Thanks,
LER

* Thomas Lockhart <lockhart@fourpalms.org> [011128 22:07]:
> OK, the list is getting smaller fast (thanks for all of the responses!).
> Here is what I have left currently (note the addition of NetBSD/sparc,
> which I had inadvertently omitted from the first list):
> 
> BeOS         Cyril Velter
> Linux/arm    Mark Knox
> Linux/s390   Neale Ferguson
> NetBSD/arm32 Patrick Welche
> NetBSD/m68k  Bill Studenmund (will test)
> NetBSD/sparc Matthew Green (left off the first list)
> NetBSD/VAX   Tom I. Helbekkmo
> QNX          (did I get a definitive report for 4.x already?)
> SunOS        Tatsuo Ishii (old release; still relevant?)
> Windows/Cygwin Daniel Horak (OK in serial test, trouble with parallel
> test?)
> Windows/native Magnus Hagander (clients only)
> 
> I'm curious about the Windows/Cygwin trouble, and if others see it too,
> since the -cygwin mailing list seems to report happiness with 7.1.3.
> 
> Tatsuo, do you think that we should still track SunOS explicitly?
> 
> Are there any other platforms we are running on?
> 
>                        - Thomas
> 
> 
> The following platforms have been reported as successfully running
> PostgreSQL 7.2:
> 
> AIX          Andreas Zeugswetter (Tatsuo working on 5L?)
> BSD/OS       Bruce
> FreeBSD      Chris Kings-Lynne
> HPUX         Tom (anyone tested 11.0 or higher?)
> IRIX         Luis Amigo
> Linux/Alpha  Tom
> Linux/MIPS   Hisao Shibuya
> Linux/PPC    Tom
> Linux/sparc  Doug McNaught
> Linux/x86    Thomas (and many others ;)
> MacOS-X      Gavin Sherry
> NetBSD/Alpha Thomas Thai
> NetBSD/PPC   Bill Studenmund
> NetBSD/x86   Bill Studenmund
> OpenBSD/sparc Brandon Palmer
> OpenBSD/x86  Brandon Palmer
> SCO OpenUnix Larry Rosenman
> Solaris/sparc Andrew Sullivan
> Solaris/x86  Martin Renters
> Tru64        Alessio Bragadini (trouble with 5.1?)
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
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

Re: Second call for platform testing

От

Thomas Lockhart

Дата:

29 ноября 2001 г., 09:04:21

> SCO OpenUNIX should be Caldera OpenUNIX....

Got it. Thanks.
                   - Thomas

Re: Second call for platform testing

От

"Cyril VELTER"

Дата:

29 ноября 2001 г., 11:04:21

> >     I just tested the BeOS port (and updated the regression test
database).
> >     Two little tweaks are needed to make it compile and install :
> >         * int8/uint8 and int64/uint64 are not detected properly by
configure
> > (they are declared in SupportDefs.h on beos).
> >         * data dir is created with group and world access, preventing
> > postmaster from starting (a simple chmod og-rwx will do)
> >     The regression test pass without any error.
>
> Great! Can the int8 detection be helped with a patch to get the right
> include file?
   I think it can, but I'm not familiar at all with configure script. If
someone can point me where the change should be made, I'll make and test a
patch.
   What modification should be made to configure.in to make it include
SupportDefs.h when testing for int8 uint8 int64 and uint64 size ?
       cyril

Re: Second call for platform testing

От

"Zeugswetter Andreas SB SD"

Дата:

29 ноября 2001 г., 11:34:21

>     What modification should be made to configure.in to make it
include
> SupportDefs.h when testing for int8 uint8 int64 and uint64 size ?

Is SupportDefs.h actually (probably implicitly) included by the
PostgreSQL
source ? Because if it is not, PostgreSQL is quite happy not finding
them in 
configure.

Not finding them is only a problem if you get redefines during
compilation
(and if your compiler then treats that as fatal).

Andreas

Re: Second call for platform testing

От

Bruce Momjian

Дата:

29 ноября 2001 г., 11:55:08

> 
> >     What modification should be made to configure.in to make it
> include
> > SupportDefs.h when testing for int8 uint8 int64 and uint64 size ?
> 
> Is SupportDefs.h actually (probably implicitly) included by the
> PostgreSQL
> source ? Because if it is not, PostgreSQL is quite happy not finding
> them in 
> configure.
> 
> Not finding them is only a problem if you get redefines during
> compilation
> (and if your compiler then treats that as fatal).

Good point.  Also, a mixed-case include file is quite unusual.  One idea
if you can't get it working is to either include "SupportDefs.h" for
BeOS in configure.in and c.h, or check the top of SupportDefs.h.  Often
there is an #ifdef at the top to prevent the file from being included
twice.  If you define that in c.h for BeOS, the include SupportDefs.h
will never be used and we can use our own defines for uint8/uint64.

FYI, this test was added for AIX in recent weeks because it had similar
trouble.

Here is the little snippet of code from configure to test for uint8:#include "confdefs.h"#include <stdio.h>main(){
FILE*f=fopen("conftestval", "w");  if (!f) exit(1);  fprintf(f, "%d\n", sizeof(uint8));  exit(0);}
 

Now, we would normally modify configure.in, but you can play with
configure until you get it to work, let us know, and we can modify
configure.in, run autoconf, make any needed additions to c.h, and get it
into CVS.

--  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,
Pennsylvania19026

Re: Second call for platform testing

От

Tom Lane

Дата:

29 ноября 2001 г., 13:34:34

"Cyril VELTER" <cyril.velter@libertysurf.fr> writes:
>     What modification should be made to configure.in to make it include
> SupportDefs.h when testing for int8 uint8 int64 and uint64 size ?

This looks like a bit of a pain.  We're currently using AC_CHECK_SIZEOF
to make those probes, apparently because it's the closest standard macro
to what we want.  But it's not close enough.  It doesn't include
anything except <stdio.h>.  I don't think we can fix this except by
making our own macro.  Peter, any opinion about how to do it?

(If we do make our own macro, we could change the output to be something
more reasonable, like #defining HAVE_UINT8 rather than claiming
"sizeof uint8 = 0", which is sure to confuse people.)
        regards, tom lane

Re: Second call for platform testing

От

"Cyril VELTER"

Дата:

29 ноября 2001 г., 13:55:18

>>     What modification should be made to configure.in to make it include
>> SupportDefs.h when testing for int8 uint8 int64 and uint64 size ?

>Is SupportDefs.h actually (probably implicitly) included by the
>PostgreSQL
>source ? Because if it is not, PostgreSQL is quite happy not finding
>them in
>configure.

>Not finding them is only a problem if you get redefines during
>compilation
>(and if your compiler then treats that as fatal).

SupportDefs.h is conditionaly included in c.h so everything is Ok when I
compile the backend, but when configure try to figure out the size of int8
... they are not defined.
   May be SupportDefs.h should be included from another file ?

       cyril

Re: Second call for platform testing

От

Peter Eisentraut

Дата:

29 ноября 2001 г., 14:03:09

Cyril VELTER writes:

>
>     I just tested the BeOS port (and updated the regression test database).
>
>     Two little tweaks are needed to make it compile and install :
>
>         * int8/uint8 and int64/uint64 are not detected properly by configure
> (they are declared in SupportDefs.h on beos).

Well, that was the end of that bright idea.  There's no way to tell
AC_CHECK_SIZEOF what header files to consider.  We need to put back the
#ifdef __BEOS__, it seems.

>         * data dir is created with group and world access, preventing
> postmaster from starting (a simple chmod og-rwx will do)

What does the shell do with the umask call in initdb?

-- 
Peter Eisentraut   peter_e@gmx.net

Re: Second call for platform testing

От

Bruce Momjian

Дата:

29 ноября 2001 г., 14:25:17

> "Cyril VELTER" <cyril.velter@libertysurf.fr> writes:
> >     What modification should be made to configure.in to make it include
> > SupportDefs.h when testing for int8 uint8 int64 and uint64 size ?
> 
> This looks like a bit of a pain.  We're currently using AC_CHECK_SIZEOF
> to make those probes, apparently because it's the closest standard macro
> to what we want.  But it's not close enough.  It doesn't include
> anything except <stdio.h>.  I don't think we can fix this except by
> making our own macro.  Peter, any opinion about how to do it?

I was wondering where that bizarre fopen()/fprintf() in the test code
came from.  It looked strange.  Now I know why;  it came from autoconf.

--  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,
Pennsylvania19026

Re: Second call for platform testing

От

"Cyril VELTER"

Дата:

29 ноября 2001 г., 15:04:30

> >         * data dir is created with group and world access, preventing
> > postmaster from starting (a simple chmod og-rwx will do)
>
> What does the shell do with the umask call in initdb?
       I will look at it (I'm not on a beos box right now), but as BeOS is
not a true multiuser system, he is probably faulty here.
       cyril

Re: Second call for platform testing

От

Joe Conway

Дата:

29 ноября 2001 г., 15:34:34

Thomas Lockhart wrote:

>>Are you still looking for HPUX 11.0+ ? I can arrange for access to one
>>if we still need it (gcc though, I don't have access to HP's compiler).
>>
> 
> Yes, that would be great. 10.20 is pretty old afaik...
> 
>                     - Thomas
> 
> 

I ran into a problem on HPUX 11 right off with:

===============================
configure --enable-debug
.
.
.
checking for struct sockaddr_un... yes
checking for int timezone... yes
checking types of arguments for accept()... configure: error: could not 
determine argument types

===============================

I won't pretend to be very knowledgable about HPUX or configure, but it 
looks like the following in configure is where it dies:

===============================

else     for ac_cv_func_accept_arg1 in 'int' 'unsigned int'; do     for ac_cv_func_accept_arg2 in 'struct sockaddr *'
'conststruct 

sockaddr *' 'void *'; do      for ac_cv_func_accept_arg3 in 'int' 'size_t' 'socklen_t' 
'unsigned int' 'void'; do       cat > conftest.$ac_ext <<EOF

=======================================

and here's what the HPUX man page says:

=======================================
accept(2)
 NAME      accept - accept a connection on a socket
 SYNOPSIS      #include <sys/socket.h>
    AF_CCITT only      #include <x25/x25addrstr.h>
      int accept(int s, void *addr, int *addrlen);
    _XOPEN_SOURCE_EXTENDED only (UNIX 98)      int accept(int s, struct sockaddr *addr, socklen_t *addrlen);

=======================================

so it looks like configure expects the third argument to be (int), when 
on HPUX 11 the third argument is (int *).

Any ideas what I'm doing wrong?

-- Joe

Re: Second call for platform testing

От

Tom Lane

Дата:

29 ноября 2001 г., 16:25:18

Joe Conway <joseph.conway@home.com> writes:
> I ran into a problem on HPUX 11 right off with:

That's odd, considering that someone else reported 7.1 worked fine on
HPUX 11, and we haven't changed this configure test since then.

> so it looks like configure expects the third argument to be (int), when 
> on HPUX 11 the third argument is (int *).

No, the macro knows that the third argument is pointer-to-something;
it's trying to figure out pointer-to-what.

> Any ideas what I'm doing wrong?

What had configure selected so far for compiler, cflags, etc?  Maybe
it's blowing the game at that stage.  Or maybe the test is failing to
include all the needed include files to define these datatypes.

In general, the config.log output is a good thing to post when puzzled
by configure problems.
        regards, tom lane

Re: Second call for platform testing

От

Tom Lane

Дата:

29 ноября 2001 г., 18:33:09

Joe Conway <joseph.conway@home.com> writes:
> ... So the error I reported 
> last time is actually from the bundled compiler.

Which, unless HP has reconsidered since HPUX 10, is a deliberately
crippled K&R (no ANSI features) compiler.  It's no wonder the configure
run failed; I guess failing right at this point is happenstance, though
it could not have gotten further since this test depends on ANSI
prototypes.

> configure:1361: checking whether the C compiler (cc -Ae +O2 ) works
> configure:1377: cc -Ae -o conftest +O2   conftest.c  1>&5
> (Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
> (Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.

It's a shame configure hides all these useful messages down inside
config.log.

I wonder whether we shouldn't make the bare "does it work" test include
verification that ANSI-style prototypes are supported.

> So I added /opt/gcc/bin to my PATH, and got a different error once gcc 
> was detected.

> configure:1243: checking whether the C compiler (gcc  ) works
> configure:1259: gcc -o conftest    conftest.c  1>&5
> as: warning 2: Unknown option "--traditional-format" ignored.
> as: "/var/tmp/cceTg0Kd.s", line 15: error 1052: Directive name not recognized - NSUBSPA

This looks like your gcc installation is broken: specifically, I'll bet
it's trying to use HP's assembler rather than gas.  You really want the
GNU toolchain (binutils package) underneath gcc.  The gcc-to-HP-as
configuration has never worked for me (though I have to admit I haven't
tried in a long time).

In the meantime, try it with HP's real compiler (set CC=cc for configure).
        regards, tom lane

Re: Second call for platform testing

От

Hiroshi Inoue

Дата:

29 ноября 2001 г., 20:04:30

Thomas Lockhart wrote:
> 
> OK, the list is getting smaller fast (thanks for all of the responses!).

I got a regression test result from Hiroshi Saito on UNIX_System_V ews4800 4.2MP 4.2 R4000 r4000.

=======================10 of 79 tests failed.
========================
    int8                 ... FAILED    abstime              ... FAILED    tinterval            ... FAILED
test geometry             ... FAILED
test horology             ... FAILED    create_index         ... FAILED
test sanity_check         ... FAILED
test select               ... FAILED    subselect            ... FAILED    union                ... FAILED

Seems INT64_IS_BUSTED, old PST ... etc and

*** ./expected/create_index.out    Tue Aug 28 08:23:34 JST 2001
--- ./results/create_index.out    Fri Nov 30 00:28:22 JST 2001
***************
*** 35,44 ****
--- 35,47 ---- -- CREATE INDEX onek2_u1_prtl ON onek2 USING btree(unique1 int4_ops)     where unique1 < 20 or unique1 >
980;
+ ERROR:  AllocSetFree: cannot find block containing chunk 4f64f0 CREATE INDEX onek2_u2_prtl ON onek2 USING
btree(unique2int4_ops)     where stringu1 < 'B';
 
+ ERROR:  AllocSetFree: cannot find block containing chunk 4f6390 CREATE INDEX onek2_stu1_prtl ON onek2 USING
btree(stringu1name_ops)     where onek2.stringu1 >= 'J' and onek2.stringu1 < 'K';
 
+ ERROR:  AllocSetFree: cannot find block containing chunk 4f6740 -- -- RTREE -- 

regards,
Hiroshi Inoue

Re: Second call for platform testing

От

"Christopher Kings-Lynne"

Дата:

29 ноября 2001 г., 20:33:08

Has someone thought about getting a sourceforge account for postgres or
something?  Even if we don't use their CVS and facilities, I wonder if we
can use their compile farm for platform testing?

Actually, maybe the phpPgAdmin admins could test it for us on the compile
farm, as they should have access...

Chris

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Cyril VELTER
> Sent: Thursday, 29 November 2001 6:26 PM
> To: PostgreSQL Hackers Mailing List
> Cc: Bruno G. Albuquerque
> Subject: Re: [HACKERS] Second call for platform testing
>
>
>
>     I just tested the BeOS port (and updated the regression test
> database).
>
>     Two little tweaks are needed to make it compile and install :
>
>         * int8/uint8 and int64/uint64 are not detected properly
> by configure
> (they are declared in SupportDefs.h on beos).
>         * data dir is created with group and world access, preventing
> postmaster from starting (a simple chmod og-rwx will do)
>
>     The regression test pass without any error.
>
>             cyril
>
> > OK, the list is getting smaller fast (thanks for all of the responses!).
> > Here is what I have left currently (note the addition of NetBSD/sparc,
> > which I had inadvertently omitted from the first list):
> >
> > BeOS         Cyril Velter
> > Linux/arm    Mark Knox
> > Linux/s390   Neale Ferguson
> > NetBSD/arm32 Patrick Welche
> > NetBSD/m68k  Bill Studenmund (will test)
> > NetBSD/sparc Matthew Green (left off the first list)
> > NetBSD/VAX   Tom I. Helbekkmo
> > QNX          (did I get a definitive report for 4.x already?)
> > SunOS        Tatsuo Ishii (old release; still relevant?)
> > Windows/Cygwin Daniel Horak (OK in serial test, trouble with parallel
> > test?)
> > Windows/native Magnus Hagander (clients only)
> >
> > I'm curious about the Windows/Cygwin trouble, and if others see it too,
> > since the -cygwin mailing list seems to report happiness with 7.1.3.
> >
> > Tatsuo, do you think that we should still track SunOS explicitly?
> >
> > Are there any other platforms we are running on?
> >
> >                        - Thomas
> >
> >
> > The following platforms have been reported as successfully running
> > PostgreSQL 7.2:
> >
> > AIX          Andreas Zeugswetter (Tatsuo working on 5L?)
> > BSD/OS       Bruce
> > FreeBSD      Chris Kings-Lynne
> > HPUX         Tom (anyone tested 11.0 or higher?)
> > IRIX         Luis Amigo
> > Linux/Alpha  Tom
> > Linux/MIPS   Hisao Shibuya
> > Linux/PPC    Tom
> > Linux/sparc  Doug McNaught
> > Linux/x86    Thomas (and many others ;)
> > MacOS-X      Gavin Sherry
> > NetBSD/Alpha Thomas Thai
> > NetBSD/PPC   Bill Studenmund
> > NetBSD/x86   Bill Studenmund
> > OpenBSD/sparc Brandon Palmer
> > OpenBSD/x86  Brandon Palmer
> > SCO OpenUnix Larry Rosenman
> > Solaris/sparc Andrew Sullivan
> > Solaris/x86  Martin Renters
> > Tru64        Alessio Bragadini (trouble with 5.1?)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

Re: Second call for platform testing

От

Tom Lane

Дата:

29 ноября 2001 г., 20:55:19

Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> I got a regression test result from Hiroshi Saito on
>   UNIX_System_V ews4800 4.2MP 4.2 R4000 r4000.

> Seems INT64_IS_BUSTED, old PST ... etc and

> *** ./expected/create_index.out    Tue Aug 28 08:23:34 JST 2001
> --- ./results/create_index.out    Fri Nov 30 00:28:22 JST 2001
> ***************
> *** 35,44 ****
> --- 35,47 ----
>   --
>   CREATE INDEX onek2_u1_prtl ON onek2 USING btree(unique1 int4_ops)
>       where unique1 < 20 or unique1 > 980;
> + ERROR:  AllocSetFree: cannot find block containing chunk 4f64f0
>   CREATE INDEX onek2_u2_prtl ON onek2 USING btree(unique2 int4_ops)
>       where stringu1 < 'B';
> + ERROR:  AllocSetFree: cannot find block containing chunk 4f6390
>   CREATE INDEX onek2_stu1_prtl ON onek2 USING btree(stringu1 name_ops)
>       where onek2.stringu1 >= 'J' and onek2.stringu1 < 'K';
> + ERROR:  AllocSetFree: cannot find block containing chunk 4f6740

Interesting.  Something nonportable in the partial index support,
perhaps?

Would you ask him to compile with debug support, set a breakpoint at
elog(), and get a backtrace from the point of the error?  It'll probably
work to execute any one of those commands by hand in the regression
database, so he doesn't need to try to attach to a regression testing
backend on the fly.  Just start psql, attach gdb to its backend, set the
breakpoint, and then run the create index command.
        regards, tom lane

Re: Second call for platform testing

От

Tom Lane

Дата:

29 ноября 2001 г., 21:04:29

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Has someone thought about getting a sourceforge account for postgres or
> something?  Even if we don't use their CVS and facilities, I wonder if we
> can use their compile farm for platform testing?

Hardly need a project account.  I have a personal account at
sourceforge, and have used it (fairly recently, even) to run tests on
their compile farm.  They don't presently have all that wide a range of
stuff available however.  Let's see ....
               lqqqqqqqqChoose compile farm server...qqqqqqqqqk               x A. [x86] Linux 2.2 (Debian 2.2)
    x               x C. [x86] FreeBSD (4.3-RELEASE)               x               x
         x               x G. [Alpha] Linux 2.2 (Debian 2.2)            x               x
              x               x I. [PPC - G4] MacOS X 10.1 #1 **NEW**        x               x J. [PPC - G4] MacOS X
10.1#2 **NEW**        x               x K. [PPC - RS/6000]  Linux 2.2 (Debian 2.2)   x               x
                           x               x L. [Sparc - Ultra60] Linux 2.2 (Debian 2.2)  x               x M. [Sparc -
R220]Sun Solaris (8) #1         x               x N. [Sparc - R220] Sun Solaris (8) #2         x               x O.
[Sparc- R220] Sun Solaris (8) #3         x               x P. [Sparc - R220] Sun Solaris (8) #4         x
x                                             x               x Exit                                         x
    mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
 

With the possible exception of the Linux/Alpha box, there's nothing
there that we don't have covered already, is there?
        regards, tom lane

Re: Second call for platform testing

От

"Christopher Kings-Lynne"

Дата:

29 ноября 2001 г., 21:25:17

Fair enough.

Chris

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Friday, 30 November 2001 9:55 AM
> To: Christopher Kings-Lynne
> Cc: PostgreSQL Hackers Mailing List
> Subject: Re: [HACKERS] Second call for platform testing 
> 
> 
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > Has someone thought about getting a sourceforge account for postgres or
> > something?  Even if we don't use their CVS and facilities, I 
> wonder if we
> > can use their compile farm for platform testing?
> 
> Hardly need a project account.  I have a personal account at
> sourceforge, and have used it (fairly recently, even) to run tests on
> their compile farm.  They don't presently have all that wide a range of
> stuff available however.  Let's see ....
> 
>                 lqqqqqqqqChoose compile farm server...qqqqqqqqqk
>                 x A. [x86] Linux 2.2 (Debian 2.2)              x
>                 x C. [x86] FreeBSD (4.3-RELEASE)               x
>                 x                                              x
>                 x G. [Alpha] Linux 2.2 (Debian 2.2)            x
>                 x                                              x
>                 x I. [PPC - G4] MacOS X 10.1 #1 **NEW**        x
>                 x J. [PPC - G4] MacOS X 10.1 #2 **NEW**        x
>                 x K. [PPC - RS/6000]  Linux 2.2 (Debian 2.2)   x
>                 x                                              x
>                 x L. [Sparc - Ultra60] Linux 2.2 (Debian 2.2)  x
>                 x M. [Sparc - R220] Sun Solaris (8) #1         x
>                 x N. [Sparc - R220] Sun Solaris (8) #2         x
>                 x O. [Sparc - R220] Sun Solaris (8) #3         x
>                 x P. [Sparc - R220] Sun Solaris (8) #4         x
>                 x                                              x
>                 x Exit                                         x
>                 mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
> 
> With the possible exception of the Linux/Alpha box, there's nothing
> there that we don't have covered already, is there?
> 
>             regards, tom lane
>

Re: Second call for platform testing

От

Joe Conway

Дата:

29 ноября 2001 г., 22:04:28

Tom Lane wrote:

>>configure:1243: checking whether the C compiler (gcc  ) works
>>configure:1259: gcc -o conftest    conftest.c  1>&5
>>as: warning 2: Unknown option "--traditional-format" ignored.
>>as: "/var/tmp/cceTg0Kd.s", line 15: error 1052: Directive name not recognized - NSUBSPA
>>
> 
> This looks like your gcc installation is broken: specifically, I'll bet
> it's trying to use HP's assembler rather than gas.  You really want the
> GNU toolchain (binutils package) underneath gcc.  The gcc-to-HP-as
> configuration has never worked for me (though I have to admit I haven't
> tried in a long time).
> 
> In the meantime, try it with HP's real compiler (set CC=cc for configure).

As usual Tom, you're right on the mark!

The HP compiler on this machine is in fact the K&R/non-ANSI bundled 
compiler. Unfortunately, the real compiler is not available -- i.e. we 
have not purchased it.

I did get binutils installed though, and was able to run configure and 
gmake. However, 'gmake check' seems to hang at:

parallel group (20 tests):  lseg point

I have a copy of gdb which has not been installed yet. Tomorrow I'll ask 
our unix admin to install it for me so I can drill down to the problem 
code. Any other thoughts in the meantime?

FWIW, the server is a new A Class HP:
$ uname -a
HP-UX csdoap2 B.11.00 A 9000/800 594720518 two-user license

Thanks,

Joe

Re: Second call for platform testing

От

Tom Lane

Дата:

29 ноября 2001 г., 22:45:16

Joe Conway <joseph.conway@home.com> writes:
> I did get binutils installed though, and was able to run configure and 
> gmake. However, 'gmake check' seems to hang at:

> parallel group (20 tests):  lseg point

That one's in the FAQ ;-).  Evidently HP still hasn't fixed that sh bug
as of 11.0.  Should work if you use ksh instead, viz
gmake SHELL=/bin/ksh check
        regards, tom lane

Re: Second call for platform testing

От

Joe Conway

Дата:

30 ноября 2001 г., 01:55:24

Tom Lane wrote:

> That one's in the FAQ ;-).  Evidently HP still hasn't fixed that sh bug
> as of 11.0.  Should work if you use ksh instead, viz
>
>     gmake SHELL=/bin/ksh check
>

Correct again (not that I ever doubted you)! Sorry, I should have known
to look at the platform FAQ.

And after all that, the results:

====================================================
  2 of 79 tests failed, 1 of these failures ignored.
====================================================

geometry and random failed. The diffs are attached. The geometry diffs
all look to be 0 vs -0.

Again, for reference:
$ model
9000/800/A500-44
$ uname -a
HP-UX csdoap2 B.11.00 A 9000/800

Joe
*** ./expected/geometry-positive-zeros.out    Tue Sep 12 14:07:16 2000
--- ./results/geometry.out    Thu Nov 29 22:23:13 2001
***************
*** 114,120 ****
          | (5.1,34.5) | [(1,2),(3,4)]                 | (3,4)
          | (-5,-12)   | [(1,2),(3,4)]                 | (1,2)
          | (10,10)    | [(1,2),(3,4)]                 | (3,4)
!         | (0,0)      | [(0,0),(6,6)]                 | (0,0)
          | (-10,0)    | [(0,0),(6,6)]                 | (0,0)
          | (-3,4)     | [(0,0),(6,6)]                 | (0.5,0.5)
          | (5.1,34.5) | [(0,0),(6,6)]                 | (6,6)
--- 114,120 ----
          | (5.1,34.5) | [(1,2),(3,4)]                 | (3,4)
          | (-5,-12)   | [(1,2),(3,4)]                 | (1,2)
          | (10,10)    | [(1,2),(3,4)]                 | (3,4)
!         | (0,0)      | [(0,0),(6,6)]                 | (-0,0)
          | (-10,0)    | [(0,0),(6,6)]                 | (0,0)
          | (-3,4)     | [(0,0),(6,6)]                 | (0.5,0.5)
          | (5.1,34.5) | [(0,0),(6,6)]                 | (6,6)
***************
*** 224,233 ****
   twentyfour |          rotation
  ------------+-----------------------------
              | (0,0),(0,0)
!             | (0,0),(-20,-20)
!             | (0,2),(-14,0)
              | (0,79.2),(-58.8,0)
!             | (14,0),(0,-34)
              | (0,40),(0,0)
              | (0,0),(0,0)
              | (-10,-10),(-30,-30)
--- 224,233 ----
   twentyfour |          rotation
  ------------+-----------------------------
              | (0,0),(0,0)
!             | (-0,0),(-20,-20)
!             | (-0,2),(-14,0)
              | (0,79.2),(-58.8,0)
!             | (14,-0),(0,-34)
              | (0,40),(0,0)
              | (0,0),(0,0)
              | (-10,-10),(-30,-30)
***************
*** 254,264 ****
     WHERE (p.f1 <-> point '(0,0)') >= 1;
   twenty |                                     rotation
  --------+-----------------------------------------------------------------------------------
!         | (0,0),(-0.2,-0.2)
          | (-0.1,-0.1),(-0.3,-0.3)
          | (-0.25,-0.25),(-0.25,-0.35)
          | (-0.3,-0.3),(-0.3,-0.3)
!         | (0.08,0),(0,-0.56)
          | (0.12,-0.28),(0.04,-0.84)
          | (0.26,-0.7),(0.1,-0.82)
          | (0.12,-0.84),(0.12,-0.84)
--- 254,264 ----
     WHERE (p.f1 <-> point '(0,0)') >= 1;
   twenty |                                     rotation
  --------+-----------------------------------------------------------------------------------
!         | (0,-0),(-0.2,-0.2)
          | (-0.1,-0.1),(-0.3,-0.3)
          | (-0.25,-0.25),(-0.25,-0.35)
          | (-0.3,-0.3),(-0.3,-0.3)
!         | (0.08,-0),(0,-0.56)
          | (0.12,-0.28),(0.04,-0.84)
          | (0.26,-0.7),(0.1,-0.82)
          | (0.12,-0.84),(0.12,-0.84)
***************
*** 266,272 ****
          | (0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
          | (0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
          | (0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
!         | (0,0.0828402366863905),(-0.201183431952663,0)
          | (-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
          | (-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
          | (-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)
--- 266,272 ----
          | (0.0976764836465887,-0.0241724631246608),(0.0325588278821962,-0.0725173893739825)
          | (0.109762715208919,-0.0562379754328844),(0.0813970697054906,-0.0604311578116521)
          | (0.0976764836465887,-0.0725173893739825),(0.0976764836465887,-0.0725173893739825)
!         | (-0,0.0828402366863905),(-0.201183431952663,0)
          | (-0.100591715976331,0.124260355029586),(-0.301775147928994,0.0414201183431953)
          | (-0.251479289940828,0.103550295857988),(-0.322485207100592,0.0739644970414201)
          | (-0.301775147928994,0.124260355029586),(-0.301775147928994,0.124260355029586)

======================================================================

*** ./expected/random.out    Wed Jan  5 22:40:54 2000
--- ./results/random.out    Thu Nov 29 22:23:40 2001
***************
*** 31,35 ****
    WHERE random NOT BETWEEN 80 AND 120;
   random
  --------
! (0 rows)

--- 31,36 ----
    WHERE random NOT BETWEEN 80 AND 120;
   random
  --------
!     122
! (1 row)


======================================================================

Re: Second call for platform testing

От

Thomas Lockhart

Дата:

30 ноября 2001 г., 09:25:30

...
> geometry and random failed. The diffs are attached. The geometry diffs
> all look to be 0 vs -0.
> $ model
> 9000/800/A500-44
> $ uname -a
> HP-UX csdoap2 B.11.00 A 9000/800

Great! Thanks for testing; I'll update the list...
                   - Thomas

Re: Second call for platform testing

От

Tom Lane

Дата:

30 ноября 2001 г., 10:04:44

Joe Conway <joseph.conway@home.com> writes:
> geometry and random failed. The diffs are attached. The geometry diffs 
> all look to be 0 vs -0.

Okay, it looks like HP has implemented -0 finally.  Try the other
geometry comparison files to see if any match;
geometry-positive-zeros.out is evidently only good for HPUX 10.
        regards, tom lane

Re: Second call for platform testing

От

Joe Conway

Дата:

30 ноября 2001 г., 16:55:34

Tom Lane wrote:

> Okay, it looks like HP has implemented -0 finally.  Try the other
> geometry comparison files to see if any match;
> geometry-positive-zeros.out is evidently only good for HPUX 10.
> 

A little experimentation shows that "geometry-solaris-precision.out" is 
a perfect match. Two questions:

1. Do we use "geometry-solaris-precision.out", or clone it with a more 
appropriate name like "geometry-hpux11.out" or 
"geometry-hpux-precision.out"?

2. The current resultmap says: "geometry/hppa=geometry-positive-zeros".
What do we modify to so that it differentiates between HPUX11 and 
HPUX10? I see it's related to the config.guess output and the pg_regress 
script, but it's not clear to me where to make a change.

Joe

Re: Second call for platform testing

От

"Hiroshi Inoue"

Дата:

30 ноября 2001 г., 18:04:45

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > I got a regression test result from Hiroshi Saito on
> >   UNIX_System_V ews4800 4.2MP 4.2 R4000 r4000.
> 
> > Seems INT64_IS_BUSTED, old PST ... etc and
> 
> > *** ./expected/create_index.out    Tue Aug 28 08:23:34 JST 2001
> > --- ./results/create_index.out    Fri Nov 30 00:28:22 JST 2001
> > ***************
> > *** 35,44 ****
> > --- 35,47 ----
> >   --
> >   CREATE INDEX onek2_u1_prtl ON onek2 USING btree(unique1 int4_ops)
> >       where unique1 < 20 or unique1 > 980;
> > + ERROR:  AllocSetFree: cannot find block containing chunk 4f64f0
> >   CREATE INDEX onek2_u2_prtl ON onek2 USING btree(unique2 int4_ops)
> >       where stringu1 < 'B';
> > + ERROR:  AllocSetFree: cannot find block containing chunk 4f6390
> >   CREATE INDEX onek2_stu1_prtl ON onek2 USING btree(stringu1 name_ops)
> >       where onek2.stringu1 >= 'J' and onek2.stringu1 < 'K';
> > + ERROR:  AllocSetFree: cannot find block containing chunk 4f6740
> 
> Interesting.  Something nonportable in the partial index support,
> perhaps?
> 
> Would you ask him to compile with debug support, set a breakpoint at
> elog(), and get a backtrace from the point of the error?

Unfortunately he doesn't seem to be able to do it at once
though he would like to do it.  If he is ready he may reply
to this thread directly.

regards,
Hiroshi Inoue

Re: Second call for platform testing

От

Tom Lane

Дата:

30 ноября 2001 г., 18:25:37

Joe Conway <joseph.conway@home.com> writes:
> A little experimentation shows that "geometry-solaris-precision.out" is 
> a perfect match. Two questions:

Excellent.

> 1. Do we use "geometry-solaris-precision.out", or clone it with a more 
> appropriate name like "geometry-hpux11.out" or 
> "geometry-hpux-precision.out"?

I'd use it as-is.  Not worth the trouble to rename it, and we definitely
don't want to carry around two copies.

> 2. The current resultmap says: "geometry/hppa=geometry-positive-zeros".
> What do we modify to so that it differentiates between HPUX11 and 
> HPUX10? I see it's related to the config.guess output and the pg_regress 
> script, but it's not clear to me where to make a change.

Looks like it's got to be

geometry/hppa-hp-hpux9=geometry-positive-zeros
geometry/hppa-hp-hpux10=geometry-positive-zeros
geometry/hppa-hp-hpux11=geometry-solaris-precision

Ugh, but ...

Please check that's OK on 11, and I'll double check it on 10.
        regards, tom lane

Re: Second call for platform testing

От

Joe Conway

Дата:

30 ноября 2001 г., 19:04:47

Tom Lane wrote:

> Looks like it's got to be
> 
> geometry/hppa-hp-hpux9=geometry-positive-zeros
> geometry/hppa-hp-hpux10=geometry-positive-zeros
> geometry/hppa-hp-hpux11=geometry-solaris-precision
> 
> Ugh, but ...
> 
> Please check that's OK on 11, and I'll double check it on 10.
> 

I get:

test geometry             ... FAILED
test horology             ... trouble
============== shutting down postmaster               ==============

======================= 1 of 37 tests failed.
=======================

Looks like geometry.out gets used.

Tried again with:
geometry/hppa2.0w-hp-hpux11.00=geometry-solaris-precision

and get:

====================== All 79 tests passed.
======================

So maybe it should be:
geometry/hppa.*-hp-hpux11.*=geometry-solaris-precision

yup:
====================== All 79 tests passed.
======================

Do you want a patch?

Joe

Re: Second call for platform testing

От

Tom Lane

Дата:

30 ноября 2001 г., 19:35:34

Joe Conway <joseph.conway@home.com> writes:
> So maybe it should be:
> geometry/hppa.*-hp-hpux11.*=geometry-solaris-precision

Mmm, probably so.

> Do you want a patch?

I can take it from here.  Thanks!
        regards, tom lane

Re: Second call for platform testing

От

Tatsuo Ishii

Дата:

01 декабря 2001 г., 08:34:55

> OK, the list is getting smaller fast (thanks for all of the responses!).
> Here is what I have left currently (note the addition of NetBSD/sparc,
> which I had inadvertently omitted from the first list):
> 
> BeOS         Cyril Velter
> Linux/arm    Mark Knox
> Linux/s390   Neale Ferguson
> NetBSD/arm32 Patrick Welche
> NetBSD/m68k  Bill Studenmund (will test)
> NetBSD/sparc Matthew Green (left off the first list)
> NetBSD/VAX   Tom I. Helbekkmo
> QNX          (did I get a definitive report for 4.x already?)
> SunOS        Tatsuo Ishii (old release; still relevant?)

I tried 7.2b3 on SunOS 4.1.4 with gcc 2.7.1. It gives a comile error:

gcc  -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include  -c pmsignal.c -o pmsignal.o
pmsignal.c:38: parse error before `*'
pmsignal.c:38: warning: data definition has no type or storage class
pmsignal.c: In function `PMSignalInit':
pmsignal.c:47: `sig_atomic_t' undeclared (first use this function)
pmsignal.c:47: (Each undeclared identifier is reported only once
pmsignal.c:47: for each function it appears in.)
pmsignal.c:47: parse error before `)'
--
Tatsuo Ishii

Re: Second call for platform testing

От

Tom Lane

Дата:

01 декабря 2001 г., 12:25:46

Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> I tried 7.2b3 on SunOS 4.1.4 with gcc 2.7.1. It gives a comile error:

> pmsignal.c:47: `sig_atomic_t' undeclared (first use this function)

sig_atomic_t is required by ANSI C to be declared in <signal.h>.
Is it declared anywhere in the SunOS system headers?

I suppose we could create a configure test that detects this,
but I wonder how long we want to go on supporting platforms whose
headers aren't even minimally ANSI-compliant.
        regards, tom lane

Re: Second call for platform testing

От

Peter Eisentraut

Дата:

02 декабря 2001 г., 06:56:06

Tom Lane writes:

> "Cyril VELTER" <cyril.velter@libertysurf.fr> writes:
> >     What modification should be made to configure.in to make it include
> > SupportDefs.h when testing for int8 uint8 int64 and uint64 size ?
>
> This looks like a bit of a pain.  We're currently using AC_CHECK_SIZEOF
> to make those probes, apparently because it's the closest standard macro
> to what we want.  But it's not close enough.  It doesn't include
> anything except <stdio.h>.  I don't think we can fix this except by
> making our own macro.  Peter, any opinion about how to do it?

OK, I bit the bullet and made up a whole new macro for type testing.
Those who can't get at a new snapshot can try the attached patch.

I have included <stdio.h> because that appears to effect the definition of
the types in question on AIX; apparently it pulls in <inttypes.h> somehow.

Please check this on AIX and BeOS.

-- 
Peter Eisentraut   peter_e@gmx.net

Re: Second call for platform testing

От

"Zeugswetter Andreas SB SD"

Дата:

03 декабря 2001 г., 05:26:25

> > >     What modification should be made to configure.in to make it
include
> > > SupportDefs.h when testing for int8 uint8 int64 and uint64 size ?

> 
> OK, I bit the bullet and made up a whole new macro for type testing.
> Those who can't get at a new snapshot can try the attached patch.
> 
> I have included <stdio.h> because that appears to effect the
definition of
> the types in question on AIX; apparently it pulls in <inttypes.h>
somehow.

Correct. stdio.h pulls sys/types.h which then pulls sys/inttypes.h ==
inttypes.h.

> Please check this on AIX and BeOS.

Works like a charm on AIX :-) (Tested snapshot of 3 Dec 4:01)
I think it is also a gain, since it does not confuse people looking at 
configure output.

Thank you Peter
Andreas

Re: Second call for platform testing

От

Thomas Lockhart

Дата:

03 декабря 2001 г., 12:16:29

> `gmake check' gets:
>          All 79 tests passed.
> on both netbsd/sparc & netbsd/sparc64.

Great. Thanks!
                - Thomas

Re: Second call for platform testing

От

Joe Conway

Дата:

03 декабря 2001 г., 13:04:17

Tom Lane wrote:

> What had configure selected so far for compiler, cflags, etc?  Maybe
> it's blowing the game at that stage.  Or maybe the test is failing to
> include all the needed include files to define these datatypes.
>
> In general, the config.log output is a good thing to post when puzzled
> by configure problems.

OK. Figured out a couple of pieces to this. First, although I was told
we did not have HP's compiler, it is actually there. Second, since gcc
was freshly installed, it wasn't in my PATH. So the error I reported
last time is actually from the bundled compiler.

So I added /opt/gcc/bin to my PATH, and got a different error once gcc
was detected.

Attached are both config.log files. Sorry for being so clueless here,
but I haven't done much on HPUX before.

Joe
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.

configure:635: checking host system type
configure:661: checking which template to use
configure:824: checking whether to build with locale support
configure:853: checking whether to build with recode support
configure:883: checking whether to build with multibyte character support
configure:937: checking whether NLS is wanted
configure:972: checking for default port number
configure:1006: checking for default soft limit on number of connections
configure:1130: checking for gcc
configure:1160: checking for cc
configure:1243: checking whether the C compiler (cc  ) works
configure:1259: cc -o conftest    conftest.c  1>&5
configure:1285: checking whether the C compiler (cc  ) is a cross-compiler
configure:1290: checking whether we are using GNU C
configure:1299: cc -E conftest.c
configure:1318: checking whether cc accepts -g
configure:1361: checking whether the C compiler (cc -Ae +O2 ) works
configure:1377: cc -Ae -o conftest +O2   conftest.c  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:1403: checking whether the C compiler (cc -Ae +O2 ) is a cross-compiler
configure:1408: checking for Cygwin environment
configure:1424: cc -Ae -c +O2  conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 1420: error 1588: "__CYGWIN32__" undefined.
configure: failed program was:
#line 1413 "configure"
#include "confdefs.h"

int main() {

#ifndef __CYGWIN__
#define __CYGWIN__ __CYGWIN32__
#endif
return __CYGWIN__;
; return 0; }
configure:1441: checking for mingw32 environment
configure:1453: cc -Ae -c +O2  conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 1449: error 1588: "__MINGW32__" undefined.
configure: failed program was:
#line 1446 "configure"
#include "confdefs.h"

int main() {
return __MINGW32__;
; return 0; }
configure:1472: checking for executable suffix
configure:1482: cc -Ae -o conftest +O2   conftest.c  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:1503: checking how to run the C preprocessor
configure:1524: cc -Ae -E  conftest.c >/dev/null 2>conftest.out
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
configure: failed program was:
#line 1518 "configure"
#include "confdefs.h"
#include <assert.h>
Syntax Error
configure:1541: cc -Ae -E -traditional-cpp  conftest.c >/dev/null 2>conftest.out
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: error 1400: Option t usage: -t c,name where c may be 1 or more of pc0al.
configure: failed program was:
#line 1535 "configure"
#include "confdefs.h"
#include <assert.h>
Syntax Error
configure:1558: cc -Ae -nologo -E  conftest.c >/dev/null 2>conftest.out
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The -n option is available only with the C/ANSI C product; ignored.
configure: failed program was:
#line 1552 "configure"
#include "confdefs.h"
#include <assert.h>
Syntax Error
configure:1730: checking whether to build with Tcl
configure:1754: checking whether to build with Tk
configure:1815: checking whether to build Perl modules
configure:1841: checking whether to build Python modules
configure:1867: checking whether to build Java/JDBC tools
configure:2105: checking whether to build with PAM support
configure:2196: checking whether to build the ODBC driver
configure:2334: checking whether to build C++ modules
configure:2727: checking for mawk
configure:2727: checking for gawk
configure:2727: checking for nawk
configure:2727: checking for awk
configure:2757: checking for flex
configure:2822: checking whether ln -s works
configure:2887: checking for non-GNU ld
configure:2922: checking if the linker (/usr/bin/ld) is GNU ld
configure:2977: checking for ranlib
configure:3009: checking for lorder
configure:3041: checking for tar
configure:3079: checking for bison
configure:3162: checking for perl
configure:3299: checking for readline
configure:3321: cc -Ae -o conftest +O2     conftest.c -lreadline  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "readline"
configure: failed program was:
#line 3310 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char readline();

int main() {
readline()
; return 0; }
configure:3321: cc -Ae -o conftest +O2     conftest.c -ledit  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "edit"
configure: failed program was:
#line 3310 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char readline();

int main() {
readline()
; return 0; }
configure:3321: cc -Ae -o conftest +O2     conftest.c -lreadline -ltermcap  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "readline"
configure: failed program was:
#line 3310 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char readline();

int main() {
readline()
; return 0; }
configure:3321: cc -Ae -o conftest +O2     conftest.c -ledit -ltermcap  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "edit"
configure: failed program was:
#line 3310 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char readline();

int main() {
readline()
; return 0; }
configure:3321: cc -Ae -o conftest +O2     conftest.c -lreadline -lncurses  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "readline"
configure: failed program was:
#line 3310 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char readline();

int main() {
readline()
; return 0; }
configure:3321: cc -Ae -o conftest +O2     conftest.c -ledit -lncurses  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "edit"
configure: failed program was:
#line 3310 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char readline();

int main() {
readline()
; return 0; }
configure:3321: cc -Ae -o conftest +O2     conftest.c -lreadline -lcurses  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "readline"
configure: failed program was:
#line 3310 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char readline();

int main() {
readline()
; return 0; }
configure:3321: cc -Ae -o conftest +O2     conftest.c -ledit -lcurses  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "edit"
configure: failed program was:
#line 3310 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char readline();

int main() {
readline()
; return 0; }
configure:3360: checking for library containing using_history
configure:3378: cc -Ae -o conftest +O2     conftest.c  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Unsatisfied symbols:
   using_history (first referenced in conftest.o) (code)
configure: failed program was:
#line 3367 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char using_history();

int main() {
using_history()
; return 0; }
configure:3400: cc -Ae -o conftest +O2     conftest.c -lhistory   1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "history"
configure: failed program was:
#line 3389 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char using_history();

int main() {
using_history()
; return 0; }
configure:3427: checking for main in -lbsd
configure:3442: cc -Ae -o conftest +O2     conftest.c -lbsd   1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "bsd"
configure: failed program was:
#line 3435 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:3471: checking for setproctitle in -lutil
configure:3490: cc -Ae -o conftest +O2     conftest.c -lutil   1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "util"
configure: failed program was:
#line 3479 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char setproctitle();

int main() {
setproctitle()
; return 0; }
configure:3518: checking for main in -lm
configure:3533: cc -Ae -o conftest +O2     conftest.c -lm   1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:3561: checking for main in -ldl
configure:3576: cc -Ae -o conftest +O2     conftest.c -ldl  -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "dl"
configure: failed program was:
#line 3569 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:3604: checking for main in -lsocket
configure:3619: cc -Ae -o conftest +O2     conftest.c -lsocket  -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "socket"
configure: failed program was:
#line 3612 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:3647: checking for main in -lnsl
configure:3662: cc -Ae -o conftest +O2     conftest.c -lnsl  -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:3690: checking for main in -lipc
configure:3705: cc -Ae -o conftest +O2     conftest.c -lipc  -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "ipc"
configure: failed program was:
#line 3698 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:3733: checking for main in -lIPC
configure:3748: cc -Ae -o conftest +O2     conftest.c -lIPC  -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "IPC"
configure: failed program was:
#line 3741 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:3776: checking for main in -llc
configure:3791: cc -Ae -o conftest +O2     conftest.c -llc  -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "lc"
configure: failed program was:
#line 3784 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:3819: checking for main in -ldld
configure:3834: cc -Ae -o conftest +O2     conftest.c -ldld  -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:3862: checking for main in -lld
configure:3877: cc -Ae -o conftest +O2     conftest.c -lld  -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "ld"
configure: failed program was:
#line 3870 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:3905: checking for main in -lcompat
configure:3920: cc -Ae -o conftest +O2     conftest.c -lcompat  -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "compat"
configure: failed program was:
#line 3913 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:3948: checking for main in -lBSD
configure:3963: cc -Ae -o conftest +O2     conftest.c -lBSD  -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:3991: checking for main in -lgen
configure:4006: cc -Ae -o conftest +O2     conftest.c -lgen  -lBSD -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:4034: checking for main in -lPW
configure:4049: cc -Ae -o conftest +O2     conftest.c -lPW  -lgen -lBSD -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:4077: checking for main in -lresolv
configure:4092: cc -Ae -o conftest +O2     conftest.c -lresolv  -lPW -lgen -lBSD -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "resolv"
configure: failed program was:
#line 4085 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:4121: checking for main in -lunix
configure:4136: cc -Ae -o conftest +O2     conftest.c -lunix  -lPW -lgen -lBSD -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "unix"
configure: failed program was:
#line 4129 "configure"
#include "confdefs.h"

int main() {
main()
; return 0; }
configure:4165: checking for library containing crypt
configure:4183: cc -Ae -o conftest +O2     conftest.c -lPW -lgen -lBSD -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:4227: checking for __inet_ntoa in -lbind
configure:4246: cc -Ae -o conftest +O2     conftest.c -lbind  -lPW -lgen -lBSD -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
/usr/ccs/bin/ld: Can't find library: "bind"
configure: failed program was:
#line 4235 "configure"
#include "confdefs.h"
/* Override any gcc2 internal prototype to avoid an error.  */
/* We use char because int might match the return type of a gcc2
    builtin and then its argument prototype would still apply.  */
char __inet_ntoa();

int main() {
__inet_ntoa()
; return 0; }
cpp: "configure", line 4279: error 4036: Can't open include file 'zlib.h'.
configure:4340: checking for library containing fdatasync
configure:4358: cc -Ae -o conftest +O2     conftest.c -lPW -lgen -lBSD -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:5071: checking for crypt.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for dld.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5077: error 4036: Can't open include file 'dld.h'.
configure: failed program was:
#line 5076 "configure"
#include "confdefs.h"
#include <dld.h>
configure:5071: checking for endian.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5077: error 4036: Can't open include file 'endian.h'.
configure: failed program was:
#line 5076 "configure"
#include "confdefs.h"
#include <endian.h>
configure:5071: checking for fp_class.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5077: error 4036: Can't open include file 'fp_class.h'.
configure: failed program was:
#line 5076 "configure"
#include "confdefs.h"
#include <fp_class.h>
configure:5071: checking for getopt.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5077: error 4036: Can't open include file 'getopt.h'.
configure: failed program was:
#line 5076 "configure"
#include "confdefs.h"
#include <getopt.h>
configure:5071: checking for ieeefp.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5077: error 4036: Can't open include file 'ieeefp.h'.
configure: failed program was:
#line 5076 "configure"
#include "confdefs.h"
#include <ieeefp.h>
configure:5071: checking for pwd.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for sys/ipc.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for sys/pstat.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for sys/select.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5077: error 4036: Can't open include file 'sys/select.h'.
configure: failed program was:
#line 5076 "configure"
#include "confdefs.h"
#include <sys/select.h>
configure:5071: checking for sys/sem.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for sys/socket.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for sys/shm.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for sys/types.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for sys/un.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for termios.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5071: checking for kernel/OS.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5077: error 4036: Can't open include file 'kernel/OS.h'.
configure: failed program was:
#line 5076 "configure"
#include "confdefs.h"
#include <kernel/OS.h>
configure:5071: checking for kernel/image.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5077: error 4036: Can't open include file 'kernel/image.h'.
configure: failed program was:
#line 5076 "configure"
#include "confdefs.h"
#include <kernel/image.h>
configure:5071: checking for SupportDefs.h
configure:5081: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5077: error 4036: Can't open include file 'SupportDefs.h'.
configure: failed program was:
#line 5076 "configure"
#include "confdefs.h"
#include <SupportDefs.h>
configure:5112: checking for netinet/in.h
configure:5122: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5149: checking for netinet/tcp.h
configure:5161: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5179: checking whether string.h and strings.h may both be included
configure:5191: /lib/cpp   conftest.c >/dev/null 2>conftest.out
configure:5205: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:5237: checking for readline/readline.h
configure:5247: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5243: error 4036: Can't open include file 'readline/readline.h'.
configure: failed program was:
#line 5242 "configure"
#include "confdefs.h"
#include <readline/readline.h>
configure:5237: checking for readline.h
configure:5247: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5243: error 4036: Can't open include file 'readline.h'.
configure: failed program was:
#line 5242 "configure"
#include "confdefs.h"
#include <readline.h>
configure:5277: checking for readline/history.h
configure:5287: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5283: error 4036: Can't open include file 'readline/history.h'.
configure: failed program was:
#line 5282 "configure"
#include "confdefs.h"
#include <readline/history.h>
configure:5277: checking for history.h
configure:5287: /lib/cpp   conftest.c >/dev/null 2>conftest.out
cpp: "configure", line 5283: error 4036: Can't open include file 'history.h'.
configure: failed program was:
#line 5282 "configure"
#include "confdefs.h"
#include <history.h>
configure:5535: checking for working const
configure:5589: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 5545: warning 5: "const" will become a keyword.
(Bundled) cc: "configure", line 5545: error 1000: Unexpected symbol: "charset".
(Bundled) cc: "configure", line 5547: warning 5: "const" will become a keyword.
(Bundled) cc: "configure", line 5547: warning 5: "const" will become a keyword.
(Bundled) cc: "configure", line 5547: error 1000: Unexpected symbol: "*".
(Bundled) cc: "configure", line 5551: warning 5: "const" will become a keyword.
(Bundled) cc: "configure", line 5551: error 1000: Unexpected symbol: "zero".
(Bundled) cc: "configure", line 5555: warning 5: "const" will become a keyword.
(Bundled) cc: "configure", line 5555: error 1000: Unexpected symbol: "char".
(Bundled) cc: "configure", line 5560: warning 5: "const" will become a keyword.
(Bundled) cc: "configure", line 5560: error 1000: Unexpected symbol: "const".
(Bundled) cc: "configure", line 5560: warning 5: "const" will become a keyword.
(Bundled) cc: "configure", line 5563: warning 5: "const" will become a keyword.
(Bundled) cc: "configure", line 5560: error 1000: Unexpected symbol: ")".
(Bundled) cc: error 2017: Cannot recover from earlier errors, terminating.
configure: failed program was:
#line 5540 "configure"
#include "confdefs.h"

int main() {

/* Ultrix mips cc rejects this.  */
typedef int charset[2]; const charset x;
/* SunOS 4.1.1 cc rejects this.  */
char const *const *ccp;
char **p;
/* NEC SVR4.0.2 mips cc rejects this.  */
struct point {int x, y;};
static struct point const zero = {0,0};
/* AIX XL C 1.02.0.0 rejects this.
   It does not let you subtract one const X* pointer from another in an arm
   of an if-expression whose if-part is not a constant expression */
const char *g = "string";
ccp = &g + (g ? g-g : 0);
/* HPUX 7.0 cc rejects these. */
++ccp;
p = (char**) ccp;
ccp = (char const *const *) p;
{ /* SCO 3.2v4 cc rejects this.  */
  char *t;
  char const *s = 0 ? (char *) 0 : (char const *) 0;

  *t++ = 0;
}
{ /* Someone thinks the Sun supposedly-ANSI compiler will reject this.  */
  int x[] = {25, 17};
  const int *foo = &x[0];
  ++foo;
}
{ /* Sun SC1.0 ANSI compiler rejects this -- but not the above. */
  typedef const int *iptr;
  iptr p = 0;
  ++p;
}
{ /* AIX XL C 1.02.0.0 rejects this saying
     "k.c", line 2.27: 1506-025 (S) Operand must be a modifiable lvalue. */
  struct s { int j; const int *ap[3]; };
  struct s *b; b->j = 5;
}
{ /* ULTRIX-32 V3.1 (Rev 9) vcc rejects this */
  const int foo = 10;
}

; return 0; }
configure:5610: checking for inline
configure:5624: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 5620: error 1000: Unexpected symbol: "foo".
(Bundled) cc: error 2017: Cannot recover from earlier errors, terminating.
configure: failed program was:
#line 5617 "configure"
#include "confdefs.h"

int main() {
} inline foo() {
; return 0; }
configure:5624: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 5620: error 1000: Unexpected symbol: "foo".
(Bundled) cc: error 2017: Cannot recover from earlier errors, terminating.
configure: failed program was:
#line 5617 "configure"
#include "confdefs.h"

int main() {
} __inline__ foo() {
; return 0; }
configure:5624: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 5620: error 1000: Unexpected symbol: "foo".
(Bundled) cc: error 2017: Cannot recover from earlier errors, terminating.
configure: failed program was:
#line 5617 "configure"
#include "confdefs.h"

int main() {
} __inline foo() {
; return 0; }
configure:5652: checking for preprocessor stringizing operator
configure:5687: checking for signed types
configure:5699: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 5695: warning 5: "signed" will become a keyword.
(Bundled) cc: "configure", line 5695: error 1000: Unexpected symbol: "char".
(Bundled) cc: "configure", line 5695: warning 5: "signed" will become a keyword.
(Bundled) cc: "configure", line 5695: error 1000: Unexpected symbol: "short".
(Bundled) cc: "configure", line 5695: warning 5: "signed" will become a keyword.
(Bundled) cc: "configure", line 5695: error 1000: Unexpected symbol: "int".
(Bundled) cc: "configure", line 5695: error 1588: "signed" undefined.
configure: failed program was:
#line 5692 "configure"
#include "confdefs.h"

int main() {
signed char c; signed short s; signed int i;
; return 0; }
configure:5719: checking for volatile
configure:5731: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:5751: checking whether struct tm is in sys/time.h or time.h
configure:5764: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:5785: checking for tm_zone in struct tm
configure:5798: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 5794: error 1588: "tm_zone" undefined.
(Bundled) cc: "configure", line 5794: error 1531: Invalid member of struct or union.
configure: failed program was:
#line 5790 "configure"
#include "confdefs.h"
#include <sys/types.h>
#include <time.h>
int main() {
struct tm tm; tm.tm_zone;
; return 0; }
configure:5818: checking for tzname
configure:5833: cc -Ae -o conftest +O2     conftest.c -lPW -lgen -lBSD -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:5855: checking for union semun
configure:5869: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 5865: error 1574: Unknown size for "semun".
configure: failed program was:
#line 5860 "configure"
#include "confdefs.h"
#include <sys/types.h>
#include <sys/ipc.h>
#include <sys/sem.h>
int main() {
union semun semun;
; return 0; }
configure:5889: checking for struct cmsgcred
configure:5903: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
cpp: "configure", line 5897: error 4036: Can't open include file 'sys/ucred.h'.
configure: failed program was:
#line 5894 "configure"
#include "confdefs.h"
#include <sys/param.h>
#include <sys/socket.h>
#include <sys/ucred.h>
int main() {
struct cmsgcred sockcred;
; return 0; }
configure:5923: checking for struct fcred
configure:5937: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
cpp: "configure", line 5931: error 4036: Can't open include file 'sys/ucred.h'.
configure: failed program was:
#line 5928 "configure"
#include "confdefs.h"
#include <sys/param.h>
#include <sys/socket.h>
#include <sys/ucred.h>
int main() {
struct fcred sockcred;
; return 0; }
configure:5957: checking for struct sockcred
configure:5971: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
cpp: "configure", line 5965: error 4036: Can't open include file 'sys/ucred.h'.
configure: failed program was:
#line 5962 "configure"
#include "confdefs.h"
#include <sys/param.h>
#include <sys/socket.h>
#include <sys/ucred.h>
int main() {
struct sockcred sockcred;
; return 0; }
configure:5991: checking for struct sockaddr_un
configure:6006: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:6030: checking for int timezone
configure:6043: cc -Ae -o conftest +O2     conftest.c -lPW -lgen -lBSD -ldld -lnsl -lm  1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
configure:6063: checking types of arguments for accept()
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, struct sockaddr *, int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "size_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
(Bundled) cc: "configure", line 6084: error 1573: Type of "<<<NULL_SYMBOL>>>" is undefined due to an illegal
declaration.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, struct sockaddr *, size_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "socklen_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, struct sockaddr *, socklen_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, struct sockaddr *, unsigned int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, struct sockaddr *, void *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, const struct sockaddr *, int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "size_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
(Bundled) cc: "configure", line 6084: error 1573: Type of "<<<NULL_SYMBOL>>>" is undefined due to an illegal
declaration.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, const struct sockaddr *, size_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "socklen_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, const struct sockaddr *, socklen_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, const struct sockaddr *, unsigned int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, const struct sockaddr *, void *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, void *, int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "size_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
(Bundled) cc: "configure", line 6084: error 1573: Type of "<<<NULL_SYMBOL>>>" is undefined due to an illegal
declaration.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, void *, size_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "socklen_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, void *, socklen_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, void *, unsigned int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (int, void *, void *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, struct sockaddr *, int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "size_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
(Bundled) cc: "configure", line 6084: error 1573: Type of "<<<NULL_SYMBOL>>>" is undefined due to an illegal
declaration.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, struct sockaddr *, size_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "socklen_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, struct sockaddr *, socklen_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, struct sockaddr *, unsigned int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, struct sockaddr *, void *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, const struct sockaddr *, int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "size_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
(Bundled) cc: "configure", line 6084: error 1573: Type of "<<<NULL_SYMBOL>>>" is undefined due to an illegal
declaration.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, const struct sockaddr *, size_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "socklen_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, const struct sockaddr *, socklen_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, const struct sockaddr *, unsigned int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, const struct sockaddr *, void *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, void *, int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "size_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
(Bundled) cc: "configure", line 6084: error 1573: Type of "<<<NULL_SYMBOL>>>" is undefined due to an illegal
declaration.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, void *, size_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1000: Unexpected symbol: "socklen_t".
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, void *, socklen_t *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, void *, unsigned int *);
int main() {

; return 0; }
configure:6090: cc -Ae -c +O2   conftest.c 1>&5
(Bundled) cc: warning 480: The -A option is available only with the C/ANSI C product; ignored.
(Bundled) cc: warning 480: The +O2 option is available only with the C/ANSI C product; ignored.
(Bundled) cc: "configure", line 6084: error 1705: Function prototypes are an ANSI feature.
configure: failed program was:
#line 6077 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include <sys/types.h>
#endif
#ifdef HAVE_SYS_SOCKET_H
#include <sys/socket.h>
#endif
extern int accept (unsigned int, void *, void *);
int main() {

; return 0; }
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.

configure:635: checking host system type
configure:661: checking which template to use
configure:824: checking whether to build with locale support
configure:853: checking whether to build with recode support
configure:883: checking whether to build with multibyte character support
configure:937: checking whether NLS is wanted
configure:972: checking for default port number
configure:1006: checking for default soft limit on number of connections
configure:1130: checking for gcc
configure:1243: checking whether the C compiler (gcc  ) works
configure:1259: gcc -o conftest    conftest.c  1>&5
as: warning 2: Unknown option "--traditional-format" ignored.
as: "/var/tmp/cceTg0Kd.s", line 15: error 1052: Directive name not recognized - NSUBSPA
configure: failed program was:

#line 1254 "configure"
#include "confdefs.h"

main(){return(0);}

Re: Second call for platform testing

От

matthew green

Дата:

03 декабря 2001 г., 13:05:43

  NetBSD/sparc Matthew Green (left off the first list)


`gmake check' gets:
====================== All 79 tests passed.======================

on both netbsd/sparc & netbsd/sparc64.


.mrg.

Re: Second call for platform testing

От

Mark Knox

Дата:

03 декабря 2001 г., 13:05:58

>Linux/arm    Mark Knox

Had a look at 7.2b3 and sadly it's failing several tests. I saw several
"ERROR:  PGSTAT: Creation of DB hash table failed" which I haven't seen before.

Geometry fails as usual due to some minor rounding. The others are
completely wrong. I'm afraid I don't have much time to look at this right
now (sorry) but I've attached the regression output and diffs if anyone
wants to check them.

(Note: any responses should probably be addressed to me directly as well as
to the list.. I will likely miss them otherwise. Thanks.)


    __ .--------.
   |==||        |            -(  Mark 'segfault' Knox  )-
   |==||________|
   |::| __====__`. .'`.  "Unix *is* user-friendly.. it's just
   |__|/::::::::\ ~  (_)       picky about its friends."
parallel group (13 tests):  char name text boolean int2 oid varchar int8 float4 int4 float8 bit numeric
     boolean              ... ok
     char                 ... ok
     name                 ... ok
     varchar              ... ok
     text                 ... ok
     int2                 ... ok
     int4                 ... ok
     int8                 ... ok
     oid                  ... ok
     float4               ... ok
     float8               ... ok
     bit                  ... ok
     numeric              ... FAILED
test strings              ... ok
test numerology           ... ok
parallel group (20 tests):  point lseg box path circle time polygon timetz date interval reltime abstime comments
tintervalinet timestamp type_sanity timestamptz opr_sanity oidjoins 
     point                ... ok
     lseg                 ... ok
     box                  ... ok
     path                 ... ok
     polygon              ... ok
     circle               ... ok
     date                 ... ok
     time                 ... ok
     timetz               ... ok
     timestamp            ... ok
     timestamptz          ... ok
     interval             ... ok
     abstime              ... ok
     reltime              ... ok
     tinterval            ... ok
     inet                 ... ok
     comments             ... ok
     oidjoins             ... ok
     type_sanity          ... ok
     opr_sanity           ... ok
test geometry             ... FAILED
test horology             ... ok
test create_function_1    ... ok
test create_type          ... ok
test create_table         ... ok
test create_function_2    ... ok
test copy                 ... ok
parallel group (7 tests):  create_aggregate create_operator triggers inherit constraints create_misc create_index
     constraints          ... ok
     triggers             ... ok
     create_misc          ... ok
     create_aggregate     ... ok
     create_operator      ... ok
     create_index         ... ok
     inherit              ... ok
test create_view          ... ok
test sanity_check         ... FAILED
test errors               ... ok
test select               ... FAILED
parallel group (16 tests):  select_distinct_on select_into select_distinct select_having transactions random union
subselectcase arrays select_implicit portals join aggregates hash_index btree_index 
     select_into          ... ok
     select_distinct      ... ok
     select_distinct_on   ... ok
     select_implicit      ... ok
     select_having        ... ok
     subselect            ... ok
     union                ... ok
     case                 ... ok
     join                 ... ok
     aggregates           ... ok
     transactions         ... ok
     random               ... ok
     portals              ... ok
     arrays               ... ok
     btree_index          ... ok
     hash_index           ... ok
test privileges           ... ok
test misc                 ... ok
parallel group (5 tests):  portals_p2 alter_table rules foreign_key select_views
     select_views         ... FAILED
     alter_table          ... FAILED
     portals_p2           ... ok
     rules                ... ok
     foreign_key          ... ok
parallel group (3 tests):  limit temp plpgsql
     limit                ... ok
     plpgsql              ... ok
     temp                 ... ok
*** ./expected/numeric.out    Fri Apr  7 15:17:42 2000
--- ./results/numeric.out    Sat Dec  1 21:22:26 2001
***************
*** 489,494 ****
--- 489,495 ----
  CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id);
  CREATE UNIQUE INDEX num_exp_power_10_ln_idx ON num_exp_power_10_ln (id);
  VACUUM ANALYZE num_exp_add;
+ ERROR:  PGSTAT: Creation of DB hash table failed
  VACUUM ANALYZE num_exp_sub;
  VACUUM ANALYZE num_exp_div;
  VACUUM ANALYZE num_exp_mul;

======================================================================

*** ./expected/geometry.out    Fri Sep 28 03:59:52 2001
--- ./results/geometry.out    Sat Dec  1 21:23:06 2001
***************
*** 127,133 ****
          | (-5,-12)   | [(10,-10),(-3,-4)]            | (-1.60487804878049,-4.64390243902439)
          | (10,10)    | [(10,-10),(-3,-4)]            | (2.39024390243902,-6.48780487804878)
          | (0,0)      | [(-1000000,200),(300000,-40)] | (0.0028402365895872,15.384614860264)
!         | (-10,0)    | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140473)
          | (-3,4)     | [(-1000000,200),(300000,-40)] | (-2.99789812267519,15.3851688427303)
          | (5.1,34.5) | [(-1000000,200),(300000,-40)] | (5.09647083221496,15.3836744976925)
          | (-5,-12)   | [(-1000000,200),(300000,-40)] | (-4.99494420845634,15.3855375281616)
--- 127,133 ----
          | (-5,-12)   | [(10,-10),(-3,-4)]            | (-1.60487804878049,-4.64390243902439)
          | (10,10)    | [(10,-10),(-3,-4)]            | (2.39024390243902,-6.48780487804878)
          | (0,0)      | [(-1000000,200),(300000,-40)] | (0.0028402365895872,15.384614860264)
!         | (-10,0)    | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140472)
          | (-3,4)     | [(-1000000,200),(300000,-40)] | (-2.99789812267519,15.3851688427303)
          | (5.1,34.5) | [(-1000000,200),(300000,-40)] | (5.09647083221496,15.3836744976925)
          | (-5,-12)   | [(-1000000,200),(300000,-40)] | (-4.99494420845634,15.3855375281616)
***************
*** 150,160 ****
   six |                                    box
  -----+----------------------------------------------------------------------------
       | (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964)
!      | (71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548)
!      | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738)
       | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
       | (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)
!      | (170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548)
  (6 rows)

  -- translation
--- 150,160 ----
   six |                                    box
  -----+----------------------------------------------------------------------------
       | (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964)
!      | (71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547)
!      | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737)
       | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
       | (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)
!      | (170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547)
  (6 rows)

  -- translation
***************
*** 443,454 ****
     FROM CIRCLE_TBL;
   six |
                                                                          polygon

                           

-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!      |
((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359078377e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718156754e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077235131e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
       |
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
!      |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081028))
!      |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617))
       |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
!      |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239385585e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
  (6 rows)

  -- convert the circle to an 8-point polygon
--- 443,454 ----
     FROM CIRCLE_TBL;
   six |
                                                                          polygon

                           

-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!      |
((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
       |
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
!      |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028))
!      |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
       |
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
!      |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
  (6 rows)

  -- convert the circle to an 8-point polygon
***************
*** 456,467 ****
     FROM CIRCLE_TBL;
   six |
 polygon
  

-----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!      |
((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359078377e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718156754e-11),(2.12132034353258,-2.12132034358671),(-4.59307077235131e-11,-3),(-2.12132034359753,-2.12132034352175))
!      |
((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181134),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
       |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
       |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
       |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
!      |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181134),(200,-1.02068239385585e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
  (6 rows)

  --
--- 456,467 ----
     FROM CIRCLE_TBL;
   six |
 polygon
  

-----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
!      |
((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175))
!      |
((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
       |
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
       |
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
       |
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
!      |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
  (6 rows)

  --
***************
*** 503,513 ****
     WHERE (p1.f1 <-> c1.f1) > 0
     ORDER BY distance, circle, point using <<;
   twentyfour |     circle     |   point    |     distance
! ------------+----------------+------------+-------------------
!             | <(100,0),100>  | (5.1,34.5) | 0.976531926977965
              | <(1,2),3>      | (-3,4)     |  1.47213595499958
              | <(0,0),3>      | (-3,4)     |                 2
!             | <(100,0),100>  | (-3,4)     |  3.07764064044151
              | <(100,0),100>  | (-5,-12)   |  5.68348972285122
              | <(1,3),5>      | (-10,0)    |  6.40175425099138
              | <(1,3),5>      | (10,10)    |  6.40175425099138
--- 503,513 ----
     WHERE (p1.f1 <-> c1.f1) > 0
     ORDER BY distance, circle, point using <<;
   twentyfour |     circle     |   point    |     distance
! ------------+----------------+------------+------------------
!             | <(100,0),100>  | (5.1,34.5) | 0.97653192697797
              | <(1,2),3>      | (-3,4)     | 1.47213595499958
              | <(0,0),3>      | (-3,4)     |                2
!             | <(100,0),100>  | (-3,4)     | 3.07764064044152
              | <(100,0),100>  | (-5,-12)   | 5.68348972285122
              | <(1,3),5>      | (-10,0)    | 6.40175425099138
              | <(1,3),5>      | (10,10)    | 6.40175425099138

======================================================================

*** ./expected/sanity_check.out    Mon Aug 27 19:23:34 2001
--- ./results/sanity_check.out    Sat Dec  1 21:25:17 2001
***************
*** 1,4 ****
--- 1,5 ----
  VACUUM;
+ ERROR:  PGSTAT: Creation of DB hash table failed
  --
  -- sanity check, if we don't have indices the test will take years to
  -- complete.  But skip TOAST relations since they will have varying
***************
*** 21,26 ****
--- 22,28 ----
   hash_name_heap      | t
   hash_txt_heap       | t
   ihighway            | t
+  inet_tbl            | t
   num_exp_add         | t
   num_exp_div         | t
   num_exp_ln          | t
***************
*** 59,63 ****
   shighway            | t
   tenk1               | t
   tenk2               | t
! (49 rows)

--- 61,65 ----
   shighway            | t
   tenk1               | t
   tenk2               | t
! (50 rows)


======================================================================

*** ./expected/select.out    Mon Jul 16 01:07:00 2001
--- ./results/select.out    Sat Dec  1 21:25:20 2001
***************
*** 211,232 ****
  -- so ANALYZE first.
  --
  ANALYZE onek2;
  --
  -- awk '{if($1<10){print $0;}else{next;}}' onek.data | sort +0n -1
  --
  SELECT onek2.* WHERE onek2.unique1 < 10;
   unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4  

---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
!        0 |     998 |   0 |    0 |   0 |      0 |       0 |        0 |           0 |         0 |        0 |   0 |    1
|AAAAAA   | KMBAAA   | OOOOxx 
         1 |     214 |   1 |    1 |   1 |      1 |       1 |        1 |           1 |         1 |        1 |   2 |    3
|BAAAAA   | GIAAAA   | OOOOxx 
         2 |     326 |   0 |    2 |   2 |      2 |       2 |        2 |           2 |         2 |        2 |   4 |    5
|CAAAAA   | OMAAAA   | OOOOxx 
         3 |     431 |   1 |    3 |   3 |      3 |       3 |        3 |           3 |         3 |        3 |   6 |    7
|DAAAAA   | PQAAAA   | VVVVxx 
-        4 |     833 |   0 |    0 |   4 |      4 |       4 |        4 |           4 |         4 |        4 |   8 |    9
|EAAAAA   | BGBAAA   | HHHHxx 
         5 |     541 |   1 |    1 |   5 |      5 |       5 |        5 |           5 |         5 |        5 |  10 |   11
|FAAAAA   | VUAAAA   | HHHHxx 
-        6 |     978 |   0 |    2 |   6 |      6 |       6 |        6 |           6 |         6 |        6 |  12 |   13
|GAAAAA   | QLBAAA   | OOOOxx 
         7 |     647 |   1 |    3 |   7 |      7 |       7 |        7 |           7 |         7 |        7 |  14 |   15
|HAAAAA   | XYAAAA   | VVVVxx 
         8 |     653 |   0 |    0 |   8 |      8 |       8 |        8 |           8 |         8 |        8 |  16 |   17
|IAAAAA   | DZAAAA   | HHHHxx 
!        9 |      49 |   1 |    1 |   9 |      9 |       9 |        9 |           9 |         9 |        9 |  18 |   19
|JAAAAA   | XBAAAA   | HHHHxx 
  (10 rows)

  --
--- 211,233 ----
  -- so ANALYZE first.
  --
  ANALYZE onek2;
+ ERROR:  PGSTAT: Creation of DB hash table failed
  --
  -- awk '{if($1<10){print $0;}else{next;}}' onek.data | sort +0n -1
  --
  SELECT onek2.* WHERE onek2.unique1 < 10;
   unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4  

---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
!        9 |      49 |   1 |    1 |   9 |      9 |       9 |        9 |           9 |         9 |        9 |  18 |   19
|JAAAAA   | XBAAAA   | HHHHxx 
         1 |     214 |   1 |    1 |   1 |      1 |       1 |        1 |           1 |         1 |        1 |   2 |    3
|BAAAAA   | GIAAAA   | OOOOxx 
         2 |     326 |   0 |    2 |   2 |      2 |       2 |        2 |           2 |         2 |        2 |   4 |    5
|CAAAAA   | OMAAAA   | OOOOxx 
         3 |     431 |   1 |    3 |   3 |      3 |       3 |        3 |           3 |         3 |        3 |   6 |    7
|DAAAAA   | PQAAAA   | VVVVxx 
         5 |     541 |   1 |    1 |   5 |      5 |       5 |        5 |           5 |         5 |        5 |  10 |   11
|FAAAAA   | VUAAAA   | HHHHxx 
         7 |     647 |   1 |    3 |   7 |      7 |       7 |        7 |           7 |         7 |        7 |  14 |   15
|HAAAAA   | XYAAAA   | VVVVxx 
         8 |     653 |   0 |    0 |   8 |      8 |       8 |        8 |           8 |         8 |        8 |  16 |   17
|IAAAAA   | DZAAAA   | HHHHxx 
!        4 |     833 |   0 |    0 |   4 |      4 |       4 |        4 |           4 |         4 |        4 |   8 |    9
|EAAAAA   | BGBAAA   | HHHHxx 
!        6 |     978 |   0 |    2 |   6 |      6 |       6 |        6 |           6 |         6 |        6 |  12 |   13
|GAAAAA   | QLBAAA   | OOOOxx 
!        0 |     998 |   0 |    0 |   0 |      0 |       0 |        0 |           0 |         0 |        0 |   0 |    1
|AAAAAA   | KMBAAA   | OOOOxx 
  (10 rows)

  --
***************
*** 266,290 ****
     WHERE onek2.unique1 > 980;
   unique1 | stringu1
  ---------+----------
!      981 | TLAAAA
!      982 | ULAAAA
       983 | VLAAAA
-      984 | WLAAAA
-      985 | XLAAAA
-      986 | YLAAAA
-      987 | ZLAAAA
-      988 | AMAAAA
       989 | BMAAAA
       990 | CMAAAA
       991 | DMAAAA
!      992 | EMAAAA
       993 | FMAAAA
       994 | GMAAAA
!      995 | HMAAAA
!      996 | IMAAAA
!      997 | JMAAAA
!      998 | KMAAAA
!      999 | LMAAAA
  (19 rows)

  SELECT two, stringu1, ten, string4
--- 267,291 ----
     WHERE onek2.unique1 > 980;
   unique1 | stringu1
  ---------+----------
!      997 | JMAAAA
!      995 | HMAAAA
!      999 | LMAAAA
       983 | VLAAAA
       989 | BMAAAA
+      986 | YLAAAA
+      996 | IMAAAA
+      982 | ULAAAA
+      992 | EMAAAA
       990 | CMAAAA
       991 | DMAAAA
!      984 | WLAAAA
!      981 | TLAAAA
!      998 | KMAAAA
       993 | FMAAAA
       994 | GMAAAA
!      988 | AMAAAA
!      987 | ZLAAAA
!      985 | XLAAAA
  (19 rows)

  SELECT two, stringu1, ten, string4

======================================================================

*** ./expected/select_views.out    Sat Oct 13 13:41:11 2001
--- ./results/select_views.out    Sat Dec  1 21:27:40 2001
***************
*** 6,342 ****
                  name                |

        thepath
                                                                                                          |   cname    

------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------
   Access Rd 25                       | [(-121.9283,37.894),(-121.9283,37.9)]


                                                                                                          | Oakland 
   Agua Fria Creek                    | [(-121.9254,37.922),(-121.9281,37.889)]


                                                                                                          | Oakland 
   Andrea                        Cir  | [(-121.733218,37.88641),(-121.733286,37.90617)]


                                                                                                          | Oakland 
   Apricot                       Lane | [(-121.9471,37.401),(-121.9456,37.392)]


                                                                                                          | Oakland 
-  Arlington                     Dr   | [(-121.8802,37.408),(-121.8807,37.394)]


                                                                                                          | Oakland 
-  Arlington                     Road | [(-121.7957,37.898),(-121.7956,37.906)]


                                                                                                          | Oakland 
-  Arroyo Las Positas                 | [(-121.7973,37.997),(-121.7957,37.005)]


                                                                                                          | Oakland 
-  Arroyo Seco                        | [(-121.7073,37.766),(-121.6997,37.729)]


                                                                                                          | Oakland 
-  Calaveras Creek                    | [(-121.8203,37.035),(-121.8207,37.931)]


                                                                                                          | Oakland 
-  Corriea                       Way  | [(-121.9501,37.402),(-121.9505,37.398)]


                                                                                                          | Oakland 
-  Cowing                        Road | [(-122.0002,37.934),(-121.9772,37.782)]


                                                                                                          | Oakland 
-  Driscoll                      Road | [(-121.9482,37.403),(-121.948451,37.39995)]


                                                                                                          | Oakland 
-  Enos                          Way  | [(-121.7677,37.896),(-121.7673,37.91)]


                                                                                                          | Oakland 
-  Fairview                      Ave  | [(-121.999,37.428),(-121.9863,37.351)]


                                                                                                          | Oakland 
-  I- 580                             | [(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]


                                                                                                          | Oakland 
-  I- 580                             |
[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]


                                                                 | Oakland 
-  I- 580                        Ramp |
[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]


                                                                 | Oakland 
-  I- 580                        Ramp | [(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]


                                                                                                          | Oakland 
-  I- 580                        Ramp |
[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]


                                                                 | Oakland 
-  I- 580                        Ramp |
[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]


                     | Oakland 
-  I- 580/I-680                  Ramp | ((-121.9207,37.988),(-121.9192,37.016))


                                                                                                          | Oakland 
-  I- 680                             |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
                                                                                                       | Oakland 
-  I- 680                             |
[(-121.9101,37.715),(-121.911269,37.74682),(-121.9119,37.764),(-121.9124,37.776),(-121.9174,37.905),(-121.9194,37.957),(-121.9207,37.988)]


                                               | Oakland 
-  I- 680                             | [(-121.9184,37.934),(-121.917,37.913),(-121.9122,37.83),(-121.9052,37.702)]


                                                                                                          | Oakland 
-  I- 680                        Ramp |
[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]


                                                                 | Oakland 
-  I- 680                        Ramp | [(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]


                                                                                                          | Oakland 
-  I- 680                        Ramp | [(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]


                                                                                                          | Oakland 
-  I- 880                             |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))


                                                                 | Oakland 
-  I- 880                             |
[(-121.948,37.933),(-121.9471,37.925),(-121.9467,37.923),(-121.946,37.918),(-121.9452,37.912),(-121.937,37.852)]


                                                                 | Oakland 
-  Johnson                       Dr   | [(-121.9145,37.901),(-121.915,37.877)]


                                                                                                          | Oakland 
-  Juniper                       St   | [(-121.7823,37.897),(-121.7815,37.9)]


                                                                                                          | Oakland 
-  Las Positas                   Road | [(-121.764488,37.99199),(-121.75569,37.02022)]


                                                                                                          | Oakland 
-  Livermore                     Ave  | [(-121.7687,37.448),(-121.769,37.375)]


                                                                                                          | Oakland 
-  Livermore                     Ave  | [(-121.772719,37.99085),(-121.7728,37.001)]


                                                                                                          | Oakland 
-  Mission                       Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]


                                                                                                          | Oakland 
-  Mission                       Blvd | [(-122.0006,37.896),(-121.9989,37.88)]


                                                                                                          | Oakland 
-  Navajo                        Ct   | [(-121.8779,37.901),(-121.8783,37.9)]


                                                                                                          | Oakland 
-  Paseo Padre                   Pkwy | [(-122.0021,37.639),(-121.996,37.628)]


                                                                                                          | Oakland 
-  Pimlico                       Dr   | [(-121.8616,37.998),(-121.8618,37.008)]


                                                                                                          | Oakland 
-  Rosedale                      Ct   | [(-121.9232,37.9),(-121.924,37.897)]


                                                                                                          | Oakland 
-  Saginaw                       Ct   | [(-121.8803,37.898),(-121.8806,37.901)]


                                                                                                          | Oakland 
-  Sp Railroad                        | [(-121.893564,37.99009),(-121.897,37.016)]


                                                                                                          | Oakland 
-  Sp Railroad                        | [(-121.9565,37.898),(-121.9562,37.9)]


                                                                                                          | Oakland 
-  State Hwy 84                       |
[(-121.9565,37.898),(-121.956589,37.89911),(-121.9569,37.903),(-121.956,37.91),(-121.9553,37.919)]


                                                                 | Oakland 
-  Sunol Ridge                   Trl  | [(-121.9419,37.455),(-121.9345,37.38)]


                                                                                                          | Oakland 
-  Tassajara Creek                    | [(-121.87866,37.98898),(-121.8782,37.015)]


                                                                                                          | Oakland 
-  Theresa                       Way  | [(-121.7289,37.906),(-121.728,37.899)]


                                                                                                          | Oakland 
-  Tissiack                      Way  | [(-121.920364,37),(-121.9208,37.995)]


                                                                                                          | Oakland 
-  Vallecitos                    Road | [(-121.8699,37.916),(-121.8703,37.891)]


                                                                                                          | Oakland 
-  Warm Springs                  Blvd | [(-121.933956,37),(-121.9343,37.97)]


                                                                                                          | Oakland 
-  Welch Creek                   Road | [(-121.7695,37.386),(-121.7737,37.413)]


                                                                                                          | Oakland 
-  Whitlock Creek                     | [(-121.74683,37.91276),(-121.733107,37)]


                                                                                                          | Oakland 
-  1st                           St   | [(-121.75508,37.89294),(-121.753581,37.90031)]


                                                                                                          | Oakland 
   Apricot                       Lane | [(-121.9471,37.401),(-121.9456,37.392)]


                                                                                                          | Oakland 
   Arden                         Road | [(-122.0978,37.177),(-122.1,37.177)]


                                                                                                          | Oakland 
   Arlington                     Dr   | [(-121.8802,37.408),(-121.8807,37.394)]


                                                                                                          | Oakland 
   Arroyo Las Positas                 | [(-121.7973,37.997),(-121.7957,37.005)]


                                                                                                          | Oakland 
   Ash                           St   | [(-122.0408,37.31),(-122.04,37.292)]


                                                                                                          | Oakland 
-  Bridgepointe                  Dr   | [(-122.0514,37.305),(-122.0509,37.299)]


                                                                                                          | Oakland 
-  Butterfield                   Dr   | [(-122.0838,37.002),(-122.0834,37.987)]


                                                                                                          | Oakland 
-  Calaveras Creek                    | [(-121.8203,37.035),(-121.8207,37.931)]


                                                                                                          | Oakland 
-  Celia                         St   | [(-122.0611,37.3),(-122.0616,37.299)]


                                                                                                          | Oakland 
-  Claremont                     Pl   | [(-122.0542,37.995),(-122.0542,37.008)]


                                                                                                          | Oakland 
-  Corriea                       Way  | [(-121.9501,37.402),(-121.9505,37.398)]


                                                                                                          | Oakland 
-  Crystaline                    Dr   | [(-121.925856,37),(-121.925869,37.00527)]


                                                                                                          | Oakland 
-  Decoto                        Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]


                                                                                                          | Oakland 
-  Driscoll                      Road | [(-121.9482,37.403),(-121.948451,37.39995)]


                                                                                                          | Oakland 
-  Eden Creek                         | [(-122.022037,37.00675),(-122.0221,37.998)]


                                                                                                          | Oakland 
-  Fairview                      Ave  | [(-121.999,37.428),(-121.9863,37.351)]


                                                                                                          | Oakland 
-  Hesperian                     Blvd | [(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]


                                                                                                          | Oakland 
-  I- 580                             |
[(-121.727,37.074),(-121.7229,37.093),(-121.722301,37.09522),(-121.721001,37.10005),(-121.7194,37.106),(-121.7188,37.109),(-121.7168,37.12),(-121.7163,37.123),(-121.7145,37.127),(-121.7096,37.148),(-121.707731,37.1568),(-121.7058,37.166),(-121.7055,37.168),(-121.7044,37.174),(-121.7038,37.172),(-121.7037,37.172),(-121.7027,37.175),(-121.7001,37.181),(-121.6957,37.191),(-121.6948,37.192),(-121.6897,37.204),(-121.6697,37.185)]
|Oakland 
-  I- 580                             | [(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]


                                                                                                          | Oakland 
-  I- 580                             |
[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]


                                                                 | Oakland 
-  I- 580                        Ramp |
[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]


                                                                 | Oakland 
-  I- 580                        Ramp | [(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]


                                                                                                          | Oakland 
-  I- 580                        Ramp |
[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]


                                                                 | Oakland 
-  I- 580                        Ramp |
[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]


                     | Oakland 
-  I- 580/I-680                  Ramp | ((-121.9207,37.988),(-121.9192,37.016))


                                                                                                          | Oakland 
-  I- 680                             |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
                                                                                                       | Oakland 
-  I- 680                        Ramp |
[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]


                                                                 | Oakland 
-  I- 680                        Ramp | [(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]


                                                                                                          | Oakland 
-  I- 680                        Ramp | [(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]


                                                                                                          | Oakland 
-  I- 880                             |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))


                                                                 | Oakland 
-  I- 880                             |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]

                                                                        | Oakland 
-  I- 880                             |
[(-122.0831,37.312),(-122.0819,37.296),(-122.081,37.285),(-122.0786,37.248),(-122.078,37.24),(-122.077642,37.23496),(-122.076983,37.22567),(-122.076599,37.22026),(-122.076229,37.21505),(-122.0758,37.209)]

                                                                                                      | Oakland 
-  I- 880                        Ramp | [(-122.0019,37.301),(-122.002,37.293)]


                                                                                                          | Oakland 
-  I- 880                        Ramp |
[(-122.0041,37.313),(-122.0018,37.315),(-122.0007,37.315),(-122.0005,37.313),(-122.0002,37.308),(-121.9995,37.289)]


                                                                 | Oakland 
-  I- 880                        Ramp |
[(-122.0041,37.313),(-122.0038,37.308),(-122.0039,37.284),(-122.0013,37.287),(-121.9995,37.289)]


                                                                 | Oakland 
-  I- 880                        Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]


                                                                                                          | Oakland 
-  I- 880                        Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]


                                                                                                          | Oakland 
-  I- 880                        Ramp | [(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]


                                                                                                          | Oakland 
-  I- 880                        Ramp | [(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]


                                                                                                          | Oakland 
-  Kildare                       Road | [(-122.0968,37.016),(-122.0959,37)]


                                                                                                          | Oakland 
-  Las Positas                   Road | [(-121.764488,37.99199),(-121.75569,37.02022)]


                                                                                                          | Oakland 
-  Livermore                     Ave  | [(-121.7687,37.448),(-121.769,37.375)]


                                                                                                          | Oakland 
-  Livermore                     Ave  | [(-121.772719,37.99085),(-121.7728,37.001)]


                                                                                                          | Oakland 
-  Mildred                       Ct   | [(-122.0002,37.388),(-121.9998,37.386)]


                                                                                                          | Oakland 
-  Miramar                       Ave  | [(-122.1009,37.025),(-122.099089,37.03209)]


                                                                                                          | Oakland 
-  Mission                       Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]


                                                                                                          | Oakland 
-  Moores                        Ave  | [(-122.0087,37.301),(-122.0094,37.292)]


                                                                                                          | Oakland 
-  Oakridge                      Road | [(-121.8316,37.049),(-121.828382,37)]


                                                                                                          | Oakland 
-  Paseo Padre                   Pkwy | [(-121.9143,37.005),(-121.913522,37)]


                                                                                                          | Oakland 
-  Periwinkle                    Road | [(-122.0451,37.301),(-122.044758,37.29844)]


                                                                                                          | Oakland 
-  Pimlico                       Dr   | [(-121.8616,37.998),(-121.8618,37.008)]


                                                                                                          | Oakland 
-  Railroad                      Ave  | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]


                                                                                                          | Oakland 
-  Ranspot                       Dr   | [(-122.0972,37.999),(-122.0959,37)]


                                                                                                          | Oakland 
-  Santa Maria                   Ave  | [(-122.0773,37),(-122.0773,37.98)]


                                                                                                          | Oakland 
-  Sp Railroad                        | [(-121.893564,37.99009),(-121.897,37.016)]


                                                                                                          | Oakland 
-  Sp Railroad                        | [(-122.0734,37.001),(-122.0734,37.997)]


                                                                                                          | Oakland 
-  Stanton                       Ave  | [(-122.100392,37.0697),(-122.099513,37.06052)]


                                                                                                          | Oakland 
-  Sunol Ridge                   Trl  | [(-121.9419,37.455),(-121.9345,37.38)]


                                                                                                          | Oakland 
-  Tassajara Creek                    | [(-121.87866,37.98898),(-121.8782,37.015)]


                                                                                                          | Oakland 
-  Thackeray                     Ave  | [(-122.072,37.305),(-122.0715,37.298)]


                                                                                                          | Oakland 
-  Tissiack                      Way  | [(-121.920364,37),(-121.9208,37.995)]


                                                                                                          | Oakland 
-  Warm Springs                  Blvd | [(-121.933956,37),(-121.9343,37.97)]


                                                                                                          | Oakland 
-  Welch Creek                   Road | [(-121.7695,37.386),(-121.7737,37.413)]


                                                                                                          | Oakland 
-  Western Pacific Railroad Spur      | [(-122.0394,37.018),(-122.0394,37.961)]


                                                                                                          | Oakland 
-  Whitlock Creek                     | [(-121.74683,37.91276),(-121.733107,37)]


                                                                                                          | Oakland 
   Avenue 134th                       | [(-122.1823,37.002),(-122.1851,37.992)]


                                                                                                          | Oakland 
   Avenue 140th                       | [(-122.1656,37.003),(-122.1691,37.988)]


                                                                                                          | Oakland 
   B                             St   | [(-122.1749,37.451),(-122.1743,37.443)]


                                                                                                          | Oakland 
   Bancroft                      Ave  | [(-122.15714,37.4242),(-122.156,37.409)]


                                                                                                          | Oakland 
   Bancroft                      Ave  | [(-122.1643,37.523),(-122.1631,37.508),(-122.1621,37.493)]


                                                                                                          | Oakland 
   Birch                         St   | [(-122.1617,37.425),(-122.1614,37.417)]


                                                                                                          | Oakland 
   Birch                         St   | [(-122.1673,37.509),(-122.1661,37.492)]


                                                                                                          | Oakland 
   Blacow                        Road | [(-122.0179,37.469),(-122.0167,37.465)]


                                                                                                          | Oakland 
   Broadmore                     Ave  | [(-122.095,37.522),(-122.0936,37.497)]


                                                                                                          | Oakland 
-  Butterfield                   Dr   | [(-122.0838,37.002),(-122.0834,37.987)]


                                                                                                          | Oakland 
-  C                             St   | [(-122.1768,37.46),(-122.1749,37.435)]


                                                                                                          | Oakland 
-  Cameron                       Ave  | [(-122.1316,37.502),(-122.1327,37.481)]


                                                                                                          | Oakland 
-  Cedar                         Blvd | [(-122.0282,37.446),(-122.0265,37.43)]


                                                                                                          | Oakland 
-  Chapman                       Dr   | [(-122.0421,37.504),(-122.0414,37.498)]


                                                                                                          | Oakland 
-  Charles                       St   | [(-122.0255,37.505),(-122.0252,37.499)]


                                                                                                          | Oakland 
-  Cherry                        St   | [(-122.0437,37.42),(-122.0434,37.413)]


                                                                                                          | Oakland 
-  Claremont                     Pl   | [(-122.0542,37.995),(-122.0542,37.008)]


                                                                                                          | Oakland 
-  Coliseum                      Way  | [(-122.2001,37.47),(-122.1978,37.516)]


                                                                                                          | Oakland 
-  Cull Canyon                   Road | [(-122.0536,37.435),(-122.0499,37.315)]


                                                                                                          | Oakland 
-  D                             St   | [(-122.1811,37.505),(-122.1805,37.497)]


                                                                                                          | Oakland 
-  Decoto                        Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]


                                                                                                          | Oakland 
-  Driftwood                     Dr   | [(-122.0109,37.482),(-122.0113,37.477)]


                                                                                                          | Oakland 
-  E                             St   | [(-122.1832,37.505),(-122.1826,37.498),(-122.182,37.49)]


                                                                                                          | Oakland 
-  Eden                          Ave  | [(-122.1143,37.505),(-122.1142,37.491)]


                                                                                                          | Oakland 
-  Eden Creek                         | [(-122.022037,37.00675),(-122.0221,37.998)]


                                                                                                          | Oakland 
-  Gading                        Road | [(-122.0801,37.343),(-122.08,37.336)]


                                                                                                          | Oakland 
-  Harris                        Road | [(-122.0659,37.372),(-122.0675,37.363)]


                                                                                                          | Oakland 
-  Hegenberger                   Exwy | [(-122.1946,37.52),(-122.1947,37.497)]


                                                                                                          | Oakland 
-  Herrier                       St   | [(-122.1943,37.006),(-122.1936,37.998)]


                                                                                                          | Oakland 
-  Hesperian                     Blvd | [(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]


                                                                                                          | Oakland 
-  I- 580                             |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]

                                       | Oakland 
-  I- 580                             |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
                          | Oakland 
-  I- 580                        Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]


                                                                                                          | Oakland 
-  I- 580                        Ramp | [(-122.1414,37.383),(-122.1407,37.376),(-122.1403,37.372),(-122.139,37.356)]


                                                                                                          | Oakland 
-  I- 880                             |
[(-122.0219,37.466),(-122.0205,37.447),(-122.020331,37.44447),(-122.020008,37.43962),(-122.0195,37.432),(-122.0193,37.429),(-122.0164,37.393),(-122.010219,37.34771),(-122.0041,37.313)]


 | Oakland 
-  I- 880                             |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]

                                               | Oakland 
-  I- 880                             |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]

                                                                        | Oakland 
-  I- 880                             |
[(-122.0978,37.528),(-122.096,37.496),(-122.0931,37.453),(-122.09277,37.4496),(-122.090189,37.41442),(-122.0896,37.405),(-122.085,37.34)]


                                                | Oakland 
-  I- 880                             |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
                                                   | Oakland 
-  I- 880                        Ramp |
[(-122.0236,37.488),(-122.0231,37.458),(-122.0227,37.458),(-122.0223,37.452),(-122.0205,37.447)]


                                                                 | Oakland 
-  I- 880                        Ramp | [(-122.0238,37.491),(-122.0215,37.483),(-122.0211,37.477),(-122.0205,37.447)]


                                                                                                          | Oakland 
-  I- 880                        Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]


                                                                                                          | Oakland 
-  I- 880                        Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]


                                                                                                          | Oakland 
-  I- 880                        Ramp | [(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]


                                                                                                          | Oakland 
-  I- 880                        Ramp | [(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]


                                                                                                          | Oakland 
-  Kaiser                        Dr   | [(-122.067163,37.47821),(-122.060402,37.51961)]


                                                                                                          | Oakland 
-  La Playa                      Dr   | [(-122.1039,37.545),(-122.101,37.493)]


                                                                                                          | Oakland 
-  Locust                        St   | [(-122.1606,37.007),(-122.1593,37.987)]


                                                                                                          | Oakland 
-  Logan                         Ct   | [(-122.0053,37.492),(-122.0061,37.484)]


                                                                                                          | Oakland 
-  Magnolia                      St   | [(-122.0971,37.5),(-122.0962,37.484)]


                                                                                                          | Oakland 
-  Mattos                        Dr   | [(-122.0005,37.502),(-122.000898,37.49683)]


                                                                                                          | Oakland 
-  Maubert                       Ave  | [(-122.1114,37.009),(-122.1096,37.995)]


                                                                                                          | Oakland 
-  McClure                       Ave  | [(-122.1431,37.001),(-122.1436,37.998)]


                                                                                                          | Oakland 
-  Medlar                        Dr   | [(-122.0627,37.378),(-122.0625,37.375)]


                                                                                                          | Oakland 
-  National                      Ave  | [(-122.1192,37.5),(-122.1281,37.489)]


                                                                                                          | Oakland 
-  Newark                        Blvd | [(-122.0352,37.438),(-122.0341,37.423)]


                                                                                                          | Oakland 
-  Portsmouth                    Ave  | [(-122.1064,37.315),(-122.1064,37.308)]


                                                                                                          | Oakland 
-  Railroad                      Ave  | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]


                                                                                                          | Oakland 
-  Ranspot                       Dr   | [(-122.0972,37.999),(-122.0959,37)]


                                                                                                          | Oakland 
-  Redwood                       Road | [(-122.1493,37.98),(-122.1437,37.001)]


                                                                                                          | Oakland 
-  Santa Maria                   Ave  | [(-122.0773,37),(-122.0773,37.98)]


                                                                                                          | Oakland 
-  Skyline                       Blvd | [(-122.1738,37.01),(-122.1714,37.996)]


                                                                                                          | Oakland 
-  Skyline                       Dr   | [(-122.0277,37.5),(-122.0284,37.498)]


                                                                                                          | Oakland 
-  Sp Railroad                        | [(-122.0734,37.001),(-122.0734,37.997)]


                                                                                                          | Oakland 
-  Sp Railroad                        | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]


                                                                                                          | Oakland 
-  Sp Railroad                        | [(-122.1947,37.497),(-122.193328,37.4848)]


                                                                                                          | Oakland 
-  State Hwy 84                       | [(-122.0671,37.426),(-122.07,37.402),(-122.074,37.37),(-122.0773,37.338)]


                                                                                                          | Oakland 
-  State Hwy 92                       |
[(-122.1085,37.326),(-122.1095,37.322),(-122.1111,37.316),(-122.1119,37.313),(-122.1125,37.311),(-122.1131,37.308),(-122.1167,37.292),(-122.1187,37.285),(-122.12,37.28)]


                | Oakland 
-  State Hwy 92                  Ramp | [(-122.1086,37.321),(-122.1089,37.315),(-122.1111,37.316)]


                                                                                                          | Oakland 
-  Tennyson                      Road | [(-122.0891,37.317),(-122.0927,37.317)]


                                                                                                          | Oakland 
-  Western Pacific Railroad Spur      | [(-122.0394,37.018),(-122.0394,37.961)]


                                                                                                          | Oakland 
-  Willimet                      Way  | [(-122.0964,37.517),(-122.0949,37.493)]


                                                                                                          | Oakland 
-  Wisconsin                     St   | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]


                                                                                                          | Oakland 
-  100th                         Ave  | [(-122.1657,37.429),(-122.1647,37.432)]


                                                                                                          | Oakland 
-  107th                         Ave  | [(-122.1555,37.403),(-122.1531,37.41)]


                                                                                                          | Oakland 
-  85th                          Ave  | [(-122.1877,37.466),(-122.186,37.476)]


                                                                                                          | Oakland 
-  89th                          Ave  | [(-122.1822,37.459),(-122.1803,37.471)]


                                                                                                          | Oakland 
-  98th                          Ave  | [(-122.1568,37.498),(-122.1558,37.502)]


                                                                                                          | Oakland 
-  98th                          Ave  | [(-122.1693,37.438),(-122.1682,37.444)]


                                                                                                          | Oakland 
-  Allen                         Ct   | [(-122.0131,37.602),(-122.0117,37.597)]


                                                                                                          | Berkeley 
-  Alvarado Niles                Road | [(-122.0325,37.903),(-122.0316,37.9)]


                                                                                                          | Berkeley 
-  Arizona                       St   | [(-122.0381,37.901),(-122.0367,37.898)]


                                                                                                          | Berkeley 
-  Avenue 134th                       | [(-122.1823,37.002),(-122.1851,37.992)]


                                                                                                          | Berkeley 
-  Avenue 140th                       | [(-122.1656,37.003),(-122.1691,37.988)]


                                                                                                          | Berkeley 
-  Avenue D                           | [(-122.298,37.848),(-122.3024,37.849)]


                                                                                                          | Berkeley 
   Broadway                           | [(-122.2409,37.586),(-122.2395,37.601)]


                                                                                                          | Berkeley 
   Buckingham                    Blvd | [(-122.2231,37.59),(-122.2214,37.606)]


                                                                                                          | Berkeley 
   Butterfield                   Dr   | [(-122.0838,37.002),(-122.0834,37.987)]


                                                                                                          | Berkeley 
   California                    St   | [(-122.2032,37.005),(-122.2016,37.996)]


                                                                                                          | Berkeley 
   Campus                        Dr   | [(-122.1704,37.905),(-122.1678,37.868),(-122.1671,37.865)]


                                                                                                          | Berkeley 
   Carson                        St   | [(-122.1846,37.9),(-122.1843,37.901)]


                                                                                                          | Berkeley 
   Cedar                         St   | [(-122.3011,37.737),(-122.2999,37.739)]


                                                                                                          | Berkeley 
   Central                       Ave  | [(-122.2343,37.602),(-122.2331,37.595)]


                                                                                                          | Berkeley 
   Champion                      St   | [(-122.214,37.991),(-122.2147,37.002)]


                                                                                                          | Berkeley 
   Claremont                     Pl   | [(-122.0542,37.995),(-122.0542,37.008)]


                                                                                                          | Berkeley 
   Coliseum                      Way  | [(-122.2113,37.626),(-122.2085,37.592),(-122.2063,37.568)]


                                                                                                          | Berkeley 
   Cornell                       Ave  | [(-122.2956,37.925),(-122.2949,37.906),(-122.2939,37.875)]


                                                                                                          | Berkeley 
   Creston                       Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]


                                                                                                          | Berkeley 
   Crow Canyon Creek                  | [(-122.043,37.905),(-122.0368,37.71)]


                                                                                                          | Berkeley 
   Cull Creek                         | [(-122.0624,37.875),(-122.0582,37.527)]


                                                                                                          | Berkeley 
   Decoto                        Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]


                                                                                                          | Berkeley 
   Deering                       St   | [(-122.2146,37.904),(-122.2126,37.897)]


                                                                                                          | Berkeley 
   Dimond                        Ave  | [(-122.2167,37.994),(-122.2162,37.006)]


                                                                                                          | Berkeley 
   Donna                         Way  | [(-122.1333,37.606),(-122.1316,37.599)]


                                                                                                          | Berkeley 
   Eden Creek                         | [(-122.022037,37.00675),(-122.0221,37.998)]


                                                                                                          | Berkeley 
   Euclid                        Ave  | [(-122.2671,37.009),(-122.2666,37.987)]


                                                                                                          | Berkeley 
   Foothill                      Blvd | [(-122.2414,37.9),(-122.2403,37.893)]


                                                                                                          | Berkeley 
   Fountain                      St   | [(-122.2306,37.593),(-122.2293,37.605)]


                                                                                                          | Berkeley 
   Grizzly Peak                  Blvd | [(-122.2213,37.638),(-122.2127,37.581)]


                                                                                                          | Berkeley 
   Grove                         Way  |
[(-122.0643,37.884),(-122.062679,37.89162),(-122.061796,37.89578),(-122.0609,37.9)]


                                                                 | Berkeley 
   Herrier                       St   | [(-122.1943,37.006),(-122.1936,37.998)]


                                                                                                          | Berkeley 
   Hesperian                     Blvd | [(-122.1132,37.6),(-122.1123,37.586)]


                                                                                                          | Berkeley 
   I- 580                             |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]

                                       | Berkeley 
   I- 580                             |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
                          | Berkeley 
   I- 580                             |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]

                                                                      | Berkeley 
   I- 580                        Ramp | [(-122.093241,37.90351),(-122.09364,37.89634),(-122.093788,37.89212)]


                                                                                                          | Berkeley 
   I- 580                        Ramp | [(-122.0934,37.896),(-122.09257,37.89961),(-122.0911,37.906)]


                                                                                                          | Berkeley 
   I- 580                        Ramp | [(-122.0941,37.897),(-122.0943,37.902)]


                                                                                                          | Berkeley 
   I- 580                        Ramp | [(-122.096,37.888),(-122.0962,37.891),(-122.0964,37.9)]


                                                                                                          | Berkeley 
   I- 580                        Ramp | [(-122.101,37.898),(-122.1005,37.902),(-122.0989,37.911)]


                                                                                                          | Berkeley 
   I- 580                        Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]


                                                                                                          | Berkeley 
   I- 880                             |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]

                                               | Berkeley 
   I- 880                             |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]

                                                                        | Berkeley 
   I- 880                             |
[(-122.1365,37.902),(-122.1358,37.898),(-122.1333,37.881),(-122.1323,37.874),(-122.1311,37.866),(-122.1308,37.865),(-122.1307,37.864),(-122.1289,37.851),(-122.1277,37.843),(-122.1264,37.834),(-122.1231,37.812),(-122.1165,37.766),(-122.1104,37.72),(-122.109695,37.71094),(-122.109,37.702),(-122.108312,37.69168),(-122.1076,37.681)]
                                                                                                 | Berkeley 
   I- 880                             |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
                                                   | Berkeley 
   I- 880                             |
[(-122.2214,37.711),(-122.2202,37.699),(-122.2199,37.695),(-122.219,37.682),(-122.2184,37.672),(-122.2173,37.652),(-122.2159,37.638),(-122.2144,37.616),(-122.2138,37.612),(-122.2135,37.609),(-122.212,37.592),(-122.2116,37.586),(-122.2111,37.581)]

                                                            | Berkeley 
   I- 880                             |
[(-122.2707,37.975),(-122.2693,37.972),(-122.2681,37.966),(-122.267,37.962),(-122.2659,37.957),(-122.2648,37.952),(-122.2636,37.946),(-122.2625,37.935),(-122.2617,37.927),(-122.2607,37.921),(-122.2593,37.916),(-122.258,37.911),(-122.2536,37.898),(-122.2432,37.858),(-122.2408,37.845),(-122.2386,37.827),(-122.2374,37.811)]
                                                                                                         | Berkeley 
   I- 880                        Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]


                                                                                                          | Berkeley 
   I- 880                        Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]


                                                                                                          | Berkeley 
   I- 880                        Ramp | [(-122.1029,37.61),(-122.1013,37.587),(-122.0999,37.569)]


                                                                                                          | Berkeley 
   I- 880                        Ramp | [(-122.1379,37.891),(-122.1383,37.897),(-122.1377,37.902)]


                                                                                                          | Berkeley 
   I- 880                        Ramp |
[(-122.1379,37.931),(-122.137597,37.92736),(-122.1374,37.925),(-122.1373,37.924),(-122.1369,37.914),(-122.1358,37.905),(-122.1365,37.908),(-122.1358,37.898)]


                            | Berkeley 
   I- 880                        Ramp | [(-122.2536,37.898),(-122.254,37.902)]


                                                                                                          | Berkeley 
   Jackson                       St   | [(-122.0845,37.6),(-122.0842,37.606)]


                                                                                                          | Berkeley 
   Joyce                         St   | [(-122.0792,37.604),(-122.0774,37.581)]


                                                                                                          | Berkeley 
   Keeler                        Ave  | [(-122.2578,37.906),(-122.2579,37.899)]


                                                                                                          | Berkeley 
   Laguna                        Ave  | [(-122.2099,37.989),(-122.2089,37)]


                                                                                                          | Berkeley 
   Lakehurst                     Cir  | [(-122.284729,37.89025),(-122.286096,37.90364)]


                                                                                                          | Berkeley 
   Lakeshore                     Ave  | [(-122.2586,37.99),(-122.2556,37.006)]


                                                                                                          | Berkeley 
   Linden                        St   | [(-122.2867,37.998),(-122.2864,37.008)]


                                                                                                          | Berkeley 
   Locust                        St   | [(-122.1606,37.007),(-122.1593,37.987)]


                                                                                                          | Berkeley 
   Marin                         Ave  | [(-122.2741,37.894),(-122.272,37.901)]


                                                                                                          | Berkeley 
   Martin Luther King Jr         Way  | [(-122.2712,37.608),(-122.2711,37.599)]


                                                                                                          | Berkeley 
   Maubert                       Ave  | [(-122.1114,37.009),(-122.1096,37.995)]


                                                                                                          | Berkeley 
   McClure                       Ave  | [(-122.1431,37.001),(-122.1436,37.998)]


                                                                                                          | Berkeley 
   Miller                        Road | [(-122.0902,37.645),(-122.0865,37.545)]


                                                                                                          | Berkeley 
   Mission                       Blvd | [(-122.0006,37.896),(-121.9989,37.88)]


                                                                                                          | Berkeley 
   Oakland Inner Harbor               | [(-122.2625,37.913),(-122.260016,37.89484)]


                                                                                                          | Berkeley 
   Oneil                         Ave  | [(-122.076754,37.62476),(-122.0745,37.595)]


                                                                                                          | Berkeley 
   Parkridge                     Dr   | [(-122.1438,37.884),(-122.1428,37.9)]


                                                                                                          | Berkeley 
   Parkside                      Dr   | [(-122.0475,37.603),(-122.0443,37.596)]


                                                                                                          | Berkeley 
   Paseo Padre                   Pkwy | [(-122.0021,37.639),(-121.996,37.628)]


                                                                                                          | Berkeley 
   Pearl                         St   | [(-122.2383,37.594),(-122.2366,37.615)]


                                                                                                          | Berkeley 
   Railroad                      Ave  | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]


                                                                                                          | Berkeley 
   Ranspot                       Dr   | [(-122.0972,37.999),(-122.0959,37)]


                                                                                                          | Berkeley 
   Redding                       St   | [(-122.1978,37.901),(-122.1975,37.895)]


                                                                                                          | Berkeley 
   Redwood                       Road | [(-122.1493,37.98),(-122.1437,37.001)]


                                                                                                          | Berkeley 
   Roca                          Dr   | [(-122.0335,37.609),(-122.0314,37.599)]


                                                                                                          | Berkeley 
   Sacramento                    St   | [(-122.2799,37.606),(-122.2797,37.597)]


                                                                                                          | Berkeley 
   Saddle Brook                  Dr   | [(-122.1478,37.909),(-122.1454,37.904),(-122.1451,37.888)]


                                                                                                          | Berkeley 
   San Andreas                   Dr   | [(-122.0609,37.9),(-122.0614,37.895)]


                                                                                                          | Berkeley 
   Santa Maria                   Ave  | [(-122.0773,37),(-122.0773,37.98)]


                                                                                                          | Berkeley 
   Shattuck                      Ave  | [(-122.2686,37.904),(-122.2686,37.897)]


                                                                                                          | Berkeley 
   Shoreline                     Dr   | [(-122.2657,37.603),(-122.2648,37.6)]


                                                                                                          | Berkeley 
   Skyline                       Blvd | [(-122.1738,37.01),(-122.1714,37.996)]


                                                                                                          | Berkeley 
   Skywest                       Dr   | [(-122.1161,37.62),(-122.1123,37.586)]


                                                                                                          | Berkeley 
   Southern Pacific Railroad          | [(-122.3002,37.674),(-122.2999,37.661)]


                                                                                                          | Berkeley 
   Sp Railroad                        | [(-122.0734,37.001),(-122.0734,37.997)]


                                                                                                          | Berkeley 
   Sp Railroad                        | [(-122.0914,37.601),(-122.087,37.56),(-122.086408,37.5551)]


                                                                                                          | Berkeley 
   Sp Railroad                        | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]


                                                                                                          | Berkeley 
   State Hwy 123                      |
[(-122.3004,37.986),(-122.2998,37.969),(-122.2995,37.962),(-122.2992,37.952),(-122.299,37.942),(-122.2987,37.935),(-122.2984,37.924),(-122.2982,37.92),(-122.2976,37.904),(-122.297,37.88),(-122.2966,37.869),(-122.2959,37.848),(-122.2961,37.843)]

                                                              | Berkeley 
   State Hwy 13                       |
[(-122.1797,37.943),(-122.179871,37.91849),(-122.18,37.9),(-122.179023,37.86615),(-122.1787,37.862),(-122.1781,37.851),(-122.1777,37.845),(-122.1773,37.839),(-122.177,37.833)]


          | Berkeley 
   State Hwy 238                      |
((-122.098,37.908),(-122.0983,37.907),(-122.099,37.905),(-122.101,37.898),(-122.101535,37.89711),(-122.103173,37.89438),(-122.1046,37.892),(-122.106,37.89))


                             | Berkeley 
   State Hwy 238                 Ramp | [(-122.1288,37.9),(-122.1293,37.895),(-122.1296,37.906)]


                                                                                                          | Berkeley 
   Stuart                        St   | [(-122.2518,37.6),(-122.2507,37.601),(-122.2491,37.606)]


                                                                                                          | Berkeley 
   Tupelo                        Ter  | [(-122.059087,37.6113),(-122.057021,37.59942)]


                                                                                                          | Berkeley 
   West Loop                     Road | [(-122.0576,37.604),(-122.0602,37.586)]


                                                                                                          | Berkeley 
   Western Pacific Railroad Spur      | [(-122.0394,37.018),(-122.0394,37.961)]


                                                                                                          | Berkeley 
   Wisconsin                     St   | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]


                                                                                                          | Berkeley 
   Wp Railroad                        | [(-122.254,37.902),(-122.2506,37.891)]


                                                                                                          | Berkeley 
   19th                          Ave  | [(-122.2366,37.897),(-122.2359,37.905)]


                                                                                                          | Berkeley 
   5th                           St   | [(-122.296,37.615),(-122.2953,37.598)]


                                                                                                          | Berkeley 
   82nd                          Ave  | [(-122.1695,37.596),(-122.1681,37.603)]


                                                                                                          | Berkeley 
!  Ada                           St   | [(-122.2487,37.398),(-122.2496,37.401)]


                                                                                                          | Lafayette 
!  California                    St   | [(-122.2032,37.005),(-122.2016,37.996)]


                                                                                                          | Lafayette 
!  Capricorn                     Ave  | [(-122.2176,37.404),(-122.2164,37.384)]


                                                                                                          | Lafayette 
!  Chambers                      Dr   | [(-122.2004,37.352),(-122.1972,37.368)]


                                                                                                          | Lafayette 
!  Chambers                      Lane | [(-122.2001,37.359),(-122.1975,37.371)]


                                                                                                          | Lafayette 
!  Champion                      St   | [(-122.214,37.991),(-122.2147,37.002)]


                                                                                                          | Lafayette 
!  Coolidge                      Ave  | [(-122.2007,37.058),(-122.1992,37.06)]


                                                                                                          | Lafayette 
!  Creston                       Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]


                                                                                                          | Lafayette 
!  Dimond                        Ave  | [(-122.2167,37.994),(-122.2162,37.006)]


                                                                                                          | Lafayette 
!  Edgewater                     Dr   | [(-122.201,37.379),(-122.2042,37.41)]


                                                                                                          | Lafayette 
!  Euclid                        Ave  | [(-122.2671,37.009),(-122.2666,37.987)]


                                                                                                          | Lafayette 
!  Heartwood                     Dr   | [(-122.2006,37.341),(-122.1992,37.338)]


                                                                                                          | Lafayette 
!  Hollis                        St   | [(-122.2885,37.397),(-122.289,37.414)]


                                                                                                          | Lafayette 
!  I- 580                             |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]

                                                                      | Lafayette 
!  I- 80                              | ((-122.2937,37.277),(-122.3016,37.262))


                                                                                                          | Lafayette 
!  I- 80                              | ((-122.2962,37.273),(-122.3004,37.264))


                                                                                                          | Lafayette 
!  I- 80                         Ramp | [(-122.2962,37.413),(-122.2959,37.382),(-122.2951,37.372)]


                                                                                                          | Lafayette 
!  I- 880                        Ramp | [(-122.2771,37.002),(-122.278,37)]


                                                                                                          | Lafayette 
!  Indian                        Way  | [(-122.2066,37.398),(-122.2045,37.411)]


                                                                                                          | Lafayette 
!  Laguna                        Ave  | [(-122.2099,37.989),(-122.2089,37)]


                                                                                                          | Lafayette 
!  Lakeshore                     Ave  | [(-122.2586,37.99),(-122.2556,37.006)]


                                                                                                          | Lafayette 
!  Linden                        St   | [(-122.2867,37.998),(-122.2864,37.008)]


                                                                                                          | Lafayette 
!  Mandalay                      Road | [(-122.2322,37.397),(-122.2321,37.403)]


                                                                                                          | Lafayette 
!  Proctor                       Ave  | [(-122.2267,37.406),(-122.2251,37.386)]


                                                                                                          | Lafayette 
!  Sheridan                      Road | [(-122.2279,37.425),(-122.2253,37.411),(-122.2223,37.377)]


                                                                                                          | Lafayette 
!  State Hwy 13                       |
[(-122.2049,37.2),(-122.20328,37.17975),(-122.1989,37.125),(-122.198078,37.11641),(-122.1975,37.11)]


                                                                 | Lafayette 
!  State Hwy 13                  Ramp | [(-122.2244,37.427),(-122.223,37.414),(-122.2214,37.396),(-122.2213,37.388)]


                                                                                                          | Lafayette 
!  State Hwy 24                       |
[(-122.2674,37.246),(-122.2673,37.248),(-122.267,37.261),(-122.2668,37.271),(-122.2663,37.298),(-122.2659,37.315),(-122.2655,37.336),(-122.265007,37.35882),(-122.264443,37.37286),(-122.2641,37.381),(-122.2638,37.388),(-122.2631,37.396),(-122.2617,37.405),(-122.2615,37.407),(-122.2605,37.412)]

             | Lafayette 
!  Taurus                        Ave  | [(-122.2159,37.416),(-122.2128,37.389)]


                                                                                                          | Lafayette 
!  14th                          St   | [(-122.299,37.147),(-122.3,37.148)]


                                                                                                          | Lafayette 
!  5th                           St   | [(-122.278,37),(-122.2792,37.005),(-122.2803,37.009)]


                                                                                                          | Lafayette 
   98th                          Ave  | [(-122.2001,37.258),(-122.1974,37.27)]


                                                                                                          | Lafayette 
  (333 rows)

--- 6,342 ----
                  name                |

        thepath
                                                                                                          |   cname    

------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------
   Access Rd 25                       | [(-121.9283,37.894),(-121.9283,37.9)]


                                                                                                          | Oakland 
+  Ada                           St   | [(-122.2487,37.398),(-122.2496,37.401)]


                                                                                                          | Lafayette 
   Agua Fria Creek                    | [(-121.9254,37.922),(-121.9281,37.889)]


                                                                                                          | Oakland 
+  Allen                         Ct   | [(-122.0131,37.602),(-122.0117,37.597)]


                                                                                                          | Berkeley 
+  Alvarado Niles                Road | [(-122.0325,37.903),(-122.0316,37.9)]


                                                                                                          | Berkeley 
   Andrea                        Cir  | [(-121.733218,37.88641),(-121.733286,37.90617)]


                                                                                                          | Oakland 
   Apricot                       Lane | [(-121.9471,37.401),(-121.9456,37.392)]


                                                                                                          | Oakland 
   Apricot                       Lane | [(-121.9471,37.401),(-121.9456,37.392)]


                                                                                                          | Oakland 
   Arden                         Road | [(-122.0978,37.177),(-122.1,37.177)]


                                                                                                          | Oakland 
+  Arizona                       St   | [(-122.0381,37.901),(-122.0367,37.898)]


                                                                                                          | Berkeley 
+  Arlington                     Dr   | [(-121.8802,37.408),(-121.8807,37.394)]


                                                                                                          | Oakland 
   Arlington                     Dr   | [(-121.8802,37.408),(-121.8807,37.394)]


                                                                                                          | Oakland 
+  Arlington                     Road | [(-121.7957,37.898),(-121.7956,37.906)]


                                                                                                          | Oakland 
+  Arroyo Las Positas                 | [(-121.7973,37.997),(-121.7957,37.005)]


                                                                                                          | Oakland 
   Arroyo Las Positas                 | [(-121.7973,37.997),(-121.7957,37.005)]


                                                                                                          | Oakland 
+  Arroyo Seco                        | [(-121.7073,37.766),(-121.6997,37.729)]


                                                                                                          | Oakland 
   Ash                           St   | [(-122.0408,37.31),(-122.04,37.292)]


                                                                                                          | Oakland 
   Avenue 134th                       | [(-122.1823,37.002),(-122.1851,37.992)]


                                                                                                          | Oakland 
+  Avenue 134th                       | [(-122.1823,37.002),(-122.1851,37.992)]


                                                                                                          | Berkeley 
   Avenue 140th                       | [(-122.1656,37.003),(-122.1691,37.988)]


                                                                                                          | Oakland 
+  Avenue 140th                       | [(-122.1656,37.003),(-122.1691,37.988)]


                                                                                                          | Berkeley 
+  Avenue D                           | [(-122.298,37.848),(-122.3024,37.849)]


                                                                                                          | Berkeley 
   B                             St   | [(-122.1749,37.451),(-122.1743,37.443)]


                                                                                                          | Oakland 
   Bancroft                      Ave  | [(-122.15714,37.4242),(-122.156,37.409)]


                                                                                                          | Oakland 
   Bancroft                      Ave  | [(-122.1643,37.523),(-122.1631,37.508),(-122.1621,37.493)]


                                                                                                          | Oakland 
   Birch                         St   | [(-122.1617,37.425),(-122.1614,37.417)]


                                                                                                          | Oakland 
   Birch                         St   | [(-122.1673,37.509),(-122.1661,37.492)]


                                                                                                          | Oakland 
   Blacow                        Road | [(-122.0179,37.469),(-122.0167,37.465)]


                                                                                                          | Oakland 
+  Bridgepointe                  Dr   | [(-122.0514,37.305),(-122.0509,37.299)]


                                                                                                          | Oakland 
   Broadmore                     Ave  | [(-122.095,37.522),(-122.0936,37.497)]


                                                                                                          | Oakland 
   Broadway                           | [(-122.2409,37.586),(-122.2395,37.601)]


                                                                                                          | Berkeley 
   Buckingham                    Blvd | [(-122.2231,37.59),(-122.2214,37.606)]


                                                                                                          | Berkeley 
+  Butterfield                   Dr   | [(-122.0838,37.002),(-122.0834,37.987)]


                                                                                                          | Oakland 
+  Butterfield                   Dr   | [(-122.0838,37.002),(-122.0834,37.987)]


                                                                                                          | Oakland 
   Butterfield                   Dr   | [(-122.0838,37.002),(-122.0834,37.987)]


                                                                                                          | Berkeley 
+  C                             St   | [(-122.1768,37.46),(-122.1749,37.435)]


                                                                                                          | Oakland 
+  Calaveras Creek                    | [(-121.8203,37.035),(-121.8207,37.931)]


                                                                                                          | Oakland 
+  Calaveras Creek                    | [(-121.8203,37.035),(-121.8207,37.931)]


                                                                                                          | Oakland 
   California                    St   | [(-122.2032,37.005),(-122.2016,37.996)]


                                                                                                          | Berkeley 
+  California                    St   | [(-122.2032,37.005),(-122.2016,37.996)]


                                                                                                          | Lafayette 
+  Cameron                       Ave  | [(-122.1316,37.502),(-122.1327,37.481)]


                                                                                                          | Oakland 
   Campus                        Dr   | [(-122.1704,37.905),(-122.1678,37.868),(-122.1671,37.865)]


                                                                                                          | Berkeley 
+  Capricorn                     Ave  | [(-122.2176,37.404),(-122.2164,37.384)]


                                                                                                          | Lafayette 
   Carson                        St   | [(-122.1846,37.9),(-122.1843,37.901)]


                                                                                                          | Berkeley 
+  Cedar                         Blvd | [(-122.0282,37.446),(-122.0265,37.43)]


                                                                                                          | Oakland 
   Cedar                         St   | [(-122.3011,37.737),(-122.2999,37.739)]


                                                                                                          | Berkeley 
+  Celia                         St   | [(-122.0611,37.3),(-122.0616,37.299)]


                                                                                                          | Oakland 
   Central                       Ave  | [(-122.2343,37.602),(-122.2331,37.595)]


                                                                                                          | Berkeley 
+  Chambers                      Dr   | [(-122.2004,37.352),(-122.1972,37.368)]


                                                                                                          | Lafayette 
+  Chambers                      Lane | [(-122.2001,37.359),(-122.1975,37.371)]


                                                                                                          | Lafayette 
   Champion                      St   | [(-122.214,37.991),(-122.2147,37.002)]


                                                                                                          | Berkeley 
+  Champion                      St   | [(-122.214,37.991),(-122.2147,37.002)]


                                                                                                          | Lafayette 
+  Chapman                       Dr   | [(-122.0421,37.504),(-122.0414,37.498)]


                                                                                                          | Oakland 
+  Charles                       St   | [(-122.0255,37.505),(-122.0252,37.499)]


                                                                                                          | Oakland 
+  Cherry                        St   | [(-122.0437,37.42),(-122.0434,37.413)]


                                                                                                          | Oakland 
+  Claremont                     Pl   | [(-122.0542,37.995),(-122.0542,37.008)]


                                                                                                          | Oakland 
+  Claremont                     Pl   | [(-122.0542,37.995),(-122.0542,37.008)]


                                                                                                          | Oakland 
   Claremont                     Pl   | [(-122.0542,37.995),(-122.0542,37.008)]


                                                                                                          | Berkeley 
+  Coliseum                      Way  | [(-122.2001,37.47),(-122.1978,37.516)]


                                                                                                          | Oakland 
   Coliseum                      Way  | [(-122.2113,37.626),(-122.2085,37.592),(-122.2063,37.568)]


                                                                                                          | Berkeley 
+  Coolidge                      Ave  | [(-122.2007,37.058),(-122.1992,37.06)]


                                                                                                          | Lafayette 
   Cornell                       Ave  | [(-122.2956,37.925),(-122.2949,37.906),(-122.2939,37.875)]


                                                                                                          | Berkeley 
+  Corriea                       Way  | [(-121.9501,37.402),(-121.9505,37.398)]


                                                                                                          | Oakland 
+  Corriea                       Way  | [(-121.9501,37.402),(-121.9505,37.398)]


                                                                                                          | Oakland 
+  Cowing                        Road | [(-122.0002,37.934),(-121.9772,37.782)]


                                                                                                          | Oakland 
   Creston                       Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]


                                                                                                          | Berkeley 
+  Creston                       Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]


                                                                                                          | Lafayette 
   Crow Canyon Creek                  | [(-122.043,37.905),(-122.0368,37.71)]


                                                                                                          | Berkeley 
+  Crystaline                    Dr   | [(-121.925856,37),(-121.925869,37.00527)]


                                                                                                          | Oakland 
+  Cull Canyon                   Road | [(-122.0536,37.435),(-122.0499,37.315)]


                                                                                                          | Oakland 
   Cull Creek                         | [(-122.0624,37.875),(-122.0582,37.527)]


                                                                                                          | Berkeley 
+  D                             St   | [(-122.1811,37.505),(-122.1805,37.497)]


                                                                                                          | Oakland 
+  Decoto                        Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]


                                                                                                          | Oakland 
+  Decoto                        Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]


                                                                                                          | Oakland 
   Decoto                        Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]


                                                                                                          | Berkeley 
   Deering                       St   | [(-122.2146,37.904),(-122.2126,37.897)]


                                                                                                          | Berkeley 
   Dimond                        Ave  | [(-122.2167,37.994),(-122.2162,37.006)]


                                                                                                          | Berkeley 
+  Dimond                        Ave  | [(-122.2167,37.994),(-122.2162,37.006)]


                                                                                                          | Lafayette 
   Donna                         Way  | [(-122.1333,37.606),(-122.1316,37.599)]


                                                                                                          | Berkeley 
+  Driftwood                     Dr   | [(-122.0109,37.482),(-122.0113,37.477)]


                                                                                                          | Oakland 
+  Driscoll                      Road | [(-121.9482,37.403),(-121.948451,37.39995)]


                                                                                                          | Oakland 
+  Driscoll                      Road | [(-121.9482,37.403),(-121.948451,37.39995)]


                                                                                                          | Oakland 
+  E                             St   | [(-122.1832,37.505),(-122.1826,37.498),(-122.182,37.49)]


                                                                                                          | Oakland 
+  Eden                          Ave  | [(-122.1143,37.505),(-122.1142,37.491)]


                                                                                                          | Oakland 
+  Eden Creek                         | [(-122.022037,37.00675),(-122.0221,37.998)]


                                                                                                          | Oakland 
+  Eden Creek                         | [(-122.022037,37.00675),(-122.0221,37.998)]


                                                                                                          | Oakland 
   Eden Creek                         | [(-122.022037,37.00675),(-122.0221,37.998)]


                                                                                                          | Berkeley 
+  Edgewater                     Dr   | [(-122.201,37.379),(-122.2042,37.41)]


                                                                                                          | Lafayette 
+  Enos                          Way  | [(-121.7677,37.896),(-121.7673,37.91)]


                                                                                                          | Oakland 
   Euclid                        Ave  | [(-122.2671,37.009),(-122.2666,37.987)]


                                                                                                          | Berkeley 
+  Euclid                        Ave  | [(-122.2671,37.009),(-122.2666,37.987)]


                                                                                                          | Lafayette 
+  Fairview                      Ave  | [(-121.999,37.428),(-121.9863,37.351)]


                                                                                                          | Oakland 
+  Fairview                      Ave  | [(-121.999,37.428),(-121.9863,37.351)]


                                                                                                          | Oakland 
   Foothill                      Blvd | [(-122.2414,37.9),(-122.2403,37.893)]


                                                                                                          | Berkeley 
   Fountain                      St   | [(-122.2306,37.593),(-122.2293,37.605)]


                                                                                                          | Berkeley 
+  Gading                        Road | [(-122.0801,37.343),(-122.08,37.336)]


                                                                                                          | Oakland 
   Grizzly Peak                  Blvd | [(-122.2213,37.638),(-122.2127,37.581)]


                                                                                                          | Berkeley 
   Grove                         Way  |
[(-122.0643,37.884),(-122.062679,37.89162),(-122.061796,37.89578),(-122.0609,37.9)]


                                                                 | Berkeley 
+  Harris                        Road | [(-122.0659,37.372),(-122.0675,37.363)]


                                                                                                          | Oakland 
+  Heartwood                     Dr   | [(-122.2006,37.341),(-122.1992,37.338)]


                                                                                                          | Lafayette 
+  Hegenberger                   Exwy | [(-122.1946,37.52),(-122.1947,37.497)]


                                                                                                          | Oakland 
+  Herrier                       St   | [(-122.1943,37.006),(-122.1936,37.998)]


                                                                                                          | Oakland 
   Herrier                       St   | [(-122.1943,37.006),(-122.1936,37.998)]


                                                                                                          | Berkeley 
+  Hesperian                     Blvd | [(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]


                                                                                                          | Oakland 
+  Hesperian                     Blvd | [(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]


                                                                                                          | Oakland 
   Hesperian                     Blvd | [(-122.1132,37.6),(-122.1123,37.586)]


                                                                                                          | Berkeley 
+  Hollis                        St   | [(-122.2885,37.397),(-122.289,37.414)]


                                                                                                          | Lafayette 
+  I- 580                             |
[(-121.727,37.074),(-121.7229,37.093),(-121.722301,37.09522),(-121.721001,37.10005),(-121.7194,37.106),(-121.7188,37.109),(-121.7168,37.12),(-121.7163,37.123),(-121.7145,37.127),(-121.7096,37.148),(-121.707731,37.1568),(-121.7058,37.166),(-121.7055,37.168),(-121.7044,37.174),(-121.7038,37.172),(-121.7037,37.172),(-121.7027,37.175),(-121.7001,37.181),(-121.6957,37.191),(-121.6948,37.192),(-121.6897,37.204),(-121.6697,37.185)]
|Oakland 
+  I- 580                             | [(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]


                                                                                                          | Oakland 
+  I- 580                             | [(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]


                                                                                                          | Oakland 
+  I- 580                             |
[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]


                                                                 | Oakland 
+  I- 580                             |
[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]


                                                                 | Oakland 
+  I- 580                             |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]

                                       | Oakland 
   I- 580                             |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]

                                       | Berkeley 
+  I- 580                             |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
                          | Oakland 
   I- 580                             |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
                          | Berkeley 
   I- 580                             |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]

                                                                      | Berkeley 
+  I- 580                             |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]

                                                                      | Lafayette 
+  I- 580                        Ramp |
[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]


                                                                 | Oakland 
+  I- 580                        Ramp |
[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]


                                                                 | Oakland 
+  I- 580                        Ramp | [(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]


                                                                                                          | Oakland 
+  I- 580                        Ramp | [(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]


                                                                                                          | Oakland 
+  I- 580                        Ramp |
[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]


                                                                 | Oakland 
+  I- 580                        Ramp |
[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]


                                                                 | Oakland 
+  I- 580                        Ramp |
[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]


                     | Oakland 
+  I- 580                        Ramp |
[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]


                     | Oakland 
   I- 580                        Ramp | [(-122.093241,37.90351),(-122.09364,37.89634),(-122.093788,37.89212)]


                                                                                                          | Berkeley 
   I- 580                        Ramp | [(-122.0934,37.896),(-122.09257,37.89961),(-122.0911,37.906)]


                                                                                                          | Berkeley 
   I- 580                        Ramp | [(-122.0941,37.897),(-122.0943,37.902)]


                                                                                                          | Berkeley 
   I- 580                        Ramp | [(-122.096,37.888),(-122.0962,37.891),(-122.0964,37.9)]


                                                                                                          | Berkeley 
   I- 580                        Ramp | [(-122.101,37.898),(-122.1005,37.902),(-122.0989,37.911)]


                                                                                                          | Berkeley 
+  I- 580                        Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]


                                                                                                          | Oakland 
   I- 580                        Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]


                                                                                                          | Berkeley 
+  I- 580                        Ramp | [(-122.1414,37.383),(-122.1407,37.376),(-122.1403,37.372),(-122.139,37.356)]


                                                                                                          | Oakland 
+  I- 580/I-680                  Ramp | ((-121.9207,37.988),(-121.9192,37.016))


                                                                                                          | Oakland 
+  I- 580/I-680                  Ramp | ((-121.9207,37.988),(-121.9192,37.016))


                                                                                                          | Oakland 
+  I- 680                             |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
                                                                                                       | Oakland 
+  I- 680                             |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
                                                                                                       | Oakland 
+  I- 680                             |
[(-121.9101,37.715),(-121.911269,37.74682),(-121.9119,37.764),(-121.9124,37.776),(-121.9174,37.905),(-121.9194,37.957),(-121.9207,37.988)]


                                               | Oakland 
+  I- 680                             | [(-121.9184,37.934),(-121.917,37.913),(-121.9122,37.83),(-121.9052,37.702)]


                                                                                                          | Oakland 
+  I- 680                        Ramp |
[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]


                                                                 | Oakland 
+  I- 680                        Ramp |
[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]


                                                                 | Oakland 
+  I- 680                        Ramp | [(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]


                                                                                                          | Oakland 
+  I- 680                        Ramp | [(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]


                                                                                                          | Oakland 
+  I- 680                        Ramp | [(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]


                                                                                                          | Oakland 
+  I- 680                        Ramp | [(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]


                                                                                                          | Oakland 
+  I- 80                              | ((-122.2937,37.277),(-122.3016,37.262))


                                                                                                          | Lafayette 
+  I- 80                              | ((-122.2962,37.273),(-122.3004,37.264))


                                                                                                          | Lafayette 
+  I- 80                         Ramp | [(-122.2962,37.413),(-122.2959,37.382),(-122.2951,37.372)]


                                                                                                          | Lafayette 
+  I- 880                             |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))


                                                                 | Oakland 
+  I- 880                             |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))


                                                                 | Oakland 
+  I- 880                             |
[(-121.948,37.933),(-121.9471,37.925),(-121.9467,37.923),(-121.946,37.918),(-121.9452,37.912),(-121.937,37.852)]


                                                                 | Oakland 
+  I- 880                             |
[(-122.0219,37.466),(-122.0205,37.447),(-122.020331,37.44447),(-122.020008,37.43962),(-122.0195,37.432),(-122.0193,37.429),(-122.0164,37.393),(-122.010219,37.34771),(-122.0041,37.313)]


 | Oakland 
+  I- 880                             |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]

                                               | Oakland 
   I- 880                             |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]

                                               | Berkeley 
+  I- 880                             |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]

                                                                        | Oakland 
+  I- 880                             |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]

                                                                        | Oakland 
   I- 880                             |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]

                                                                        | Berkeley 
+  I- 880                             |
[(-122.0831,37.312),(-122.0819,37.296),(-122.081,37.285),(-122.0786,37.248),(-122.078,37.24),(-122.077642,37.23496),(-122.076983,37.22567),(-122.076599,37.22026),(-122.076229,37.21505),(-122.0758,37.209)]

                                                                                                      | Oakland 
+  I- 880                             |
[(-122.0978,37.528),(-122.096,37.496),(-122.0931,37.453),(-122.09277,37.4496),(-122.090189,37.41442),(-122.0896,37.405),(-122.085,37.34)]


                                                | Oakland 
   I- 880                             |
[(-122.1365,37.902),(-122.1358,37.898),(-122.1333,37.881),(-122.1323,37.874),(-122.1311,37.866),(-122.1308,37.865),(-122.1307,37.864),(-122.1289,37.851),(-122.1277,37.843),(-122.1264,37.834),(-122.1231,37.812),(-122.1165,37.766),(-122.1104,37.72),(-122.109695,37.71094),(-122.109,37.702),(-122.108312,37.69168),(-122.1076,37.681)]
                                                                                                 | Berkeley 
+  I- 880                             |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
                                                   | Oakland 
   I- 880                             |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
                                                   | Berkeley 
   I- 880                             |
[(-122.2214,37.711),(-122.2202,37.699),(-122.2199,37.695),(-122.219,37.682),(-122.2184,37.672),(-122.2173,37.652),(-122.2159,37.638),(-122.2144,37.616),(-122.2138,37.612),(-122.2135,37.609),(-122.212,37.592),(-122.2116,37.586),(-122.2111,37.581)]

                                                            | Berkeley 
   I- 880                             |
[(-122.2707,37.975),(-122.2693,37.972),(-122.2681,37.966),(-122.267,37.962),(-122.2659,37.957),(-122.2648,37.952),(-122.2636,37.946),(-122.2625,37.935),(-122.2617,37.927),(-122.2607,37.921),(-122.2593,37.916),(-122.258,37.911),(-122.2536,37.898),(-122.2432,37.858),(-122.2408,37.845),(-122.2386,37.827),(-122.2374,37.811)]
                                                                                                         | Berkeley 
+  I- 880                        Ramp | [(-122.0019,37.301),(-122.002,37.293)]


                                                                                                          | Oakland 
+  I- 880                        Ramp |
[(-122.0041,37.313),(-122.0018,37.315),(-122.0007,37.315),(-122.0005,37.313),(-122.0002,37.308),(-121.9995,37.289)]


                                                                 | Oakland 
+  I- 880                        Ramp |
[(-122.0041,37.313),(-122.0038,37.308),(-122.0039,37.284),(-122.0013,37.287),(-121.9995,37.289)]


                                                                 | Oakland 
+  I- 880                        Ramp |
[(-122.0236,37.488),(-122.0231,37.458),(-122.0227,37.458),(-122.0223,37.452),(-122.0205,37.447)]


                                                                 | Oakland 
+  I- 880                        Ramp | [(-122.0238,37.491),(-122.0215,37.483),(-122.0211,37.477),(-122.0205,37.447)]


                                                                                                          | Oakland 
+  I- 880                        Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]


                                                                                                          | Oakland 
+  I- 880                        Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]


                                                                                                          | Oakland 
   I- 880                        Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]


                                                                                                          | Berkeley 
+  I- 880                        Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]


                                                                                                          | Oakland 
+  I- 880                        Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]


                                                                                                          | Oakland 
   I- 880                        Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]


                                                                                                          | Berkeley 
+  I- 880                        Ramp | [(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]


                                                                                                          | Oakland 
+  I- 880                        Ramp | [(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]


                                                                                                          | Oakland 
+  I- 880                        Ramp | [(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]


                                                                                                          | Oakland 
+  I- 880                        Ramp | [(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]


                                                                                                          | Oakland 
   I- 880                        Ramp | [(-122.1029,37.61),(-122.1013,37.587),(-122.0999,37.569)]


                                                                                                          | Berkeley 
   I- 880                        Ramp | [(-122.1379,37.891),(-122.1383,37.897),(-122.1377,37.902)]


                                                                                                          | Berkeley 
   I- 880                        Ramp |
[(-122.1379,37.931),(-122.137597,37.92736),(-122.1374,37.925),(-122.1373,37.924),(-122.1369,37.914),(-122.1358,37.905),(-122.1365,37.908),(-122.1358,37.898)]


                            | Berkeley 
   I- 880                        Ramp | [(-122.2536,37.898),(-122.254,37.902)]


                                                                                                          | Berkeley 
+  I- 880                        Ramp | [(-122.2771,37.002),(-122.278,37)]


                                                                                                          | Lafayette 
+  Indian                        Way  | [(-122.2066,37.398),(-122.2045,37.411)]


                                                                                                          | Lafayette 
   Jackson                       St   | [(-122.0845,37.6),(-122.0842,37.606)]


                                                                                                          | Berkeley 
+  Johnson                       Dr   | [(-121.9145,37.901),(-121.915,37.877)]


                                                                                                          | Oakland 
   Joyce                         St   | [(-122.0792,37.604),(-122.0774,37.581)]


                                                                                                          | Berkeley 
+  Juniper                       St   | [(-121.7823,37.897),(-121.7815,37.9)]


                                                                                                          | Oakland 
+  Kaiser                        Dr   | [(-122.067163,37.47821),(-122.060402,37.51961)]


                                                                                                          | Oakland 
   Keeler                        Ave  | [(-122.2578,37.906),(-122.2579,37.899)]


                                                                                                          | Berkeley 
+  Kildare                       Road | [(-122.0968,37.016),(-122.0959,37)]


                                                                                                          | Oakland 
+  La Playa                      Dr   | [(-122.1039,37.545),(-122.101,37.493)]


                                                                                                          | Oakland 
   Laguna                        Ave  | [(-122.2099,37.989),(-122.2089,37)]


                                                                                                          | Berkeley 
+  Laguna                        Ave  | [(-122.2099,37.989),(-122.2089,37)]


                                                                                                          | Lafayette 
   Lakehurst                     Cir  | [(-122.284729,37.89025),(-122.286096,37.90364)]


                                                                                                          | Berkeley 
   Lakeshore                     Ave  | [(-122.2586,37.99),(-122.2556,37.006)]


                                                                                                          | Berkeley 
+  Lakeshore                     Ave  | [(-122.2586,37.99),(-122.2556,37.006)]


                                                                                                          | Lafayette 
+  Las Positas                   Road | [(-121.764488,37.99199),(-121.75569,37.02022)]


                                                                                                          | Oakland 
+  Las Positas                   Road | [(-121.764488,37.99199),(-121.75569,37.02022)]


                                                                                                          | Oakland 
   Linden                        St   | [(-122.2867,37.998),(-122.2864,37.008)]


                                                                                                          | Berkeley 
+  Linden                        St   | [(-122.2867,37.998),(-122.2864,37.008)]


                                                                                                          | Lafayette 
+  Livermore                     Ave  | [(-121.7687,37.448),(-121.769,37.375)]


                                                                                                          | Oakland 
+  Livermore                     Ave  | [(-121.7687,37.448),(-121.769,37.375)]


                                                                                                          | Oakland 
+  Livermore                     Ave  | [(-121.772719,37.99085),(-121.7728,37.001)]


                                                                                                          | Oakland 
+  Livermore                     Ave  | [(-121.772719,37.99085),(-121.7728,37.001)]


                                                                                                          | Oakland 
+  Locust                        St   | [(-122.1606,37.007),(-122.1593,37.987)]


                                                                                                          | Oakland 
   Locust                        St   | [(-122.1606,37.007),(-122.1593,37.987)]


                                                                                                          | Berkeley 
+  Logan                         Ct   | [(-122.0053,37.492),(-122.0061,37.484)]


                                                                                                          | Oakland 
+  Magnolia                      St   | [(-122.0971,37.5),(-122.0962,37.484)]


                                                                                                          | Oakland 
+  Mandalay                      Road | [(-122.2322,37.397),(-122.2321,37.403)]


                                                                                                          | Lafayette 
   Marin                         Ave  | [(-122.2741,37.894),(-122.272,37.901)]


                                                                                                          | Berkeley 
   Martin Luther King Jr         Way  | [(-122.2712,37.608),(-122.2711,37.599)]


                                                                                                          | Berkeley 
+  Mattos                        Dr   | [(-122.0005,37.502),(-122.000898,37.49683)]


                                                                                                          | Oakland 
+  Maubert                       Ave  | [(-122.1114,37.009),(-122.1096,37.995)]


                                                                                                          | Oakland 
   Maubert                       Ave  | [(-122.1114,37.009),(-122.1096,37.995)]


                                                                                                          | Berkeley 
+  McClure                       Ave  | [(-122.1431,37.001),(-122.1436,37.998)]


                                                                                                          | Oakland 
   McClure                       Ave  | [(-122.1431,37.001),(-122.1436,37.998)]


                                                                                                          | Berkeley 
+  Medlar                        Dr   | [(-122.0627,37.378),(-122.0625,37.375)]


                                                                                                          | Oakland 
+  Mildred                       Ct   | [(-122.0002,37.388),(-121.9998,37.386)]


                                                                                                          | Oakland 
   Miller                        Road | [(-122.0902,37.645),(-122.0865,37.545)]


                                                                                                          | Berkeley 
+  Miramar                       Ave  | [(-122.1009,37.025),(-122.099089,37.03209)]


                                                                                                          | Oakland 
+  Mission                       Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]


                                                                                                          | Oakland 
+  Mission                       Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]


                                                                                                          | Oakland 
+  Mission                       Blvd | [(-122.0006,37.896),(-121.9989,37.88)]


                                                                                                          | Oakland 
   Mission                       Blvd | [(-122.0006,37.896),(-121.9989,37.88)]


                                                                                                          | Berkeley 
+  Moores                        Ave  | [(-122.0087,37.301),(-122.0094,37.292)]


                                                                                                          | Oakland 
+  National                      Ave  | [(-122.1192,37.5),(-122.1281,37.489)]


                                                                                                          | Oakland 
+  Navajo                        Ct   | [(-121.8779,37.901),(-121.8783,37.9)]


                                                                                                          | Oakland 
+  Newark                        Blvd | [(-122.0352,37.438),(-122.0341,37.423)]


                                                                                                          | Oakland 
   Oakland Inner Harbor               | [(-122.2625,37.913),(-122.260016,37.89484)]


                                                                                                          | Berkeley 
+  Oakridge                      Road | [(-121.8316,37.049),(-121.828382,37)]


                                                                                                          | Oakland 
   Oneil                         Ave  | [(-122.076754,37.62476),(-122.0745,37.595)]


                                                                                                          | Berkeley 
   Parkridge                     Dr   | [(-122.1438,37.884),(-122.1428,37.9)]


                                                                                                          | Berkeley 
   Parkside                      Dr   | [(-122.0475,37.603),(-122.0443,37.596)]


                                                                                                          | Berkeley 
+  Paseo Padre                   Pkwy | [(-121.9143,37.005),(-121.913522,37)]


                                                                                                          | Oakland 
+  Paseo Padre                   Pkwy | [(-122.0021,37.639),(-121.996,37.628)]


                                                                                                          | Oakland 
   Paseo Padre                   Pkwy | [(-122.0021,37.639),(-121.996,37.628)]


                                                                                                          | Berkeley 
   Pearl                         St   | [(-122.2383,37.594),(-122.2366,37.615)]


                                                                                                          | Berkeley 
+  Periwinkle                    Road | [(-122.0451,37.301),(-122.044758,37.29844)]


                                                                                                          | Oakland 
+  Pimlico                       Dr   | [(-121.8616,37.998),(-121.8618,37.008)]


                                                                                                          | Oakland 
+  Pimlico                       Dr   | [(-121.8616,37.998),(-121.8618,37.008)]


                                                                                                          | Oakland 
+  Portsmouth                    Ave  | [(-122.1064,37.315),(-122.1064,37.308)]


                                                                                                          | Oakland 
+  Proctor                       Ave  | [(-122.2267,37.406),(-122.2251,37.386)]


                                                                                                          | Lafayette 
+  Railroad                      Ave  | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]


                                                                                                          | Oakland 
+  Railroad                      Ave  | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]


                                                                                                          | Oakland 
   Railroad                      Ave  | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]


                                                                                                          | Berkeley 
+  Ranspot                       Dr   | [(-122.0972,37.999),(-122.0959,37)]


                                                                                                          | Oakland 
+  Ranspot                       Dr   | [(-122.0972,37.999),(-122.0959,37)]


                                                                                                          | Oakland 
   Ranspot                       Dr   | [(-122.0972,37.999),(-122.0959,37)]


                                                                                                          | Berkeley 
   Redding                       St   | [(-122.1978,37.901),(-122.1975,37.895)]


                                                                                                          | Berkeley 
+  Redwood                       Road | [(-122.1493,37.98),(-122.1437,37.001)]


                                                                                                          | Oakland 
   Redwood                       Road | [(-122.1493,37.98),(-122.1437,37.001)]


                                                                                                          | Berkeley 
   Roca                          Dr   | [(-122.0335,37.609),(-122.0314,37.599)]


                                                                                                          | Berkeley 
+  Rosedale                      Ct   | [(-121.9232,37.9),(-121.924,37.897)]


                                                                                                          | Oakland 
   Sacramento                    St   | [(-122.2799,37.606),(-122.2797,37.597)]


                                                                                                          | Berkeley 
   Saddle Brook                  Dr   | [(-122.1478,37.909),(-122.1454,37.904),(-122.1451,37.888)]


                                                                                                          | Berkeley 
+  Saginaw                       Ct   | [(-121.8803,37.898),(-121.8806,37.901)]


                                                                                                          | Oakland 
   San Andreas                   Dr   | [(-122.0609,37.9),(-122.0614,37.895)]


                                                                                                          | Berkeley 
+  Santa Maria                   Ave  | [(-122.0773,37),(-122.0773,37.98)]


                                                                                                          | Oakland 
+  Santa Maria                   Ave  | [(-122.0773,37),(-122.0773,37.98)]


                                                                                                          | Oakland 
   Santa Maria                   Ave  | [(-122.0773,37),(-122.0773,37.98)]


                                                                                                          | Berkeley 
   Shattuck                      Ave  | [(-122.2686,37.904),(-122.2686,37.897)]


                                                                                                          | Berkeley 
+  Sheridan                      Road | [(-122.2279,37.425),(-122.2253,37.411),(-122.2223,37.377)]


                                                                                                          | Lafayette 
   Shoreline                     Dr   | [(-122.2657,37.603),(-122.2648,37.6)]


                                                                                                          | Berkeley 
+  Skyline                       Blvd | [(-122.1738,37.01),(-122.1714,37.996)]


                                                                                                          | Oakland 
   Skyline                       Blvd | [(-122.1738,37.01),(-122.1714,37.996)]


                                                                                                          | Berkeley 
+  Skyline                       Dr   | [(-122.0277,37.5),(-122.0284,37.498)]


                                                                                                          | Oakland 
   Skywest                       Dr   | [(-122.1161,37.62),(-122.1123,37.586)]


                                                                                                          | Berkeley 
   Southern Pacific Railroad          | [(-122.3002,37.674),(-122.2999,37.661)]


                                                                                                          | Berkeley 
+  Sp Railroad                        | [(-121.893564,37.99009),(-121.897,37.016)]


                                                                                                          | Oakland 
+  Sp Railroad                        | [(-121.893564,37.99009),(-121.897,37.016)]


                                                                                                          | Oakland 
+  Sp Railroad                        | [(-121.9565,37.898),(-121.9562,37.9)]


                                                                                                          | Oakland 
+  Sp Railroad                        | [(-122.0734,37.001),(-122.0734,37.997)]


                                                                                                          | Oakland 
+  Sp Railroad                        | [(-122.0734,37.001),(-122.0734,37.997)]


                                                                                                          | Oakland 
   Sp Railroad                        | [(-122.0734,37.001),(-122.0734,37.997)]


                                                                                                          | Berkeley 
   Sp Railroad                        | [(-122.0914,37.601),(-122.087,37.56),(-122.086408,37.5551)]


                                                                                                          | Berkeley 
+  Sp Railroad                        | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]


                                                                                                          | Oakland 
   Sp Railroad                        | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]


                                                                                                          | Berkeley 
+  Sp Railroad                        | [(-122.1947,37.497),(-122.193328,37.4848)]


                                                                                                          | Oakland 
+  Stanton                       Ave  | [(-122.100392,37.0697),(-122.099513,37.06052)]


                                                                                                          | Oakland 
   State Hwy 123                      |
[(-122.3004,37.986),(-122.2998,37.969),(-122.2995,37.962),(-122.2992,37.952),(-122.299,37.942),(-122.2987,37.935),(-122.2984,37.924),(-122.2982,37.92),(-122.2976,37.904),(-122.297,37.88),(-122.2966,37.869),(-122.2959,37.848),(-122.2961,37.843)]

                                                              | Berkeley 
   State Hwy 13                       |
[(-122.1797,37.943),(-122.179871,37.91849),(-122.18,37.9),(-122.179023,37.86615),(-122.1787,37.862),(-122.1781,37.851),(-122.1777,37.845),(-122.1773,37.839),(-122.177,37.833)]


          | Berkeley 
+  State Hwy 13                       |
[(-122.2049,37.2),(-122.20328,37.17975),(-122.1989,37.125),(-122.198078,37.11641),(-122.1975,37.11)]


                                                                 | Lafayette 
+  State Hwy 13                  Ramp | [(-122.2244,37.427),(-122.223,37.414),(-122.2214,37.396),(-122.2213,37.388)]


                                                                                                          | Lafayette 
   State Hwy 238                      |
((-122.098,37.908),(-122.0983,37.907),(-122.099,37.905),(-122.101,37.898),(-122.101535,37.89711),(-122.103173,37.89438),(-122.1046,37.892),(-122.106,37.89))


                             | Berkeley 
   State Hwy 238                 Ramp | [(-122.1288,37.9),(-122.1293,37.895),(-122.1296,37.906)]


                                                                                                          | Berkeley 
+  State Hwy 24                       |
[(-122.2674,37.246),(-122.2673,37.248),(-122.267,37.261),(-122.2668,37.271),(-122.2663,37.298),(-122.2659,37.315),(-122.2655,37.336),(-122.265007,37.35882),(-122.264443,37.37286),(-122.2641,37.381),(-122.2638,37.388),(-122.2631,37.396),(-122.2617,37.405),(-122.2615,37.407),(-122.2605,37.412)]

             | Lafayette 
+  State Hwy 84                       |
[(-121.9565,37.898),(-121.956589,37.89911),(-121.9569,37.903),(-121.956,37.91),(-121.9553,37.919)]


                                                                 | Oakland 
+  State Hwy 84                       | [(-122.0671,37.426),(-122.07,37.402),(-122.074,37.37),(-122.0773,37.338)]


                                                                                                          | Oakland 
+  State Hwy 92                       |
[(-122.1085,37.326),(-122.1095,37.322),(-122.1111,37.316),(-122.1119,37.313),(-122.1125,37.311),(-122.1131,37.308),(-122.1167,37.292),(-122.1187,37.285),(-122.12,37.28)]


                | Oakland 
+  State Hwy 92                  Ramp | [(-122.1086,37.321),(-122.1089,37.315),(-122.1111,37.316)]


                                                                                                          | Oakland 
   Stuart                        St   | [(-122.2518,37.6),(-122.2507,37.601),(-122.2491,37.606)]


                                                                                                          | Berkeley 
+  Sunol Ridge                   Trl  | [(-121.9419,37.455),(-121.9345,37.38)]


                                                                                                          | Oakland 
+  Sunol Ridge                   Trl  | [(-121.9419,37.455),(-121.9345,37.38)]


                                                                                                          | Oakland 
+  Tassajara Creek                    | [(-121.87866,37.98898),(-121.8782,37.015)]


                                                                                                          | Oakland 
+  Tassajara Creek                    | [(-121.87866,37.98898),(-121.8782,37.015)]


                                                                                                          | Oakland 
+  Taurus                        Ave  | [(-122.2159,37.416),(-122.2128,37.389)]


                                                                                                          | Lafayette 
+  Tennyson                      Road | [(-122.0891,37.317),(-122.0927,37.317)]


                                                                                                          | Oakland 
+  Thackeray                     Ave  | [(-122.072,37.305),(-122.0715,37.298)]


                                                                                                          | Oakland 
+  Theresa                       Way  | [(-121.7289,37.906),(-121.728,37.899)]


                                                                                                          | Oakland 
+  Tissiack                      Way  | [(-121.920364,37),(-121.9208,37.995)]


                                                                                                          | Oakland 
+  Tissiack                      Way  | [(-121.920364,37),(-121.9208,37.995)]


                                                                                                          | Oakland 
   Tupelo                        Ter  | [(-122.059087,37.6113),(-122.057021,37.59942)]


                                                                                                          | Berkeley 
+  Vallecitos                    Road | [(-121.8699,37.916),(-121.8703,37.891)]


                                                                                                          | Oakland 
+  Warm Springs                  Blvd | [(-121.933956,37),(-121.9343,37.97)]


                                                                                                          | Oakland 
+  Warm Springs                  Blvd | [(-121.933956,37),(-121.9343,37.97)]


                                                                                                          | Oakland 
+  Welch Creek                   Road | [(-121.7695,37.386),(-121.7737,37.413)]


                                                                                                          | Oakland 
+  Welch Creek                   Road | [(-121.7695,37.386),(-121.7737,37.413)]


                                                                                                          | Oakland 
   West Loop                     Road | [(-122.0576,37.604),(-122.0602,37.586)]


                                                                                                          | Berkeley 
+  Western Pacific Railroad Spur      | [(-122.0394,37.018),(-122.0394,37.961)]


                                                                                                          | Oakland 
+  Western Pacific Railroad Spur      | [(-122.0394,37.018),(-122.0394,37.961)]


                                                                                                          | Oakland 
   Western Pacific Railroad Spur      | [(-122.0394,37.018),(-122.0394,37.961)]


                                                                                                          | Berkeley 
+  Whitlock Creek                     | [(-121.74683,37.91276),(-121.733107,37)]


                                                                                                          | Oakland 
+  Whitlock Creek                     | [(-121.74683,37.91276),(-121.733107,37)]


                                                                                                          | Oakland 
+  Willimet                      Way  | [(-122.0964,37.517),(-122.0949,37.493)]


                                                                                                          | Oakland 
+  Wisconsin                     St   | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]


                                                                                                          | Oakland 
   Wisconsin                     St   | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]


                                                                                                          | Berkeley 
   Wp Railroad                        | [(-122.254,37.902),(-122.2506,37.891)]


                                                                                                          | Berkeley 
+  100th                         Ave  | [(-122.1657,37.429),(-122.1647,37.432)]


                                                                                                          | Oakland 
+  107th                         Ave  | [(-122.1555,37.403),(-122.1531,37.41)]


                                                                                                          | Oakland 
+  14th                          St   | [(-122.299,37.147),(-122.3,37.148)]


                                                                                                          | Lafayette 
   19th                          Ave  | [(-122.2366,37.897),(-122.2359,37.905)]


                                                                                                          | Berkeley 
+  1st                           St   | [(-121.75508,37.89294),(-121.753581,37.90031)]


                                                                                                          | Oakland 
+  5th                           St   | [(-122.278,37),(-122.2792,37.005),(-122.2803,37.009)]


                                                                                                          | Lafayette 
   5th                           St   | [(-122.296,37.615),(-122.2953,37.598)]


                                                                                                          | Berkeley 
   82nd                          Ave  | [(-122.1695,37.596),(-122.1681,37.603)]


                                                                                                          | Berkeley 
!  85th                          Ave  | [(-122.1877,37.466),(-122.186,37.476)]


                                                                                                          | Oakland 
!  89th                          Ave  | [(-122.1822,37.459),(-122.1803,37.471)]


                                                                                                          | Oakland 
!  98th                          Ave  | [(-122.1568,37.498),(-122.1558,37.502)]


                                                                                                          | Oakland 
!  98th                          Ave  | [(-122.1693,37.438),(-122.1682,37.444)]


                                                                                                          | Oakland 
   98th                          Ave  | [(-122.2001,37.258),(-122.1974,37.27)]


                                                                                                          | Lafayette 
  (333 rows)


======================================================================

*** ./expected/alter_table.out    Sat Nov  3 22:08:11 2001
--- ./results/alter_table.out    Sat Dec  1 21:26:15 2001
***************
*** 98,128 ****
  --   it might not.  Therefore, vacuum first.
  --
  VACUUM ANALYZE tenk1;
  ALTER TABLE tenk1 RENAME TO ten_k;
  -- 20 values, sorted
  SELECT unique1 FROM ten_k WHERE unique1 < 20;
   unique1
  ---------
!        0
!        1
!        2
!        3
         4
!        5
         6
!        7
!        8
         9
!       10
!       11
!       12
        13
!       14
!       15
!       16
!       17
!       18
        19
  (20 rows)

  -- 20 values, sorted
--- 98,129 ----
  --   it might not.  Therefore, vacuum first.
  --
  VACUUM ANALYZE tenk1;
+ ERROR:  PGSTAT: Creation of DB hash table failed
  ALTER TABLE tenk1 RENAME TO ten_k;
  -- 20 values, sorted
  SELECT unique1 FROM ten_k WHERE unique1 < 20;
   unique1
  ---------
!       18
!       15
         4
!        2
!        1
         6
!       14
         9
!        8
!        5
!        3
        13
!       12
        19
+       17
+       11
+        7
+       10
+       16
+        0
  (20 rows)

  -- 20 values, sorted
***************
*** 262,272 ****
  SELECT unique1 FROM tenk1 WHERE unique1 < 5;
   unique1
  ---------
!        0
!        1
         2
         3
!        4
  (5 rows)

  -- FOREIGN KEY CONSTRAINT adding TEST
--- 263,273 ----
  SELECT unique1 FROM tenk1 WHERE unique1 < 5;
   unique1
  ---------
!        4
         2
+        1
         3
!        0
  (5 rows)

  -- FOREIGN KEY CONSTRAINT adding TEST

======================================================================

Re: Second call for platform testing

От

Tom Lane

Дата:

03 декабря 2001 г., 13:17:34

Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> I tried 7.2b3 on SunOS 4.1.4 with gcc 2.7.1. It gives a comile error:

I've added a configure test for sig_atomic_t, if you want to try again
with CVS tip.
        regards, tom lane

Re: Second call for platform testing

От

Thomas Lockhart

Дата:

03 декабря 2001 г., 13:34:25

> >Linux/arm    Mark Knox
> Had a look at 7.2b3 and sadly it's failing several tests. I saw several
> "ERROR:  PGSTAT: Creation of DB hash table failed" which I haven't seen before.
> Geometry fails as usual due to some minor rounding. The others are
> completely wrong. I'm afraid I don't have much time to look at this right
> now (sorry) but I've attached the regression output and diffs if anyone
> wants to check them.

Most (or at least some; didn't count them up) of these look like
ordering differences on results which are not guaranteed to be ordered,
so are OK. 

The DB hash table trouble looks significant, but I don't know about that
area of the code.

Anyone?
                    - Thomas

Re: Second call for platform testing

От

Tom Lane

Дата:

03 декабря 2001 г., 14:04:28

Mark Knox <segfault@hardline.org> writes:
> Had a look at 7.2b3 and sadly it's failing several tests. I saw several 
> "ERROR:  PGSTAT: Creation of DB hash table failed" which I haven't seen before.

Ugh.  If you don't have time to dig into that, can you provide a login
on your machine for someone else to look at it?
        regards, tom lane

Re: Second call for platform testing

От

Tom Lane

Дата:

03 декабря 2001 г., 14:06:10

Mark Knox <segfault@hardline.org> writes:
>> Had a look at 7.2b3 and sadly it's failing several tests. I saw several 
>> "ERROR:  PGSTAT: Creation of DB hash table failed" which I haven't seen before.

That error is coming from the following ugly coding:
   *dbhash = hash_create("Databases hash", PGSTAT_DB_HASH_SIZE, &hash_ctl,                         HASH_ELEM |
HASH_FUNCTION| mcxt_flags);   if (pgStatDBHash == NULL)/* raise error */

AFAICT dbhash always points at the static variable pgStatDBHash, so the
code is not quite incorrect, though it's certainly trouble waiting to
happen as soon as someone changes things so that dbhash might point
elsewhere.  What I'm wondering is if your compiler is missing the
potential for aliasing and is emitting code that loads pgStatDBHash
before the store through dbhash occurs.  Does it help if you change
the second line (line 2094 in src/backend/postmaster/pgstat.c) to:
   if (*dbhash == NULL)

I'm going to commit this change in CVS anyway, but I'm wondering if it
explains your problem or not.
        regards, tom lane

Re: Second call for platform testing

От

Tatsuo Ishii

Дата:

04 декабря 2001 г., 01:16:52

> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > I tried 7.2b3 on SunOS 4.1.4 with gcc 2.7.1. It gives a comile error:
> 
> I've added a configure test for sig_atomic_t, if you want to try again
> with CVS tip.

Thanks. But compiling fails again:

formatting.c: In function `NUM_processor':
formatting.c:4143: invalid operands to binary +
formatting.c:4153: invalid operands to binary +
formatting.c: In function `float4_to_char':
formatting.c:4667: warning: assignment makes integer from pointer without a cast
formatting.c: In function `float8_to_char':
formatting.c:4746: warning: assignment makes integer from pointer without a cast
gmake[4]: *** [formatting.o] Error 1
gmake[4]: Leaving directory `/mnt2/tmp/pgsql/src/backend/utils/adt'
gmake[3]: *** [adt-recursive] Error 2
gmake[3]: Leaving directory `/mnt2/tmp/pgsql/src/backend/utils'
gmake[2]: *** [utils-recursive] Error 2
gmake[2]: Leaving directory `/mnt2/tmp/pgsql/src/backend'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/mnt2/tmp/pgsql/src'
gmake: *** [all] Error 2

It seems the code assumes sprintf always returns an integer (this is
not true for SunOS). I will fix it in more portable way.
--
Tatsuo Ishii

Re: Second call for platform testing

От

Karel Zak

Дата:

04 декабря 2001 г., 04:35:50

On Tue, Dec 04, 2001 at 03:15:58PM +0900, Tatsuo Ishii wrote:

> It seems the code assumes sprintf always returns an integer (this is
> not true for SunOS). I will fix it in more portable way.
It's interesting OS :-) I see "CONFORMING TO" part of sprintf manualand it's ANSI C and ISO/IEC function....
Is anywhere (URL) summary of difference between basic C functions in basic OS?
Thanks for fix Tatsuo.
       Karel
-- Karel Zak  <zakkr@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz

Re: Second call for platform testing

От

"Cyril VELTER"

Дата:

04 декабря 2001 г., 04:46:45

>> > >     What modification should be made to configure.in to make it
>include
>> > > SupportDefs.h when testing for int8 uint8 int64 and uint64 size ?
>
>> 
>> OK, I bit the bullet and made up a whole new macro for type testing.
>> Those who can't get at a new snapshot can try the attached patch.
>> 
>> I have included <stdio.h> because that appears to effect the
>definition of
>> the types in question on AIX; apparently it pulls in <inttypes.h>
>somehow.
>
>Correct. stdio.h pulls sys/types.h which then pulls sys/inttypes.h ==
>inttypes.h.
>
>> Please check this on AIX and BeOS.
   The detection now works on BEOS
   thanks
           cyril

Re: Second call for platform testing

От

Mark Knox

Дата:

06 декабря 2001 г., 10:06:39

On Mon, Dec 03, 2001 at 02:01:30PM -0500, Tom Lane wrote:
> That error is coming from the following ugly coding:
> 
>     *dbhash = hash_create("Databases hash", PGSTAT_DB_HASH_SIZE, &hash_ctl,
>                           HASH_ELEM | HASH_FUNCTION | mcxt_flags);
>     if (pgStatDBHash == NULL)
>     /* raise error */

Interesting...

> AFAICT dbhash always points at the static variable pgStatDBHash, so the
> code is not quite incorrect, though it's certainly trouble waiting to
> happen as soon as someone changes things so that dbhash might point
> elsewhere.  What I'm wondering is if your compiler is missing the

Possibly.. it's not the most recent by any means, but it generally behaves
well. Unfortunately, nobody is maintaining the arm gcc toolchain anymore (as
far as I know).

> before the store through dbhash occurs.  Does it help if you change
> the second line (line 2094 in src/backend/postmaster/pgstat.c) to:
> 
>     if (*dbhash == NULL)
> 
> I'm going to commit this change in CVS anyway, but I'm wondering if it
> explains your problem or not.

I'll give it a shot later tonight and let you know. Thanks for having a
look.

--   __ .--------.  |==||        |            -(  Mark 'segfault' Knox  )- |==||________| |::| __====__`. .'`.  "Unix
*is*user-friendly.. it's just |__|/::::::::\ ~  (_)       picky about its friends."

Re: Second call for platform testing

От

Hiroshi Inoue

Дата:

07 декабря 2001 г., 04:06:46

Hiroshi Inoue wrote:
> 
> > -----Original Message-----
> > From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> >
> > Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > > I got a regression test result from Hiroshi Saito on
> > >   UNIX_System_V ews4800 4.2MP 4.2 R4000 r4000.
> >
> > > Seems INT64_IS_BUSTED, old PST ... etc and
> >
> > > *** ./expected/create_index.out     Tue Aug 28 08:23:34 JST 2001
> > > --- ./results/create_index.out      Fri Nov 30 00:28:22 JST 2001
> > > ***************
> > > *** 35,44 ****
> > > --- 35,47 ----
> > >   --
> > >   CREATE INDEX onek2_u1_prtl ON onek2 USING btree(unique1 int4_ops)
> > >     where unique1 < 20 or unique1 > 980;
> > > + ERROR:  AllocSetFree: cannot find block containing chunk 4f64f0
> > >   CREATE INDEX onek2_u2_prtl ON onek2 USING btree(unique2 int4_ops)
> > >     where stringu1 < 'B';
> > > + ERROR:  AllocSetFree: cannot find block containing chunk 4f6390
> > >   CREATE INDEX onek2_stu1_prtl ON onek2 USING btree(stringu1 name_ops)
> > >     where onek2.stringu1 >= 'J' and onek2.stringu1 < 'K';
> > > + ERROR:  AllocSetFree: cannot find block containing chunk 4f6740
> >
> > Interesting.  Something nonportable in the partial index support,
> > perhaps?
> >
> > Would you ask him to compile with debug support, set a breakpoint at
> > elog(), and get a backtrace from the point of the error?
> 
> Unfortunately he doesn't seem to be able to do it at once
> though he would like to do it.  If he is ready he may reply
> to this thread directly.

Sorry for my late answer.
He has been working with the platform but hasn't yet
identify the cause. Unfortunately it seems too late
for 7.2 release.

regards,
Hiroshi Inoue

Re: Second call for platform testing

От

Tom Lane

Дата:

07 декабря 2001 г., 09:27:46

Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> He has been working with the platform but hasn't yet
> identify the cause. Unfortunately it seems too late
> for 7.2 release.

Not necessarily ... we're still arguing what to do about the time
precision issue, and even if 7.2fc1 were out, I think a portability bug
would be cause for an update.  Please encourage him to pursue it.
        regards, tom lane

Re: Second call for platform testing

От

Mark Knox

Дата:

10 декабря 2001 г., 22:37:51

>change
>the second line (line 2094 in src/backend/postmaster/pgstat.c) to:
>
>     if (*dbhash == NULL)
>
>I'm going to commit this change in CVS anyway, but I'm wondering if it
>explains your problem or not.


Yes it does, Tom! Nice work! I apologize for the delay in testing.. 
Christmas and all.

I guess I can report a success for 7.2b3 on Linux/arm.

   __ .--------.  |==||        |            -(  Mark 'segfault' Knox  )-  |==||________|  |::| __====__`. .'`.  "Unix
*is*user-friendly.. it's just  |__|/::::::::\ ~  (_)       picky about its friends."

Re: Second call for platform testing

От

"Christopher Kings-Lynne"

Дата:

10 декабря 2001 г., 23:07:46

> >I'm going to commit this change in CVS anyway, but I'm wondering if it
> >explains your problem or not.
>
>
> Yes it does, Tom! Nice work! I apologize for the delay in testing..
> Christmas and all.
>
> I guess I can report a success for 7.2b3 on Linux/arm.

I've just got hold of a FreeBSD/alpha box - hopefully I'll be able to test
by the end of the week...

Chris

Re: Second call for platform testing

От

Thomas Lockhart

Дата:

11 декабря 2001 г., 01:59:02

> I guess I can report a success for 7.2b3 on Linux/arm.

Great! Thanks for the work; I'll update the list...
                  - Thomas

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Second call for platform testing