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: [email protected]; PostGIS Users Discussion Subject: Re: [postgis-users] aggregate functions [email protected] 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
