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

Circular dependency between gazeteer_roles.sql and gazetteer_web_schema.sql #69

Closed strk closed 4 years ago

strk commented 4 years ago

gazeteer_roles.sql wants to alter roles to include gazeteer_web schema in their search path, but gazeteer_web schema is created by gazeteer_web_schema.sql which wants to grant permissions to roles created by the gazeteer_roles.sql file...

This is a circular dependency that must be fixed, or you can't properly install everything w/out sourcing one of the two files twice, and tolerating errors in the first run

strk commented 4 years ago

I would like to work on this but before changing SQL files I'd like to see them with carriage returns removed so not to mix functional and stylistic changes. PR #68 includes that change (but I can take it off in a separate PR if it helps moving it forward) - \cc @billgeo @SPlanzer