Re: 64 bit PostgreSQL 8.3.6 build on AIX 5300-09-02-0849 with IBM XL C/C++ 10.1.0.1 - initdb fails (could not dump unrecognized node type: 650)

Yes, I've had CC exported as xlC_r -q64 to do 64 bit builds, and use vacpp C++ instead of C. Guess it didn't like that,
andended up with some horrible compiler optimization or something that killed it.<br /><br /> Are there any other tests
Ican run now that PostgreSQL is installed?<br /><br />Seems to work fine for basic stuff anyway.<br />phobos%
/usr/local/pgsql/bin/pg_ctl-D /usr/local/pgsql/data -l logfile start<br />server starting<br /> phobos%
/usr/local/pgsql/bin/psql-U postgres<br />Welcome to psql 8.3.6, the PostgreSQL interactive terminal.<br /><br />Type: 
\copyrightfor distribution terms<br />       \h for help with SQL commands<br />       \? for help with psql
commands<br/>        \g or terminate with semicolon to execute query<br />       \q to quit<br /><br />postgres=#
CREATEROLE testuser LOGIN PASSWORD 'test123';<br />CREATE ROLE<br />postgres=# CREATE DATABASE testdb;<br />CREATE
DATABASE<br/> postgres=# CREATE TABLE test (ID serial PRIMARY KEY, name varchar(25) NOT NULL UNIQUE);<br />NOTICE: 
CREATETABLE will create implicit sequence "test_id_seq" for serial column "<a href="http://test.id">test.id</a>"<br />
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" for table "test"<br />NOTICE:  CREATE TABLE /
UNIQUEwill create implicit index "test_name_key" for table "test"<br /> CREATE TABLE<br />postgres=# INSERT INTO test
VALUES(default, 'quux');<br />INSERT 0 1<br />postgres=# SELECT * FROM test;<br /> id | name<br />----+------<br />  1
|quux<br />(1 row)<br />\q<br /><br /><br /><div class="gmail_quote"> On Mon, Feb 9, 2009 at 11:40 AM, Zeugswetter
AndreasOSB sIT <span dir="ltr"><<a
href="mailto:Andreas.Zeugswetter@s-itsolutions.at">Andreas.Zeugswetter@s-itsolutions.at</a>></span>wrote:<br
/><blockquoteclass="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex;
padding-left:1ex;"><div class="Ih2E3d"><br /> > > So if this is a compiler bug, it certainly isn't an obvious
one.I'll dig<br /> > > deeper to see how I can convince configure to use -qnooptimize.<br /> ><br /> > Set
CFLAGSin its environment.  The default is set in src/template/aix<br /> >       CFLAGS="-O2 -qmaxmem=16384 -qsrcmsg
-qlonglong"<br/> ><br /> > > When I've used the build farm scripts, configure gives xlC_r these flags:<br />
>> configure:7117: xlC_r -q64 -o conftest -O2 -qmaxmem=16384 -qsrcmsg<br /> > > -qlonglong -g
 -I/opt/freeware/include/libxml2  -L/opt/freeware/lib<br /> > > conftest.c -lm  >&5<br /><br /></div>Um,
whyare you using the C++ frontend ? Have you tried xlc_r or cc_r instead ?<br /><br /> Using xlC_r or xlc_r, implicitly
sets-qansialias. IIRC we had some issues with<br /> aliasing on other platforms too ? Would that switch be wrong ?<br
/>Doc sais: "Use type-based aliasing during optimization."<br /><div class="Ih2E3d"><br /> > Dunno where the -q64
camefrom ...<br /><br /></div>Probably together with the choice of compiler command ?<br /><font color="#888888"><br />
Andreas</font></blockquote></div><br/><br clear="all" /><br />-- <br />Criveti Mihai<br /><a
href="http://unixsadm.blogspot.com">http://unixsadm.blogspot.com</a><br/><br />