Opened 10 years ago

Closed 10 years ago

#767 closed defect (fixed)

Ndims does not exists Error

Reported by: aperi2007 Owned by: pramsey
Priority: medium Milestone: PostGIS 2.0.0
Component: postgis Version: master
Keywords: Cc:

Description

Hi,

try-ing to execute

SELECT Populate_Geometry_Columns('caricamento._csr_map_crop_multiline'::regclass);

on a postgis 200 trunk on debian 32 bit (postgres 9.0.2) I have this error:

ERROR: function ndims(geometry) does not exist

Suggerimento: No function matches the given name and argument types. You might need to add explicit type casts. Dove: PL/pgSQL function "populate_geometry_columns" line 88 at istruzione EXECUTE

Change History (3)

comment:1 Changed 10 years ago by aperi2007

I try same query sql with the last r6604, but still having the error:

ERROR: function ndims(geometry) does not exist

Suggerimento: No function matches the given name and argument types. You might need to add explicit type casts. Dove: SQL statement "ALTER TABLE ONLY caricamento._csr_map_crop_multiline

ADD CONSTRAINT enforce_dims_st_boundary CHECK (ndims(st_boundary) = 2)"

PL/pgSQL function "populate_geometry_columns" line 97 at istruzione EXECUTE

comment:2 Changed 10 years ago by aperi2007

I tested even the parameterless version

select Populate_Geometry_Columns();

But now there is this other error:


ERROR: permission denied for relation raster_columns

Dove: SQL statement "SELECT st_srid(extent) As srid

FROM ONLY public.raster_columns WHERE extent IS NOT NULL LIMIT 1"

PL/pgSQL function "populate_geometry_columns" line 54 at istruzione EXECUTE PL/pgSQL function "populate_geometry_columns" line 52 at assegnazione

Riga: 1


So I try to assign these two tables to the user I'm using.

And after this I have this error:


ERROR: function ndims(geometry) does not exist

Suggerimento: No function matches the given name and argument types. You might need to add explicit type casts. Dove: SQL statement "ALTER TABLE ONLY caricamento._csr_map_crop_multiline

ADD CONSTRAINT enforce_dims_st_boundary CHECK (ndims(st_boundary) = 2)"

PL/pgSQL function "populate_geometry_columns" line 97 at istruzione EXECUTE PL/pgSQL function "populate_geometry_columns" line 52 at assegnazione


comment:3 Changed 10 years ago by aperi2007

Resolution: fixed
Status: newclosed

I try r6609. Now it work.

Note: See TracTickets for help on using tickets.