search

CartoDB / cartodb-postgresql

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

PG Federated Tables #373

Closed rafatower closed 5 years ago

rafatower commented 5 years ago

Built on top of https://github.com/CartoDB/cartodb-postgresql/pull/372

This adds a function CDB_SetUp_PG_Federated_Table with the following form:

SELECT cartodb.CDB_SetUp_PG_Federated_Table(
  'amazon', -- mandatory, name of the federated server
  'schema_name', -- mandatory
  'table_name', -- mandatory
  'id_column_name', -- mandatory
  'geom_column_name', -- optional, preferably in 4326
  'webmercator_column_name', -- optional, must be in 3857 if present
);
rafatower commented 5 years ago

Tests are failing because of an issue with repositories: https://travis-ci.org/CartoDB/cartodb-postgresql/jobs/595709511#L473

but they work on my machine :tm:

UPDATE: I relaunched them and now they work. Whatever it was (on travis) is fixed now.

Algunenano commented 5 years ago

Superseeded / Included by https://github.com/CartoDB/cartodb-postgresql/pull/382