| 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: | Whole Thread | Raw Message | 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
| 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 |