Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199508080901.CAA06971@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: IGGD2@cc.uab.es
Date: Tue, 08 Aug 1995 11:02:04 +0000
To: postgres@postgres.Berkeley.EDU
Message-id: <01HTTTOWPH4I0018G2@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: Tue, 08 Aug 95 02:01:27 -0700
Resent-XMts: smtp


Hi everybody,

  A few days ago I ftped the postgres v4r2 and I began the compiling
and linking processes (bmake all install). 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_BYTEA has been redefined
(W) Macro name F_n has been redefined

and when arriving at the compilation of src/libpq/fe-pqexec I got
a pair of system 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 report another problem.

After compilation I began to run postgres after opening the postmaster
and creating a database and a user.
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/