[postgis-users] select postgis_full_version()

Sandro Santilli strk at keybit.net
Fri Jan 16 01:55:40 PST 2015

On Fri, Jan 16, 2015 at 10:52:25AM +0100, Sandro Santilli wrote:
> On Thu, Jan 15, 2015 at 05:49:53PM -0500, zach cruise wrote:
> > does anyone know where we can look at this line 19 where
> > postgis_LIB_version() is being called (i just call "select
> > postgis_FULL_version();")?
> I don't see an error in your log, anyway
> just call SELECT postgis_lib_version() yourself and see if it works.
> Context that can change whether or not it works is search_path and
> currentuser()

That's "current_user" (not a function).

  select postgis_lib_version();
  select current_user;
  show search_path;
  select n.nspname from pg_namespace n, pg_proc p
    where p.proname = 'postgis_lib_version' and n.oid = p.pronamespace;


  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html

More information about the postgis-users mailing list