aquametalabs / aquameta

Web development platform built entirely in PostgreSQL
GNU General Public License v3.0
1.1k stars 52 forks source link

pg_dump dumps extensions in the wrong order #129

Open erichanson opened 5 years ago

erichanson commented 5 years ago

bundle extension requires the uuid-ossp extension. However, it doesn't explicitly list it as a requirement (because it needs it in a specific schema, which extensions don't support), so pg_dump doesn't know to do the create extension "uuid-ossp" before the create extension bundle. This is doubly a problem because we also can't list it in bundle's .control file because if it's there, it installs the extension in the bundle schema.

This is basically a bug in extensions that we have to figure out how to work around.