[postgis-users] aggregate functions

[andy@centremaps.co.uk]

Hi Mark,

Thanks for the response, there seem to be a whole list of variables coming
to light at my end.

Is it possible the admin interface doesn't present aggregate functions even
when they do exist?

On our Windows server we have pgAdminIII v1.4.1 and I can see the
"aggregate" functions as a category

On a Linux server we have phpPgAdmin 4.2.2 which doesn't list the aggregate
functions although they do work

On a desktop computer here we have pgAdminIII v1.8.1 and there is no
immediate sign of these although I will test a query shortly to see if the
function is there but not listed


I guess my question is whether this is normal and whether there's a way to
list what is loaded?

Thanks very much.

Andy


-----Original Message-----
Sent: 16 October 2009 17:38
To: andy at centremaps.com; PostGIS Users Discussion
Subject: Re: [postgis-users] aggregate functions


andy at centremaps.com wrote:

> Hi,
> 
> Is there a reason why the "aggregate" functions might not appear to be
> immediately loaded on installing PostGIS? I'm was looking for ST_Extent 
> in particular from which i realised the set are not shown on my 
> installation.
> 
> My apologies is this is a basic question, i'm new to the list and 
> wasn't
> sure of an easy way (apart from looking for matches from google) to 
> search the archives - any tips would be much appreciated!
> 
> Many thanks in advance
> 
> Andy


Hi Andy,

Possibly; I have a feeling we've had a report of this from when an 
upgrade from an older version of PostGIS went wrong in the past, rather 
than being a vanilla new install. Does this sound like it could be your 
situation?


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs