CartoDB / cartodb-postgresql

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

CDB_RegenerateTable #400

Closed Algunenano closed 4 years ago

Algunenano commented 4 years ago

Adds a new function, cartodb.CDB_RegenerateTable that regenerates a table in place, refreshing it on disk but keeping dependencies intact.

Works with (or should):

Does not work (will fail and leave everything as is):

I've also raised the minimum PG release to 11. Prior release will probably still work, but we don't test it so they will start failing at some point.

Closes https://github.com/CartoDB/cartodb-postgresql/issues/352