Error creating function

From: Rebecca Clarke <rebecca(at)clarke(dot)net(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Error creating function
Date: 2011-07-20 10:41:11
Message-ID: CANY3h+QGswUfiQZNVQJazR1q7nkzXy-2OwHP+_to7846VZq94g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I'm doing a restore into Postgresql 8.4, postgis 1.5.1 and I'm getting the
following error when it creates the below function:

pg_restore: creating FUNCTION _get_buffer(geometry, double precision,
integer)
pg_restore: [archiver (db)] Error from TOC entry 966; 1255 49162661 FUNCTION
_get_buffer(geometry, double precision, integer) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: SQL function
cannot accept shell type geometry
Command was: CREATE FUNCTION _get_buffer(_geom geometry, _radius double
precision, _density integer, OUT the_geom geometry) RETURNS geome...

I don't understand what 'cannot accept shell type geometry' means? Can
anyone help my lack of knowledge?

Thanks

Rebecca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sofer, Yuval 2011-07-20 10:56:34 compile postgres with visual studio 2010
Previous Message Raghavendra 2011-07-20 09:29:34 Re: Two indexes on same column