Re: Segmentation fault

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 <guillaume(at)lelarge(dot)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
>