[postgis-users] Access denied to language C

[Guillaume Sueur]

hi,

did you make a
createlang plpgsql name_of_database before ?
are you running it with postgres account ?



José Vicente Higón Valero a écrit :
> Hi list,
> I'm trying to installl postgis-1.0.4+postgresql-8.0.4 on suse linux 
> enterprise. I have compiled postgis succesfully but when I try to add 
> the postgis tables ...
> psql -U crt -d bdgis -f /home/postgres/pgsql/share/contrib/lwpostgis.sql
> ... this error occurs:
> 
> psql:/home/postgres/pgsql/share/contrib/lwpostgis.sql:36: ERROR: access 
> denied to language C
> 
> You can see into this file (lines 33,34,35,36) :
> 
> CREATE OR REPLACE FUNCTION histogram2d_in(cstring)
>         RETURNS histogram2d
>         AS '$libdir/liblwgeom.so.1.0', 'lwhistogram2d_in'
>         LANGUAGE 'C' IMMUTABLE STRICT; -- WITH (isstrict);
> 
> 
> Anyone can help me?
> 
> Thanks in advance

-- 
---------------------------
Guillaume SUEUR
GEOSIGNAL - Groupe BVA
25bis Avenue Marcel Dassault
31505 TOULOUSE CEDEX 5
----------------------------