search

linz / gazetteer

New Zealand Gazetteer of official place names
http://www.linz.govt.nz/regulatory/place-names/find-name/new-zealand-gazetteer-official-geographic-names/new-zealand-gazetteer-search-place-names#zoom=0&lat=-41.14127&lon=172.5&layers=BTTT
Other
2 stars 2 forks source link

Admin Publish function fails #173

Closed SPlanzer closed 3 years ago

SPlanzer commented 3 years ago 
(psycopg2.errors.UndefinedFunction) function gazetteer.gaz_update_export_database() does not exist
LINE 1: select gazetteer.gaz_update_export_database()
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

[SQL: select gazetteer.gaz_update_export_database()]
(Background on this error at: http://sqlalche.me/e/f405
SPlanzer commented 3 years ago

There is no reason porting would have change which schema the function is installed into.

Below is the install src code https://github.com/linz/gazetteer/blob/44c9853bff6141202e40fa46e5919b8e484ae822/src/sql/gazetteer_export_func.sql#L15-L37

I need to get into DaaS to check production. I am currently failing to get into DaaS but this is the next step before resolving dev env issues

SPlanzer commented 3 years ago

Finally got into DaaS and NZGB production

The gaz_update_export_database should be in the gazetteer schema

This is thus an issue with dev deployment