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: [email protected] [mailto:[email protected]] 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: [email protected] > [mailto:[email protected]] On > Behalf Of Stanislav Vanecek > Sent: Monday, November 14, 2011 3:27 PM > To: [email protected] > 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ 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
