Date: Mon, 19 Jun 2000 15:54:08 -0400
From: John Campbell <johnnyc@mondo-live.com>
Subject: pgacess deletes function in database
To: "pgsql-interfaces@postgresql.org" <pgsql-interfaces@postgresql.org>
Cc: Keith <keith@slantproductions.com>
Message-id: <394E7A60.4DC2D0DB@mondo-live.com>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7bit

Hi,

I posted this prior to subscribing to the list, and I'm not sure that it
actually got through or not. Apologies if you've recieved this twice.

We've encountered a problem with pgaccess in postgresql v7.0.2. When
trying to insert or view a function in pgaccess, we get the error "stat
failed on file /usr/lib/(*).so no such file or directory status
PGRES_FATAL_ERROR". In fact, the file is there, and this action will
actually delete the function from the database.

However, when we do this from the command line with psql, everything
works fine and there are no problems. The function is inserted
correctly, and it does not complain that the file doesn't exist.

Anybody know of this problem, and if so, is there a work around for it?
Any help or suggestions would be greatly appreciated. 

Thanks,

--John Campbell