pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgaccess deletes function in database 2+ messages / 2 participants [nested] [flat]
* pgaccess deletes function in database @ 2000-06-16 18:39 John Campbell <johnnyc@mondo-live.com> 0 siblings, 1 reply; 2+ messages in thread From: John Campbell @ 2000-06-16 18:39 UTC (permalink / raw) To: pgsql-interfaces@postgresql.org, Keith <keith@slantproductions.com> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgaccess deletes function in database @ 2000-06-20 17:33 Constantin Teodorescu <teo@flex.ro> parent: John Campbell <johnnyc@mondo-live.com> 0 siblings, 0 replies; 2+ messages in thread From: Constantin Teodorescu @ 2000-06-20 17:33 UTC (permalink / raw) To: John Campbell <johnnyc@mondo-live.com>; +Cc: pgsql-interfaces@postgresql.org, Keith <keith@slantproductions.com> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-06-20 17:33 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-06-16 18:39 pgaccess deletes function in database John Campbell <johnnyc@mondo-live.com> 2000-06-20 17:33 ` Constantin Teodorescu <teo@flex.ro>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox