Thread: pgaccess deletes function in database

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

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