Re: [GENERAL] Error creating function

2011-07-21 Thread Rebecca Clarke
Hi Tom Thanks for your reply. I was restoring one schema (with data) at a time from 8.3 db to a pre-created empty 8.4 db. I received a lot of errors which game down to me not restoring the public schema first. I also realized, I had not created plpgsql language for the 8.4 db before I did the res

Re: [GENERAL] Error creating function

2011-07-20 Thread Tom Lane
Rebecca Clarke writes: > 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