[postgis-users] undefined symbol: DirectFunctionCall2 ?

[Paul Ramsey]

Some functions are just plain Dropped between versions, and actually
the ones you cited looked like losers to me. The best bet is to put a
dump against a clean newly installed PostGIS database.

P.

On Tue, Sep 27, 2011 at 1:55 PM, Greg Allensworth <gregor at greeninfo.org> wrote:
> On 9/27/2011 1:41 PM, Paul Ramsey wrote:
>>
>> Create a new database
>> Load PostGIS 1.5 into that blank database
>> Load your dump file into that PostGIS 1.5 database
>> Watch a lot of errors go by
>
> Yeah, we got that. Aside from these functions, the process still basically
> worked. Still, I'd like for these functions to work.
>
>
>> I think it's possible you've created a new database in PgSQL 9.1 but
>> still linked all your functions to the old PostGIS library, which is
>> not what you're trying to acheive.
>>>
>>> ERROR:  could not load library "/usr/lib/liblwgeom.so.1.3":
>>> /usr/lib/liblwgeom.so.1.3: undefined symbol: DirectFunctionCall2
>
> Hey, you're right: I thought the -1.3 looked fishy. I see now that it
> created /usr/lib/postgresql/postgis-1.5.so And if I manually run those
> commands with the correct .so file specified, it works. Great!
>
> So, next questions would be: what went wrong that it was using the old .so
> in the upgrade output, and how do I correct it?
>
> I suppose one approach is to take the .dump.ascii file, snip out the CREATE
> OR REPLACE FUNCTION paragraphs, substitute the correct .so, and run those.
> Does that sound like a good approach, or a Really Bad Idea?
>
> --
> Greg Allensworth, Web GIS Developer
> BS  A+  Network+  Security+  Linux+  Server+  ZCE-PHP
> GreenInfo Network - Information and Mapping in the Public Interest
> 564 Market Street, Suite 510  San Francisco CA 94104
> PH: 415-979-0343 x302  FX: 415-979-0371    email: gregor at greeninfo.org
> Web: www.GreenInfo.org     www.MapsPortal.org
>
> Subscribe to MapLines, our e-newsletter, at www.GreenInfo.org
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>