[ADMIN] Problem with money data type

Hi, Recently upgraded our DB to RH6.0 and 6.4.2 postgres now it wont accept input of the money data type. We are inputing a value of 35.00 in an insert queery and it telling us that it is an incompatible data type because the attribut is of type money but the expression is of float 8. We ha

[ADMIN] building odbc for 6.5 on glibc2.1.1

when i `./configure --with-perl --with-odbc --with-tcl' i get the attached errors while building odbc. anyone know how i can get this to compile cleanly? i'm using linux 2.2.10, glibc 2.1.1, egcs 1.1.2. thanks. --- make -C odbc all make[2]: Entering directory `/usr/src/postgresl-6.5/src/interf

Re: [ADMIN] Problem with money data type

At 14:11 +0300 on 15/06/1999, Travers Coward wrote: > We are inputing a value of 35.00 in an insert queery and it telling us > that it is an incompatible data type because the attribut is of type > money but the expression is of float 8. We have tried casting it to > money with no success. If

[ADMIN] Problem installing PostgreSQL 6.5

Hello people, I'm trying to install PostgreSQL 6.5 which I've downloaded today. It goes well for a long time but it stops with the following messages. Does somebody know why this happens and how I can solve this? Thanks, Jelle. SYSTEM-INFO --- SGI-IRIX 6.2, IP22, R4600 gmake 3.76.1

[ADMIN] IpcMemoryCreate: shmget failure with 6.5 under Solaris 2.6 (gcc compile)

I've been plagued with mem problems with 6.4.2 (spinlock crashes) so I've compiled 6.5 under Solaris 2.6. All fine with the gcc compile, but when I run postmaster with defaults I get: IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1073152, permission=600 FATAL 1: ShmemCreat

Re: [ADMIN] IpcMemoryCreate: shmget failure with 6.5 under Solaris 2.6(gcc compile)

[Charset iso-8859-1 unsupported, filtering to ASCII...] > I've been plagued with mem problems with 6.4.2 (spinlock crashes) so I've > compiled 6.5 under Solaris 2.6. All fine with the gcc compile, but when I > run postmaster with defaults I get: > > IpcMemoryCreate: shmget failed (Invalid argume

[ADMIN] 6.5 on FreeBSD 2.2 - any problems?

Hi, been running 6.4 for ages now, and looking to upgrade... I just made 6.5 on a FreeBSD 2.2 box, and everything seems to do fine. made it while 'root' Installed it while user 'root', into '/usr/loocal/pgsql', having moved pgsql to pgsql-6.4. switch to user 'postgres' and do 'initdb' - seems f