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

[Paragon Corporation]

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
>