[ADMIN] strange problem with plpgsql

2001-12-21 Thread Richard NAGY
27;or' like here in the code. Then, I have an insert in survey_log just when the email change, not if the dateexpire change! It seems that the 'or' does not work. Any idea ? Note : The tests have been tested on a postgresql version 7.0.2 on a RedHat Linux 6.2 machine. -- Richard NAGY Presenceweb / Nameshield  

Re: [ADMIN] Big problem about libpq.so.2.1, ldconfig and ldd

2001-12-12 Thread Richard NAGY
solution : I have rename libpq.so.2.1 to libpq.so.2.1.good Then, I have deleted the 2 old symbolic links and created 3 (yes 3!!) new ones. libpq.so -> libpq.so.2.1.good libpq.so.2 -> libpq.so.2.1.good and the most important one (for my problem) : libpq.so.2.1 -> libpq.so.2.1.good I h

[ADMIN] Big problem about libpq.so.2.1, ldconfig and ldd

2001-12-12 Thread Richard NAGY
it is urgent) Note : you can consult a previous mail of me about this. -- Richard NAGY Presenceweb / Nameshield  

[ADMIN] Strange thing : ldconfig and libpq.so.2.1

2001-12-11 Thread Richard NAGY
I correct this ? In the ldconfig man page, I have seen the -l flag but should I use it and how ? I would appreciate a little help. PS : I have typed the /sbin/ldconfig command line with the good /etc/ld.so.conf but I still have the problem. Thank you Regards. -- Richard NAGY Presenceweb / Nameshield  

Re: [ADMIN] Still having problems on compiling PostgreSQL 6.5.3 on IRIX 6.5

2000-01-18 Thread Richard NAGY
lo Sarah, The versions of cc, flex and bison that are installed on my system are the same. Actually, I'm looking for the LD_LIBRARYN32_PATH  and LD_LIBRARY_PATH. I have noticed that these environment variables were not positionned. So, my question is : What is your "env" output ? Thank you. Greetings. -- Richard NAGY    

Re: [ADMIN] Still having problems on compiling PostgreSQL 6.5.3 on IRIX 6.5

2000-01-17 Thread Richard NAGY
^ "heaptuple.c", line 481: error(1130): expression must have pointer-to-struct-or-union type att[j]->attlen > 0 || VARLENA_FIXED_SIZE(att[j]))); j++) ^ "heaptuple.c", line 525: error(1130): expression must have pointer-to-struct-or-union type if (usecache && att[i]->attcacheoff != -1) ^ (...) "heaptuple.c", line 755: error(1130): expression must have pointer-to-struct-or-union type value[attoff] = heap_getattr(tuple, ^ 97 errors detected in the compilation of "heaptuple.c". make[3]: *** [heaptuple.o] Error 2 make[3]: Leaving directory `/usr1/src/postgresql-6.5.3/src/backend/access/common' make[2]: *** [submake] Error 2 make[2]: Leaving directory `/usr1/src/postgresql-6.5.3/src/backend/access' make[1]: *** [access.dir] Error 2 make[1]: Leaving directory `/usr1/src/postgresql-6.5.3/src/backend' make: *** [all] Error 2 I'm going crazy! I have compiled PostgreSQL 6.5.1 with JAVA and JDBC on Linux on an i686 without any problems but on our IRIX .! Is your file template/irix5 the original one ? Greetings. -- Richard NAGY

[ADMIN] Still having problems on compiling PostgreSQL 6.5.3 on IRIX 6.5

2000-01-17 Thread Richard NAGY
ckend -n32 -U_NO_XOPEN4 -I../.. -c heaptuple.c -o heaptuple.o No such feature exists (-5,116) (...) 97 errors detected in the compilation of "heaptuple.c". I don't know if this tells you something, but I don't know where to look for. -- Richard NAGY http://www.hitsme.com/

[ADMIN] Installing PostgreSQL 6.5.3 on SGI IRIX 6.5

1999-12-22 Thread Richard NAGY
ing directory `/usr1/src/postgresql-6.5.3/src/backend/access' make[1]: *** [access.dir] Error 2 make[1]: Leaving directory `/usr1/src/postgresql-6.5.3/src/backend' make: *** [all] Error 2 What should I verify and do in order to compile with succes ? Greetings -- Richard NAGY http://www.hitsme.com/