Re: [PORTS] Port Bug Report: yacc bombs table size

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Andreas Hohl
Your email address : vader(at)comtelligence(dot)net

Category : install: compile
Severity : serious

Summary: yacc bombs table size

System Configuration
--------------------
Operating System : BSDI 4.0.1

PostgreSQL version : 6.4.2

Compiler used : gcc

Hardware:
---------
BSD/OS publish.co.jp 4.0.1 BSDI BSD/OS 4.0.1 Kernel #4: Fri Feb 19 11:52:44 MST
1999 polk(at)demiurge(dot)BSDI(dot)COM:/home/polk/tmp/sys/compile/GENERIC i386

Versions of other tools:
------------------------
gmake

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

Problem Description:
--------------------
gmake[2]: Leaving directory `/usr/src/pgsql/src/backend/optimizer'
gmake -C parser all
gmake[2]: Entering directory `/usr/src/pgsql/src/backend/parser'
/usr/bin/yacc -d gram.y
/usr/bin/yacc: f - maximum table size exceeded
gmake[2]: *** [parse.h] Error 2
gmake[2]: Leaving directory `/usr/src/pgsql/src/backend/parser'
gmake[1]: *** [parser.dir] Error 2
gmake[1]: Leaving directory `/usr/src/pgsql/src/backend'
gmake: *** [all] Error 2

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

Test Case:
----------
just recompile it happens everytime no matter what switches are set
our version we compiled as foollows:
first run configure like this...
./configure --with-template=bsdi_4.0 --with-mb=EUC_JP
then gmake

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

Solution:
---------
Discussed issue with BSDI, they say it is not an easy fix, and requires source of BSDI, however the tabel can not exceed 32700

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

> ---------
> BSD/OS publish.co.jp 4.0.1 BSDI BSD/OS 4.0.1 Kernel #4: Fri Feb 19 11:52:44 MST
> 1999 polk(at)demiurge(dot)BSDI(dot)COM:/home/polk/tmp/sys/compile/GENERIC i386
>
> Versions of other tools:
> ------------------------
> gmake
>
> --------------------------------------------------------------------------
>
> Problem Description:
> --------------------
> gmake[2]: Leaving directory `/usr/src/pgsql/src/backend/optimizer'
> gmake -C parser all
> gmake[2]: Entering directory `/usr/src/pgsql/src/backend/parser'
> /usr/bin/yacc -d gram.y
> /usr/bin/yacc: f - maximum table size exceeded
> gmake[2]: *** [parse.h] Error 2
> gmake[2]: Leaving directory `/usr/src/pgsql/src/backend/parser'
> gmake[1]: *** [parser.dir] Error 2
> gmake[1]: Leaving directory `/usr/src/pgsql/src/backend'
> gmake: *** [all] Error 2
>

You should do a touch on src/backend/parser/gram.c, and all will be OK.
You can also use bison, but there is no need.

Also, let me say I am totally embarased we can't get the time stamp on
gram.c to be correct in releases. We may as well just stop trying to
get this right in releases, and force BSD people to use bison.

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