[postgis-users] aggregate functions
Picavet Vincent
Vincent.Picavet at mediapost.fr
Mon Oct 19 06:15:54 PDT 2009
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: 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
More information about the postgis-users
mailing list