Rafa de la Torre
40a2ba9569
Stub function to add server_version to diagnostics
2019-11-08 18:09:22 +01:00
Rafa de la Torre
35b2b7e589
Check the server is of type PG and return jsonb
2019-11-08 18:06:35 +01:00
Rafa de la Torre
4100b66f3b
Scaffolding for diagnostic function(s)
2019-11-08 17:11:04 +01:00
Esther Lozano
b1830e49af
Increase version number to 0.32.0
2019-11-08 13:09:45 +01:00
Esther Lozano
70f1e00980
Merge pull request #379 from CartoDB/fix-oauth-reassign-functions
...
Fix OAuth ownership re-assignation for functions
2019-11-08 12:38:43 +01:00
Esther Lozano
8a4a59b340
Document default privileges on functions
2019-11-07 15:03:46 +01:00
Esther Lozano
f06b899605
Add drop permission test for functions
2019-11-07 11:14:26 +01:00
Esther Lozano
09076924c0
Functions are selectable by all roles but not dropable
2019-11-06 21:12:44 +01:00
Raul Marin
d5b3953568
Regress: Remove output that depends on PROJ release
2019-11-06 18:34:20 +01:00
Raul Marin
c64c61781e
Make tests path insensitive
2019-11-06 18:26:58 +01:00
Raul Marin
82d8f7e1aa
Deprecate FDW user setup ;__(
2019-11-06 18:26:37 +01:00
Esther Lozano
e63f5040d9
Use privileged action on functions for tests
2019-11-06 17:51:00 +01:00
Raul Marin
3cde55ed3a
Enforce output order in CDB_Federated_Server_List_Remote_Columns
2019-11-06 17:32:48 +01:00
Raul Marin
a91f14371a
Use always the modern notation for named parameters
2019-11-06 17:25:10 +01:00
Raul Marin
899a12fc53
FederatedServer: Use NAME for internal types
2019-11-06 17:12:40 +01:00
Raul Marin
01258530ff
Federated Server: Unify remote table listing
...
- Removes DB_Federated_Server_List_Registered_Tables in favor
of CDB_Federated_Server_List_Remote_Tables that now returns
both registered and unregistered tables and, when they are
registered, the information about the associated view
2019-11-06 17:04:11 +01:00
Raul Marin
90b58fcdec
Federated Server: Test with incorrect password
2019-11-06 10:20:53 +01:00
Raul Marin
29e2ee670f
Accept PG9.5 and PG10 permission error messages
2019-11-05 18:29:08 +01:00
Raul Marin
e98b18fd25
Add test around grant permissions and accessing registered tables
2019-11-05 18:07:11 +01:00
Raul Marin
e6f07d4f96
Rework API to grant and revoke permissions
2019-11-05 17:18:49 +01:00
Raul Marin
c9b01592e7
CDB_Federated_Table_Register: Handle conflict nicely
2019-11-05 16:53:25 +01:00
Raul Marin
e2beefdb53
Test around NULLs and invalids arguments
2019-11-05 16:39:13 +01:00
Raul Marin
73ee4107d4
CDB_FederatedServerTables: Improve tests readability
2019-11-05 14:48:52 +01:00
Raul Marin
aa481f4219
Permission tests and fixes for CDB_FederatedServerListRemote
2019-11-05 14:35:52 +01:00
Raul Marin
bac7d79ab3
CDB_FederatedServer: Improve tests readability
2019-11-05 13:22:45 +01:00
Raul Marin
98b2b02199
Improve tests readability and test deleting a server from granted access
2019-11-05 11:19:50 +01:00
Raul Marin
10ed64789d
Add functions to grant and revoke permissions over federated servers
2019-11-04 19:23:36 +01:00
Raul Marin
0f66c54ce5
Comment cleanup
2019-11-04 16:53:48 +01:00
Raul Marin
03bc3436cd
Add more tests for [un-]registering servers
2019-11-04 16:29:18 +01:00
Raul Marin
57f420ab4c
CDB_FederatedServerListRemote: Add rainy tests
2019-11-04 15:32:34 +01:00
Raul Marin
c740cfa499
CDB_Federated_Server_List_Remote_Columns: Return also type name
2019-11-04 15:18:46 +01:00
Raul Marin
eea0198864
Add CDB_Federated_Server_List_Remote_Columns
2019-10-31 15:29:37 +01:00
Raul Marin
f75756138a
CDB_FederatedServerTables: Avoid decimal mismatch
2019-10-30 15:21:00 +01:00
Raul Marin
28376ffecb
CDB_Federated_Table_Register works to refresh a table
2019-10-30 13:53:56 +01:00
Raul Marin
f20a007160
CDB_FederatedServerTables: Some comments
2019-10-30 13:27:44 +01:00
Raul Marin
cf6b00dfd8
CDB_FederatedServerListRemote: Improve comments
2019-10-30 13:20:41 +01:00
Raul Marin
cc5fb37abb
CDB_FederatedServer: Improve comments
2019-10-30 13:16:31 +01:00
Raul Marin
b839235801
Add CDB_Federated_Server_List_Registered_Tables
2019-10-30 12:19:30 +01:00
Raul Marin
d5f84784f0
Add CDB_Federated_Table_Unregister
2019-10-30 11:55:02 +01:00
Raul Marin
7bb0b93f8b
Test renaming
2019-10-30 11:47:45 +01:00
Raul Marin
a26b96347a
Initial implementation of CDB_Federated_Table_Register
2019-10-30 11:40:35 +01:00
Raul Marin
77868a541d
Fix symlinks :D
2019-10-29 18:55:18 +01:00
Raul Marin
b76b754811
CDB_FederatedServerTables skeleton
2019-10-29 18:53:05 +01:00
Raul Marin
664468b1e5
Rename CDB_FederatedServerListRemote files
2019-10-29 18:51:47 +01:00
Raul Marin
d85faa8f85
Now trully fix installcheck target
2019-10-29 18:45:10 +01:00
Raul Marin
f7ab3d28a8
__CDB_FS_List_Foreign_Schemas_PG: Handle order and ignore pg_% schemas automatically
2019-10-29 18:35:02 +01:00
Raul Marin
144c4e722b
Add federated server list remotes
...
Includes:
- CDB_Federated_Server_List_Remote_Schemas
- CDB_Federated_Server_List_Remote_Tables
2019-10-29 18:26:52 +01:00
Raul Marin
e22aaee5f5
Test re-registration of a server with different options
2019-10-29 16:47:35 +01:00
Raul Marin
da9ff0c750
Reimplement CDB_Federated_Server_Register_PG and CDB_Federated_Server_Unregister
2019-10-29 16:19:46 +01:00
Raul Marin
e6cb03300b
Add auxiliar functions to handle internal naming
2019-10-29 15:38:58 +01:00