vertica place in version 8.0?

Forum|Forum|9 years ago
November 15, 2016
3 replies
25 views

jdobbins
New Participant

Hello,

We just upgraded our development instance from 7.2 to 8.0 and I cannot find the location of the geospatial functions (the placelib library). I understand this was included with the basic installation in 8.0. Previously, we had all of the Vertica Place functions installed in the public schema.

The errors we get are "doesn't exist or permission denied" (me) and "library was compiled with an incompatible SDK version [7.2.1]" (dbadmin account). I am trying to use the ST_GeomFromText function to update a geometry field of latitude and longitude positions.

Any help is much appreciated...thanks!

-Jimmy

Arun_Prasad
Participating Frequently
Forum|Forum|9 years ago
November 17, 2016

Hi Jimmy,

For error 1, you may check in user_functions and grant permission to your users from dbadmin

For error 2, you may need to re-install packages .

Just check compare the packages using the below command

=> SELECT lib_name, sdk_version FROM user_libraries;

and update the packages using $ admintools -t install_package -d -P geospatial.

Hope this helps

Thanks

Arun

Like

jdobbins
Author
New Participant
Forum|Forum|9 years ago
November 21, 2016

Thanks, Arun...that did the trick. From my understanding the packages are supposed to upgrade with the 7.2 to 8.0 upgrade, but ours didn't. Everything is now working after we ran the command you mentioned. We also found reference information here:

Documentation Link

Thanks,

-Jimmy