[postgis-users] PoctGIS 2.0 : ERROR: 42883:functionst_srid(raster) does not exist

[Stanislav Vanecek]

Hi Regina 
 Sorry for the late answer. I have a problems to reproduce in some
databases - but finally I found than problem is released to the
search-path and can be solved by
*	Putting public as the first to the search_path (when it was in
different place - I have a problem)
*	Or use SET search_path = public; as the first command
After this - everything work OK
Best regards
Standa

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Paragon Corporation
Sent: Tuesday, November 15, 2011 1:52 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] PoctGIS 2.0 : ERROR:
42883:functionst_srid(raster) does not exist

Standa,

I don't seem to be able to generate that error with Monday build.  I was
testing with the 9.1 version though, just using the raster2pgsql.py
loader
and not testing in .NET.
Also tried ST_SRID alone on a raster.

Given that it seems to work okay in PgAdmin but not in .NET for you, I
suspect a permission error.

Are you using the same PostgreSQL account in your .NET app as what you
are
using in PgAdmin?  If not try to connect as the same account
in PgADmin and see if you get the same error and try switching account
in
.NET to see if it works.

If you do then its definitely a permission issue and you just have to
make
sure that account you are using for your .NET app has rights to all the
PostGIS functions.

Hope that helps.
Regina

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Stanislav Vanecek
> Sent: Monday, November 14, 2011 3:27 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] PoctGIS 2.0 : ERROR: 42883: 
> functionst_srid(raster) does not exist
> 
> Hi
>   I am executing command
>  "CREATE TABLE workspace1.fc_cbd8a88e87c942b9bdcef66d158eaba9 
> (id uuid NOT  NULL, CONSTRAINT 
> fc_cbd8a88e87c942b9bdcef66d158eaba9_pk PRIMARY KEY
> (id))  WITH (OIDS=FALSE);
> 
> SELECT
> AddRasterColumn('workspace1','fc_cbd8a88e87c942b9bdcef66d158ea
> ba9','rast
> ', 2043, ARRAY['32BF'], false, false, null,100,100,null,null,null);  
> 
> And I obtain : ERROR: 42883: function st_srid(raster) does not exist
> 
> from c# program using DAO. Similar command for 
> AddGeometryColumn work OK.
> 
>  When I run this command (....SELECT AddRasterColumn...) as 
> SQL in pgAdmin  it work OK.
> 
>  I am using the latest (today binaries for the PostGIS 2.0). 
> 
> Can someone help, please  
> 
> thank you  Standa
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111212/25914c66/attachment.html>