Hello, > 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?
PgAdmin III does not show everything by default, especially types, aggregates, or system catalogs. Verify in pgadmin : File->preferences->display to ensure your aggregates should be displayed. Vincent > > 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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
