Re: pgaccess deletes function in database

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