Hi,
I have a confusing situation that I suspect is system related but would
like to know what needs fixing. Both systems run postgresql-7.1.2 with
perl and tcl enabled. (I've been trying to get pgreplica to work).
==============================================================
Host1 is a Pentium II 233.
==============================================================
$ gcc --version
2.95.2
$ uname -sr
FreeBSD 4.2-RELEASE
$ psql test
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test=> select int4(4::int8/4::int8);
int4
------
1
(1 row)
==============================================================
Host2 is a Pentium 200MMX (yes I know this is old :-)
==============================================================
$ gcc --version
2.7.2.1
$ uname -sr
FreeBSD 3.2-RELEASE
$ psql test
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test=# select int4(4::int8/4::int8);
ERROR: int8 conversion to int4 is out of range
==============================================================
Is this a hardware/software/system library problem? What do I need to do
to fix it?
Colin
--
Colin Campbell
Unix Support/Postmaster/Hostmaster
CITEC
+61 7 3006 4710
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
