Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199508071437.HAA23270@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: IGGD2@cc.uab.es
Date: Mon, 07 Aug 1995 16:37:30 +0000
Subject: AIX problems
To: postgres@postgres.Berkeley.EDU
Message-id: <01HTSQIORNCI0014EB@cc.uab.es>
Organization: Universitat Autonoma de Barcelona
MIME-version: 1.0
Content-type: TEXT/PLAIN; CHARSET=US-ASCII
Content-transfer-encoding: 7BIT
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 07 Aug 95 07:37:24 -0700
Resent-XMts: smtp

Hi everybody,

  A few days ago I ftped the postgres v4r2 and I began to linking
and compiling process. I own a RISC/6000 with AIX 3.2.5. 

The first compilation gave me a lot of warnings of the type
(W) Macro name F_B---- has been redefined

and when arriving at the compilation of src/libpq/fe-pqexec I got
a pair of errors
 Undeclared identifier F_LOREAD
 Undeclared identifier F_LOWRITE

After some work I arrived at the conclusion that the file fmgr.h was
incorrectly generated. I observed that instead of having 
F_LOREAD in line 544 of fmgr.h I got F_nOREAD.

After some more work I deduced that changing line 178 in file
Gen_fmgrtab.sh saying
tr '[a-z]' '[A-Z]' | \

to:

tr -A '[a-z]' '[A-Z]' | \

and initiating the compiling process again (bmake all install)
this works perfectly producing much less warnings and no errors at all.

My conclusion, was that because of using different languages the
tr instruction was no producing the expected result in file fmgr.h.
Compilation worked perfectly after the introduced change.
I hope not to have introduced any additional bug because of this
change.


Now I want to ask another point.

After compilation I began to run postgres.
I performed:

$monitor geocarto

* create e (n=float4)\g
CREATE
Go

* append e (n=5.423) \g
APPEND 21242
Go

* retrieve (e.n) \g

-------------
| n         |
-------------
| 5         |
-------------


Now I have the problem. How do I get the answer to the retrieve query
to be 5.423 ???

Can anybody help me ?


J. Estalrich
Unidad Hidrogeologia
Universidad Autonoma Barcelona
08193 Bellaterra, Barcelona, SPAIN

tfno 34 3 581 24 81
fax  34 3 581 12 63
Email iggd2@cc.uab.es

Thanks in advance.

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/