[postgis-users] Insert a point value : ST_GeometryFromText unknown function

[efusien]

Thank's to help :-)
So I did these tasks in a Ubuntu shell:

$ sudo createdb test
=>

$ sudo createlang plpgsql test
=> createlang: language "plpgsql" is already installed in database "test"

$ sudo psql -d test -f
/usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql -v ON_ERROR_STOP=1
=> SET
BEGIN
psql:/usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql:59: ERROR: 
permission denied for language c

...fail
I see on other websites that I have to be logged with root. But I allready
use "sudo" (Ubuntu). What's wrong ? Any idea ?





Sandro Santilli wrote:
> 
> On Tue, Jan 03, 2012 at 11:54:34AM -0800, efusien wrote:
> 
>> I have this error :
>> ERROR:  function postgis_full_version() does not exist
>> 
>> Does it mean I have to install some other features ?
> 
> See instructions about how to spatially-enable a database here:
> http://postgis.refractions.net/documentation/manual-svn/postgis_installation.html#create_new_db
> 
> --strk;
> 
>   ,------o-. 
>   |   __/  |    Thank you for PostGIS-2.0 Topology !
>   |  / 2.0 |    http://www.pledgebank.com/postgistopology
>   `-o------'
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://old.nabble.com/Insert-a-point-value-%3A-ST_GeometryFromText-unknown-function-tp33073860p33075108.html
Sent from the PostGIS - User mailing list archive at Nabble.com.