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
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
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
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