[postgis-users] select postgis_full_version()

[zach cruise]

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();")?

where at https://github.com/postgis/postgis ie? we found the following
hits in the source-code at http://postgis.net/source -
postgis-2.1.5\doc\po\it_IT\reference_management.xml.po (1 hit)
	Line 624: "SELECT PostGIS_Lib_Version();\n"
postgis-2.1.5\doc\po\pt_BR\reference_management.xml.po (1 hit)
	Line 624: "SELECT PostGIS_Lib_Version();\n"
postgis-2.1.5\doc\po\templates\reference_management.xml.pot (1 hit)
	Line 463:       "SELECT PostGIS_Lib_Version();\n"
postgis-2.1.5\doc\reference_management.xml (1 hit)
	Line 551: 		<programlisting>SELECT PostGIS_Lib_Version();
postgis-2.1.5\postgis\postgis.sql.in (1 hit)
	Line 2570: 	SELECT postgis_lib_version() INTO libver;
postgis-2.1.5\regress\run_test (1 hit)
	Line 930: libver=`${PSQL} -tAc "select postgis_lib_version()" "${DB}"`
postgis-2.1.5\regress\run_test.pl (2 hits)
	Line 224: my $libver = sql("select postgis_lib_version()");
	Line 247:   $libver = sql("select postgis_lib_version()");

On 1/15/15, zach cruise <zachc1980 at gmail.com> wrote:
> sometimes "select postgis_full_version();" works and othertimes it fails?!
>
> eg from pg log below - it worked at 11:26, failed at 11:27, worked at
> 11:28... (i am running it every minute to find a pattern but without
> luck)
>  ...
>  11:26:00 EST >> LOG:  statement: select postgis_full_version();
>  11:27:00 EST >> LOG:  statement: select postgis_full_version();
>  11:27:00 EST >> CONTEXT:  SQL statement "SELECT postgis_lib_version()"
>          PL/pgSQL function postgis_full_version() line 19 at SQL statement
>  11:27:00 EST >> STATEMENT:  select postgis_full_version();
>  11:28:00 EST >> LOG:  statement: select postgis_full_version();
>  ...
>
> using pg 9.3.2 + pgis 2.1.1.
>
> http://postgis.17.x6.nabble.com/postgis-full-version-error-td5007126.html
> http://gis.stackexchange.com/questions/97871/postgis-2-1-error-after-update
>