Commit Graph

  • 0e891eff7f Remove cartodb from search path Raul Marin 2019-10-03 17:29:35 +02:00
  • 52b3290d26 CDB_TableMetadata: Use secure search_path Raul Marin 2019-10-03 17:27:40 +02:00
  • 186ee37a57 CDB_Username: Set secure search_path Raul Marin 2019-10-03 16:54:55 +02:00
  • 0898881470 Oauth: Set secure search_path Raul Marin 2019-10-03 16:53:02 +02:00
  • 4dfd71639a CDB_OAuthReassignTableOwnerOnCreation: Use CDB_Conf_GetConf Raul Marin 2019-10-03 15:14:40 +02:00
  • c6b90aac8a GhostTables: Set secure search_path Raul Marin 2019-10-03 13:59:51 +02:00
  • 8a87f96f04 Merge pull request #370 from Algunenano/ghost_matview Raúl Marín 2019-10-03 15:06:11 +02:00
  • 7c10fcc363 Update NEWS Raul Marin 2019-10-01 11:03:53 +02:00
  • 2f178bd89e _CDB_SetUp_User_PG_FDW_Server: Minor log changes Raul Marin 2019-10-01 10:47:37 +02:00
  • 32489c4eab Ghost tables: Add missing tags Raul Marin 2019-10-01 10:46:37 +02:00
  • afa52aa92b Prepare release 0.30.0 0.30.0 Rafa de la Torre 2019-07-17 09:58:21 +02:00
  • 746dbea434 Merge pull request #369 from CartoDB/user-defined-fdw Rafa de la Torre 2019-07-17 09:52:23 +02:00
  • f9bd469ea9 Make oauth tests a bit more robust Rafa de la Torre 2019-07-17 09:46:49 +02:00
  • 402d97daa6 Merge remote-tracking branch 'origin/master' into user-defined-fdw Rafa de la Torre 2019-07-17 09:18:35 +02:00
  • e41d2ec019 Add a flag to force drop of user FDW and related objects Rafa de la Torre 2019-07-16 17:35:41 +02:00
  • 3c460f1a85 Add a bunch of RAISE NOTICE's to inform user about progress Rafa de la Torre 2019-07-16 17:03:23 +02:00
  • 076207c49c Make sure there are no (double)escaping issues Rafa de la Torre 2019-07-16 16:24:02 +02:00
  • ce1e9ac41c Prefix all objects created with cdb_fdw_ Rafa de la Torre 2019-07-16 14:51:17 +02:00
  • 0f33ee8b22 Prepend an underscore (_) to functions meant to be run by superuser Rafa de la Torre 2019-07-16 14:32:32 +02:00
  • a32dea0282 Remove SECURITY DEFINER from user-defined FDW's Rafa de la Torre 2019-07-16 13:26:03 +02:00
  • 3a255df9d0 Rename PG-FDW's-specific functions to _PG_FDW_ Rafa de la Torre 2019-07-16 13:14:11 +02:00
  • c4e2549dc8 A few more permissions tests for completeness Rafa de la Torre 2019-07-15 18:14:23 +02:00
  • 2e9f642378 Check when users shall not have permissions to the FDW Rafa de la Torre 2019-07-15 17:28:37 +02:00
  • 99096d41e0 Drop the role when dropping a user-defined FDW Rafa de la Torre 2019-07-15 17:25:48 +02:00
  • 3a10ef7e76 Add ability to grant fdw role to org members Rafa de la Torre 2019-07-15 16:54:23 +02:00
  • a20676f391 Add a test/example of granting the fdw role Rafa de la Torre 2019-07-15 16:19:06 +02:00
  • 37004db047 Add new function to drop a user-defined foreign server Rafa de la Torre 2019-07-15 16:14:07 +02:00
  • 1189d70b2a Request host auth to use password Rafa de la Torre 2019-07-15 14:52:39 +02:00
  • 8cfc8e65cf Test with a regular user (non-superadmin) Rafa de la Torre 2019-07-15 14:44:21 +02:00
  • 32db4fd81e Merge pull request #367 from CartoDB/oauth_create_table_trigger 0.29.0 Gonzalo Riestra 2019-07-15 13:43:08 +02:00
  • a1e3e9a8df update news Gonzalo Riestra 2019-07-15 13:42:43 +02:00
  • 6e34e16b8d Add basic test for user-defined FDW's Rafa de la Torre 2019-07-15 13:16:14 +02:00
  • 70220e04c1 Allow for imports of tables in different source schemas Rafa de la Torre 2019-07-15 13:13:21 +02:00
  • a5cb9f268d reassign ownership for sequences and functions as well Gonzalo Riestra 2019-07-15 12:31:44 +02:00
  • d2d909145d Add convenience function to import fdw tables Rafa de la Torre 2019-07-12 16:47:18 +02:00
  • 34dec227c4 Rename to CDB_SetUp_User_Foreign_Server Rafa de la Torre 2019-07-12 16:36:34 +02:00
  • 99e92e2505 Create a "PUBLIC" user mapping Rafa de la Torre 2019-07-12 16:23:34 +02:00
  • c58a084102 Tweak ownership of db objects Rafa de la Torre 2019-07-12 13:27:41 +02:00
  • b7907ff82f Fix typo granting perms Rafa de la Torre 2019-07-12 13:06:37 +02:00
  • 12d955075a Fix bug iterating user_mapping options Rafa de la Torre 2019-07-12 13:05:52 +02:00
  • 10a4d85c01 Fix typo in example: missing closing } Rafa de la Torre 2019-07-12 13:02:48 +02:00
  • 524bb6ad42 Fix copy/paste typos Rafa de la Torre 2019-07-12 12:49:59 +02:00
  • 4da89d8abd First version of the function WIP Rafa de la Torre 2019-07-12 12:40:02 +02:00
  • c7311ba48e A stub of a convenient FDW function Rafa de la Torre 2019-07-12 12:00:30 +02:00
  • 2eae7876e2 fix makefile Gonzalo Riestra 2019-07-12 08:38:21 +02:00
  • 91c3b86d45 Updated NEWS and tests README Mario de Frutos Dieguez 2019-07-04 17:53:11 +02:00
  • f55d789c41 Make some tests to have different expects for different PG versions Mario de Frutos Dieguez 2019-07-04 17:40:00 +02:00
  • 3eb8ab24d8 Improved tests Mario de Frutos Dieguez 2019-07-04 13:46:53 +02:00
  • 0f1c98c743 Check for empty strings as well Mario de Frutos Dieguez 2019-07-04 13:07:50 +02:00
  • 8ecd2cd5e2 Reuser creator_role Mario de Frutos Dieguez 2019-07-04 11:26:26 +02:00
  • f4be59cae0 Added tests Mario de Frutos Dieguez 2019-07-03 18:00:57 +02:00
  • fe66b2865a Upgrade version to 0.29.0 Mario de Frutos Dieguez 2019-07-03 16:48:30 +02:00
  • 2be9d2d81a Enable OAuth scripts Mario de Frutos Dieguez 2019-07-03 16:48:19 +02:00
  • 5744921065 OAuth functions Mario de Frutos Dieguez 2019-07-02 18:20:26 +02:00
  • 4c93258cd2 Prepare release of 0.28.1 0.28.1 Rafa de la Torre 2019-07-04 16:09:53 +02:00
  • bf140890d8 Merge pull request #365 from CartoDB/table-syncer-notmps Javier Goizueta 2019-07-04 16:05:21 +02:00
  • 29a31d4c40 Merge pull request #362 from CartoDB/fdw-affected-tables Rafa de la Torre 2019-07-04 16:02:46 +02:00
  • dbd403a2f6 Fix cases of double-quoting identifiers Javier Goizueta 2019-07-04 12:47:58 +02:00
  • cb353ec6a8 Add tests for quoted table & column names Javier Goizueta 2019-07-04 12:47:01 +02:00
  • 2beabfced6 Add test for double schema-quoting Javier Goizueta 2019-07-03 18:48:49 +02:00
  • 7bdee5c13e Avoid double-quoting Javier Goizueta 2019-07-03 18:34:54 +02:00
  • c07784566a NEWS for next release Javier Goizueta 2019-07-03 17:02:36 +02:00
  • 2e1fe2933c Fix whitespace Javier Goizueta 2019-07-03 16:56:29 +02:00
  • d378ca6fe0 Test for missing foreign CDB_TableMetadata Rafa de la Torre 2019-07-03 16:25:16 +02:00
  • 446f4113d9 Return NULL instead of NOW() Rafa de la Torre 2019-07-03 16:19:46 +02:00
  • 5963c67376 Order the columns of a cartodbfied table consistently Javier Goizueta 2019-07-03 16:16:37 +02:00
  • f5f18ca57c Fix the order of the columns Javier Goizueta 2019-07-02 18:14:18 +02:00
  • d8c840d126 Quote table and column names when necessary Javier Goizueta 2019-07-02 18:14:04 +02:00
  • 65483743b4 Remove unused vars Javier Goizueta 2019-07-02 17:44:06 +02:00
  • 4651883454 Fix order of test results Javier Goizueta 2019-07-02 17:43:13 +02:00
  • 470bae6268 Merge branch 'master' into table-syncer-notmps Javier Goizueta 2019-07-02 12:21:49 +02:00
  • 75ba13b834 Merge pull request #364 from CartoDB/synctable-doc Javier Goizueta 2019-07-02 10:20:24 +02:00
  • 057695361d Fix typo Javier Goizueta 2019-07-01 17:49:42 +02:00
  • 0e1aeb0a76 Minor copy edit Javier Goizueta 2019-07-01 17:00:22 +02:00
  • f2dae651b3 More complete sync table example Javier Goizueta 2019-07-01 16:58:24 +02:00
  • 9f414938ba Document CDB_SyncTable Javier Goizueta 2019-07-01 16:41:40 +02:00
  • 4f7b07f922 Merge pull request #363 from CartoDB/fix-sync-schema 0.28.0 Javier Goizueta 2019-07-01 16:15:25 +02:00
  • 69cc56b589 Remove schema from public function examples Javier Goizueta 2019-07-01 15:13:48 +02:00
  • 1028b24333 Fix cartodb schema references Javier Goizueta 2019-07-01 14:48:42 +02:00
  • 4d1c4f6a22 Release 0.28.0 Javier Goizueta 2019-07-01 10:56:06 +02:00
  • 83ab128a01 Merge pull request #355 from CartoDB/table-syncer Javier Goizueta 2019-07-01 10:49:06 +02:00
  • b0b4a92240 Add a test case for missing foreign CDB_Tablementadata Rafa de la Torre 2019-06-28 15:55:42 +02:00
  • c06d24aa19 Make CDB_Get_Foreign_Updated_At robust to missing CDB_TableMetadata Rafa de la Torre 2019-06-28 14:52:37 +02:00
  • 4f4df2de8d Merge branch 'table-syncer' into table-syncer-notmps Javier Goizueta 2019-06-28 15:28:06 +02:00
  • b5f36902c5 Merge branch 'master' into table-syncer Javier Goizueta 2019-06-28 13:50:46 +02:00
  • 0bcbf6708a Remove usage of temporary tables Javier Goizueta 2019-06-28 13:49:15 +02:00
  • 2e665a56b4 release 0.27.2 0.27.2 Gonzalo Riestra 2019-06-21 09:19:04 +02:00
  • 1e8ef2e1d9 Merge pull request #360 from CartoDB/fix-ghost-tables-trigger Gonzalo Riestra 2019-06-21 09:15:20 +02:00
  • e6ecde4346 add CREATE/ALTER/DROP FOREIGN TABLE to ddl commands Gonzalo Riestra 2019-06-20 11:20:48 +02:00
  • 2d42e6197a use bigint to store values from txid_current() Gonzalo Riestra 2019-06-20 11:20:03 +02:00
  • 5605fdd9b2 fix event trigger Gonzalo Riestra 2019-06-19 15:27:28 +02:00
  • ab7082d4c3 Merge pull request #359 from CartoDB/fix_carto-package Sergio Conde Gómez 2019-06-17 13:40:35 +02:00
  • f9ac627e0e Fix carto-package requirements to be SemVer compliant Sergio Conde Gomez 2019-06-17 13:33:24 +02:00
  • cc2066ea89 Release 0.27.1 0.27.1 Raul Marin 2019-06-03 17:57:42 +02:00
  • aa380171b4 Merge pull request #358 from Algunenano/missing Raúl Marín 2019-06-03 16:26:10 +02:00
  • a43abb37e0 Add missing qualifications Raul Marin 2019-06-03 15:22:52 +02:00
  • 787b513715 Release 0.27.0 0.27.0 Raul Marin 2019-06-03 12:51:25 +02:00
  • 362af5e6a0 Merge pull request #357 from Algunenano/full_schema_rebase Raúl Marín 2019-06-03 12:45:04 +02:00
  • 8dbd797429 Update CONTRIBUTING.md Raul Marin 2019-06-03 12:31:06 +02:00
  • 57ac26cbe7 Travis: Add PG 9.6 to the test matrix Raul Marin 2019-05-31 16:18:47 +02:00