Home > mailing lists

Error creating function - Mailing list pgsql-general

From	Rebecca Clarke
Subject	Error creating function
Date	July 20, 2011 10:41:23
Msg-id	CANY3h+QGswUfiQZNVQJazR1q7nkzXy-2OwHP+_to7846VZq94g@mail.gmail.com Whole thread Raw
Responses	compile postgres with visual studio 2010 Re: Error creating function
List	pgsql-general

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

From: Raghavendra
Date: 20 July 2011, 09:38:10
Subject: Re: Two indexes on same column

From: Ruben Blanco
Date: 20 July 2011, 11:09:16
Subject: Worse performance on partitioned table than in non partitioned table