CartoDB / cartodb-postgresql

PostgreSQL extension for CartoDB
BSD 3-Clause "New" or "Revised" License
111 stars 52 forks source link

Federated Server functions #382

Closed Algunenano closed 4 years ago

Algunenano commented 4 years ago

Add some new functions to manage a federated server.

This includes parts of the code from https://github.com/CartoDB/cartodb-postgresql/pull/373 and https://github.com/CartoDB/cartodb-postgresql/pull/381 and probably deprecates code recently added to CDB_ForeignTable.

As a WIP it still misses quite a bit of tests around corner cases (server / schema not existing, odd names...) and has some TODO's left (permissions, possible improvements) but it can be reviewed so we confirm this is the API we want to use.

Public functions:

Algunenano commented 4 years ago

Hope listings have some ORDER BY somewhere to avoid testability issues.

All listing functions use ORDER BY so it's covered.