Received: from flex.flex.ro (IDENT:root@[193.230.255.4]) by hub.org (8.10.1/8.10.1) with ESMTP id e5KHZPM77892 for ; Tue, 20 Jun 2000 13:35:26 -0400 (EDT) Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3]) by flex.flex.ro (8.9.3/8.9.3) with ESMTP id UAA27417; Tue, 20 Jun 2000 20:40:59 +0300 Message-ID: <394FAAFA.3B7DCBBD@flex.ro> Date: Tue, 20 Jun 2000 20:33:46 +0300 From: Constantin Teodorescu X-Mailer: Mozilla 4.72 [en] (X11; I; Linux 2.2.15 i586) X-Accept-Language: en MIME-Version: 1.0 To: John Campbell CC: pgsql-interfaces@postgresql.org, Keith Subject: Re: pgaccess deletes function in database References: <394A747C.EE5F30D0@mondo-live.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/90 John Campbell wrote: > > 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. what type of function? SQL, C ? > 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. Open the "SQL window" from "Database" menu and check what SQL command does it execute! Try executing in psql the same command! Best regards, Constantin Teodorescu FLEX Consulting Braila, ROMANIA