[BUGS] dlopen() of libpsqlodbc.so from release 7.1.1 fails on Solaris 2.8 Sparc

2001-05-22 Thread Bob Deblier
While trying to upgrade Postgres from version 7.0.3 to 7.1.1, I find that a program which dlopens the library mentioned above now produces the following error message: ld.so.1: ./BeeHive: fatal: relocation error: file /opt/pgsql/lib/libpsqlodbc.so: symbol main: referenced symbol not found I

[BUGS] Failing backend on plpgsql function

2001-05-22 Thread Ondrej Palkovsky
I have the following function. When the function is executed and it gets to the 'IF NOT FOUND', the backend gets restarted. I've read that the exception handling is not perfect in Postgres but this seems to me too hard behaviour for a badly written function. CREATE FUNCTION attach_message(int8,i

[BUGS] pg_dumpall in post

2001-05-22 Thread karthikeyan V
Hi People   I'm planning to upgrade postgresql version 7.0 to 7.1. I tried backuping of my databases using pg_dumpall > filename.dump. I'm getting the error as follows:   "failed sanity check, table user_details was not foundpg_dump failed on users, exiting" I couldn't find solution for this

[BUGS] bug in plpgsql???

2001-05-22 Thread Alexander Zagrebin
Hi! I try to work with trees in Postgres 7.1.1 My test script is CREATE TABLE hierarchy parent INTEGER, child INTEGER ); INSERT INTO hierarchy VALUES (1, 2); INSERT INTO hierarchy VALUES (2, 4); INSERT INTO