Hi Stefan,
Here's my make.log FWIW...
TIA
On Sat, 10 Jun 2006, Stefan Kaltenbrunner wrote:
> Date: Sat, 10 Jun 2006 21:10:09 +0200
> From: Stefan Kaltenbrunner <[EMAIL PROTECTED]>
> To: ohp@pyrenet.fr
> Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] bison version
>
> ohp@pyrenet.fr wrote:
> > Hi,
> >
> > I'd like to check 2 things:
> >
> > What's the bison version required to compile gram.y ?
> > Trying to set up a build farm machine, it seems I can't compile with bison
> > 2.1 ...
>
> 2.1 should work fine - there are a number of boxes on the buildfarm
> running with that version (like sponge the FC5/ppc I own).
> What exact problem do you see on your platform ?
>
> >
> > Also where is the documentation page that gives postgresql limits (number
> > of column/table max size of col....)
>
> http://www.postgresql.org/docs/faqs.FAQ.html#item4.4
>
>
> Stefan
>
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
gmake -C doc all
gmake[1]: Entering directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/doc'
gmake[1]: Nothing to be done for `all'.
gmake[1]: Leaving directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/doc'
gmake -C src all
gmake[1]: Entering directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src'
gmake -C port all
gmake[2]: Entering directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/port'
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o getopt_long.o getopt_long.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o copydir.o copydir.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o dirmod.o dirmod.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o exec.o exec.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o noblock.o noblock.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
echo "#define PGBINDIR \"/home4/ohp/pgfarmbuild/HEAD/inst/bin\""
>pg_config_paths.h
echo "#define PGSHAREDIR \"/home4/ohp/pgfarmbuild/HEAD/inst/share/postgresql\""
>>pg_config_paths.h
echo "#define SYSCONFDIR \"/home4/ohp/pgfarmbuild/HEAD/inst/etc/postgresql\""
>>pg_config_paths.h
echo "#define INCLUDEDIR \"/home4/ohp/pgfarmbuild/HEAD/inst/include\""
>>pg_config_paths.h
echo "#define PKGINCLUDEDIR
\"/home4/ohp/pgfarmbuild/HEAD/inst/include/postgresql\"" >>pg_config_paths.h
echo "#define INCLUDEDIRSERVER
\"/home4/ohp/pgfarmbuild/HEAD/inst/include/postgresql/server\""
>>pg_config_paths.h
echo "#define LIBDIR \"/home4/ohp/pgfarmbuild/HEAD/inst/lib\""
>>pg_config_paths.h
echo "#define PKGLIBDIR \"/home4/ohp/pgfarmbuild/HEAD/inst/lib/postgresql\""
>>pg_config_paths.h
echo "#define LOCALEDIR \"\"" >>pg_config_paths.h
echo "#define DOCDIR \"/home4/ohp/pgfarmbuild/HEAD/inst/doc/postgresql\""
>>pg_config_paths.h
echo "#define MANDIR \"/home4/ohp/pgfarmbuild/HEAD/inst/man\""
>>pg_config_paths.h
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o path.o path.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o pipe.o pipe.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o pgsleep.o pgsleep.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o pgstrcasecmp.o pgstrcasecmp.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c -o sprompt.o sprompt.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -DFRONTEND -I../../src/include
-I/usr/local/include -c thread.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ar crs libpgport.a getopt_long.o copydir.o dirmod.o exec.o noblock.o path.o
pipe.o pgsleep.o pgstrcasecmp.o sprompt.o thread.o
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c getopt_long.c -o getopt_long_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c copydir.c -o copydir_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c dirmod.c -o dirmod_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c exec.c -o exec_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c noblock.c -o noblock_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c path.c -o path_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c pipe.c -o pipe_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c pgsleep.c -o pgsleep_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c pgstrcasecmp.c -o pgstrcasecmp_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c sprompt.c -o sprompt_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/port -I../../src/include
-I/usr/local/include -c thread.c -o thread_srv.o
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ar crs libpgport_srv.a getopt_long_srv.o copydir_srv.o dirmod_srv.o exec_srv.o
noblock_srv.o path_srv.o pipe_srv.o pgsleep_srv.o pgstrcasecmp_srv.o
sprompt_srv.o thread_srv.o
gmake[2]: Leaving directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/port'
gmake -C timezone all
gmake[2]: Entering directory
`/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/timezone'
ccache cc -O -Kinline -g -I../../src/include -I/usr/local/include -c -o
localtime.o localtime.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/include -I/usr/local/include -c -o
strftime.o strftime.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/include -I/usr/local/include -c -o
pgtz.o pgtz.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
/usr/bin/ld -r -o SUBSYS.o localtime.o strftime.o pgtz.o
gmake -C ../../src/port all
gmake[3]: Entering directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/port'
gmake[3]: Nothing to be done for `all'.
gmake[3]: Leaving directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/port'
ccache cc -O -Kinline -g -I../../src/include -I/usr/local/include -c -o zic.o
zic.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/include -I/usr/local/include -c -o
ialloc.o ialloc.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g -I../../src/include -I/usr/local/include -c -o
scheck.o scheck.c
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
ccache cc -O -Kinline -g zic.o ialloc.o scheck.o localtime.o -L../../src/port
-L/usr/local/lib -Wl,-R'/home4/ohp/pgfarmbuild/HEAD/inst/lib' -lpgport -lssl
-lcrypto -lz -lreadline -ltermcap -lsocket -lm -o zic
UX:cc: WARNING: debugging and optimization mutually exclusive; -O disabled
gmake[2]: Leaving directory
`/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/timezone'
gmake -C backend all
gmake[2]: Entering directory
`/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/backend'
gmake -C ../../src/port all
gmake[3]: Entering directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/port'
gmake[3]: Nothing to be done for `all'.
gmake[3]: Leaving directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/port'
gmake -C parser parse.h
gmake[3]: Entering directory
`/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/backend/parser'
bison -y -d gram.y
226 rules never reduced
gram.y: warning: 17 useless nonterminals and 226 useless rules
gram.y:196.17-39: warning: useless nonterminal: like_including_defaults
gram.y:178.38-49: warning: useless nonterminal: opclass_item
gram.y:277.40-50: warning: useless nonterminal: opt_recheck
gram.y:283.17-28: warning: useless nonterminal: reindex_type
gram.y:4727.36-44: warning: useless nonterminal: opt_equal
gram.y:188.35-50: warning: useless nonterminal: alterdb_opt_item
gram.y:191.17-24: warning: useless nonterminal: opt_lock
gram.y:191.26-34: warning: useless nonterminal: lock_type
gram.y:194.33-42: warning: useless nonterminal: opt_nowait
gram.y:263.59-75: warning: useless nonterminal: for_locking_items
gram.y:262.17-32: warning: useless nonterminal: for_locking_item
gram.y:264.17-32: warning: useless nonterminal: locked_rels_list
gram.y:301.17-25: warning: useless nonterminal: case_expr
gram.y:302.17-32: warning: useless nonterminal: when_clause_list
gram.y:301.36-46: warning: useless nonterminal: when_clause
gram.y:301.48-59: warning: useless nonterminal: case_default
gram.y:301.27-34: warning: useless nonterminal: case_arg
gram.y:535.27-42: warning: useless rule: stmt: CreateAssertStmt
gram.y:568.27-37: warning: useless rule: stmt: ExecuteStmt
gram.y:570.27-35: warning: useless rule: stmt: FetchStmt
gram.y:571.27-35: warning: useless rule: stmt: GrantStmt
gram.y:598.27-34: warning: useless rule: stmt: ViewStmt
gram.y:734.27-737.33: warning: useless rule: OptRoleElem: IN_P GROUP_P name_list
gram.y:844.25-850.33: warning: useless rule: DropRoleStmt: DROP ROLE name_list
gram.y:851.27-857.33: warning: useless rule: DropRoleStmt: DROP ROLE IF_P
EXISTS name_list
gram.y:1044.27-1050.33: warning: useless rule: set_rest: var_name '='
var_list_or_default
gram.y:1059.27-1065.33: warning: useless rule: set_rest: TRANSACTION
transaction_mode_list
gram.y:1066.27-1072.33: warning: useless rule: set_rest: SESSION
CHARACTERISTICS AS TRANSACTION transaction_mode_list
gram.y:1222.25-1227.33: warning: useless rule: VariableShowStmt: SHOW var_name
gram.y:1435.27-1442.33: warning: useless rule: alter_table_cmd: DROP CONSTRAINT
name opt_drop_behavior
gram.y:1458.27-1464.33: warning: useless rule: alter_table_cmd: CLUSTER ON name
gram.y:1474.27-1480.33: warning: useless rule: alter_table_cmd: ENABLE_P
TRIGGER name
gram.y:1818.25-1838.33: warning: useless rule: ColConstraint: CONSTRAINT name
ColConstraintElem
gram.y:2183.22-68: warning: useless rule: OptConsTableSpace: USING INDEX
TABLESPACE name
gram.y:2194.17-2216.33: warning: useless rule: CreateAsStmt: CREATE OptTemp
TABLE qualified_name OptCreateAs OptWithOids OnCommitOption OptTableSpace AS
SelectStmt
gram.y:2256.25-2263.33: warning: useless rule: CreateSeqStmt: CREATE OptTemp
SEQUENCE qualified_name OptSeqList
gram.y:2384.25-108: warning: useless rule: handler_name: name
gram.y:2385.27-99: warning: useless rule: handler_name: name attrs
gram.y:2580.25-100: warning: useless rule: OptConstrFromTable: FROM
qualified_name
gram.y:2797.27-92: warning: useless rule: def_arg: NumericOnly
gram.y:3169.17-3175.33: warning: useless rule: FetchStmt: FETCH fetch_direction
from_in name
gram.y:3176.27-3184.33: warning: useless rule: FetchStmt: FETCH name
gram.y:3185.27-3191.33: warning: useless rule: FetchStmt: MOVE fetch_direction
from_in name
gram.y:3192.27-3200.33: warning: useless rule: FetchStmt: MOVE name
gram.y:3401.25-3407.33: warning: useless rule: privilege_target:
qualified_name_list
gram.y:3408.27-3414.33: warning: useless rule: privilege_target: TABLE
qualified_name_list
gram.y:3415.27-3421.33: warning: useless rule: privilege_target: SEQUENCE
qualified_name_list
gram.y:3789.25-88: warning: useless rule: createfunc_opt_list:
createfunc_opt_item
gram.y:3790.27-91: warning: useless rule: createfunc_opt_list:
createfunc_opt_list createfunc_opt_item
gram.y:4023.25-4030.33: warning: useless rule: ReindexStmt: REINDEX
reindex_type qualified_name opt_force
gram.y:4209.25-4217.33: warning: useless rule: AlterObjectSchemaStmt: ALTER
AGGREGATE func_name aggr_args SET SCHEMA name
gram.y:4218.27-4225.33: warning: useless rule: AlterObjectSchemaStmt: ALTER
DOMAIN_P any_name SET SCHEMA name
gram.y:4226.27-4234.33: warning: useless rule: AlterObjectSchemaStmt: ALTER
FUNCTION func_name func_args SET SCHEMA name
gram.y:4235.27-4242.33: warning: useless rule: AlterObjectSchemaStmt: ALTER
SEQUENCE relation_expr SET SCHEMA name
gram.y:4243.27-4250.33: warning: useless rule: AlterObjectSchemaStmt: ALTER
TABLE relation_expr SET SCHEMA name
gram.y:4251.27-4258.33: warning: useless rule: AlterObjectSchemaStmt: ALTER
TYPE_P any_name SET SCHEMA name
gram.y:4284.27-4291.33: warning: useless rule: AlterOwnerStmt: ALTER DATABASE
database_name OWNER TO RoleId
gram.y:4428.25-4436.33: warning: useless rule: DropRuleStmt: DROP RULE name ON
qualified_name opt_drop_behavior
gram.y:4448.13-4453.33: warning: useless rule: NotifyStmt: NOTIFY qualified_name
gram.y:4456.13-4461.33: warning: useless rule: ListenStmt: LISTEN qualified_name
gram.y:4465.25-4470.33: warning: useless rule: UnlistenStmt: UNLISTEN
qualified_name
gram.y:4625.25-45: warning: useless rule: transaction_mode_list_or_empty:
transaction_mode_list
gram.y:4639.11-4649.33: warning: useless rule: ViewStmt: CREATE OptTemp VIEW
qualified_name opt_column_list AS SelectStmt opt_check_option
gram.y:4650.19-4660.33: warning: useless rule: ViewStmt: CREATE OR REPLACE
OptTemp VIEW qualified_name opt_column_list AS SelectStmt opt_check_option
gram.y:4828.25-4831.33: warning: useless rule: alterdb_opt_item: CONNECTION
LIMIT opt_equal SignedIconst
gram.y:4842.13-4848.33: warning: useless rule: DropdbStmt: DROP DATABASE
database_name
gram.y:4849.27-4855.33: warning: useless rule: DropdbStmt: DROP DATABASE IF_P
EXISTS database_name
gram.y:4912.27-4920.33: warning: useless rule: AlterDomainStmt: ALTER DOMAIN_P
any_name DROP CONSTRAINT name opt_drop_behavior
gram.y:5101.27-37: warning: useless rule: ExplainableStmt: ExecuteStmt
gram.y:5116.14-5123.33: warning: useless rule: PrepareStmt: PREPARE name
prep_type_clause AS PreparableStmt
gram.y:5126.19-60: warning: useless rule: prep_type_clause: '(' prep_type_list
')'
gram.y:5298.17-5306.33: warning: useless rule: LockStmt: LOCK_P opt_table
qualified_name_list opt_lock opt_nowait
gram.y:5309.17-68: warning: useless rule: opt_lock: IN_P lock_type MODE
gram.y:5310.81-109: warning: useless rule: opt_lock: /* empty */
gram.y:5313.17-89: warning: useless rule: lock_type: ACCESS SHARE
gram.y:5314.27-102: warning: useless rule: lock_type: ROW SHARE
gram.y:5315.27-98: warning: useless rule: lock_type: ROW EXCLUSIVE
gram.y:5316.27-98: warning: useless rule: lock_type: SHARE UPDATE EXCLUSIVE
gram.y:7074.27-7077.33: warning: useless rule: b_expr: b_expr IS OF '('
type_list ')'
gram.y:7078.27-7081.33: warning: useless rule: b_expr: b_expr IS NOT OF '('
type_list ')'
gmake[3]: *** [parse.h] Segmentation Fault (core dumped)
gmake[3]: Leaving directory
`/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/backend/parser'
gmake[2]: *** [parser/parse.h] Error 2
gmake[2]: Leaving directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src/backend'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/home4/ohp/pgfarmbuild/HEAD/pgsql.4903/src'
gmake: *** [all] Error 2
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
