Received: from falla.videotron.net (falla.videotron.net [205.151.222.106]) by hub.org (8.10.1/8.10.1) with ESMTP id e5GIfcM06352 for ; Fri, 16 Jun 2000 14:41:39 -0400 (EDT) Received: from mondo-live.com ([24.200.141.239]) by falla.videotron.net (Sun Internet Mail Server sims.3.5.1999.12.14.10.29.p8) with ESMTP id <0FW900J3QFX989@falla.videotron.net> for pgsql-interfaces@postgresql.org; Fri, 16 Jun 2000 14:41:33 -0400 (EDT) Date: Fri, 16 Jun 2000 14:39:56 -0400 From: John Campbell Subject: pgaccess deletes function in database To: pgsql-interfaces@postgresql.org, Keith Message-id: <394A747C.EE5F30D0@mondo-live.com> MIME-version: 1.0 X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdk i586) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en X-Archive-Number: 200006/89 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. I do not subscribe to the list, so please cc: any replies directly to me. Thanks, --John Campbell