The query select count(*) from pg_proc where proname='pg_file_write'; returns 1
On Wed, Jul 8, 2009 at 1:42 AM, Guillaume Lelarge <guilla...@lelarge.info>wrote: > Le mardi 7 juillet 2009 à 23:47:18, Michael Shapiro a écrit : > > I have no idea. Would this be part of the postgres server or part of > > PgAdmin? > > > > The adminpack is a contrib module. You need to install it on the server for > pgAdmin to use it. It adds a few functions, like pg_file_write that pgAdmin > needs to be able to write on the config file. > > To check if you have this module installed, the simplest thing to do is to > check if pg_file_write function exists. The SQL query should tell you how > many > pg_file_write() function you have: > > select count(*) from pg_proc where proname='pg_file_write'; > > 0 meaning that you don't have this function. > > > -- > Guillaume. > http://www.postgresqlfr.org > http://dalibo.com >
