Raúl Marín
9010642326
Revert "Revert 0.33.0"
...
This reverts commit 24cb6cf9c1
.
5 years ago
Raúl Marín
24cb6cf9c1
Revert 0.33.0
5 years ago
Raul Marin
82d8f7e1aa
Deprecate FDW user setup ;__(
5 years ago
Raul Marin
164fba197f
test_foreign_tables: Better debugging and query the default database when needed
5 years ago
Raul Marin
5a12033609
Adapt tests to changes
5 years ago
Rafa de la Torre
e41d2ec019
Add a flag to force drop of user FDW and related objects
...
If force = true then it will add the subclause `CASCADE` to the SQL
DDL sentences that support it, otherwise it'll use `RESTRICT` which is
the default and exact opposite.
5 years ago
Rafa de la Torre
076207c49c
Make sure there are no (double)escaping issues
5 years ago
Rafa de la Torre
ce1e9ac41c
Prefix all objects created with cdb_fdw_
...
Build the DB objects related to a user FDW with the following form:
`cdb_fdw_name`. This is aimed at easily inspect and filter them.
As requested in code review.
5 years ago
Rafa de la Torre
0f33ee8b22
Prepend an underscore (_) to functions meant to be run by superuser
...
_CDB_SetUp_User_PG_FDW_Server and _CDB_Drop_User_PG_FDW_Server are
meant to be executed by a superuser. Therefore they shouldn't be
considered part of the public API and hence the _CDB_Private_Function
naming convention.
5 years ago
Rafa de la Torre
a32dea0282
Remove SECURITY DEFINER from user-defined FDW's
5 years ago
Rafa de la Torre
3a255df9d0
Rename PG-FDW's-specific functions to _PG_FDW_
...
As per review comment.
5 years ago
Rafa de la Torre
c4e2549dc8
A few more permissions tests for completeness
5 years ago
Rafa de la Torre
2e9f642378
Check when users shall not have permissions to the FDW
5 years ago
Rafa de la Torre
99096d41e0
Drop the role when dropping a user-defined FDW
5 years ago
Rafa de la Torre
3a10ef7e76
Add ability to grant fdw role to org members
5 years ago
Rafa de la Torre
a20676f391
Add a test/example of granting the fdw role
5 years ago
Rafa de la Torre
37004db047
Add new function to drop a user-defined foreign server
5 years ago
Rafa de la Torre
8cfc8e65cf
Test with a regular user (non-superadmin)
5 years ago
Rafa de la Torre
6e34e16b8d
Add basic test for user-defined FDW's
5 years ago
Rafa de la Torre
d378ca6fe0
Test for missing foreign CDB_TableMetadata
5 years ago
Rafa de la Torre
b0b4a92240
Add a test case for missing foreign CDB_Tablementadata
5 years ago
Raul Marin
78077a6ec1
Bash tests improvements
...
- Stop loading sql files manually.
- Make tests independent.
- Single DB setup (not once per test)
5 years ago
Eneko Lakasta
b209726b1c
Merge pull request #320 from bloomberg/v0_18_5/cdb_tablemetadata_text_hotfix
...
Fix incorrect timestamps in CDB_TableMetadata_Text
6 years ago
Tyler Parsons
5c86029029
Test for correct timestamps in cdb_tablemetadata_text
7 years ago
Tyler Parsons
acd101af9b
Use PGPORT as fdw port if specified
7 years ago
Raul Marin
0f7a1c4882
Remove PARALLEL mode in older versions (up to 9.6)
7 years ago
Javier Goizueta
399b680b41
Merge pull request #283 from CartoDB/157-test-fixes
...
Fix tests: race condition with publicuser #157
8 years ago
Rafa de la Torre
30cd4cf1f9
Fix tests: race condition with publicuser #157
8 years ago
Javier Goizueta
1356131ec1
Fix tests
8 years ago
Javier Goizueta
1f01ecae30
Exclude overviews from user data size
...
Fixes #261
Some internal functions from the Overviews module
have been moved to a separate file because they're now
used from Quaota function.
8 years ago
Raul Ochoa
de5a702510
Adds table for storing camshaft analysis nodes
9 years ago
Alejandro Martínez
90c16fdb13
Fully qualify invalidations
9 years ago
Alejandro Martínez
56fed12392
Add CDB_TableMetadata_Text view as a proxy to access FDW tablemetadata
9 years ago
Rafa de la Torre
9596e8d9bc
A couple checks for quoted idents in CDB_Last_Updated_Time
9 years ago
Rafa de la Torre
06036e2fe8
Quote identifiers returned by CDB_QueryTables_Updated_At
9 years ago
Rafa de la Torre
2bce771488
Add some tests
...
Tests for:
* CDB_QueryTables_Updated_At
* CDB_Last_Updated_Time
9 years ago
Alejandro Martínez
fdbad0f93c
Fix specs on 9.3
9 years ago
Alejandro Martínez
131aee1503
Fully qualify function names
9 years ago
Alejandro Martínez
e858ddfa0b
Add CDB_ForeignTable specs
9 years ago
Rafa de la Torre
6e4a5b5635
Add CASCADE to DROP SCHEMA... in tear_down #138
9 years ago
Raul Ochoa
5abe6e0b3d
Merge branch 'master' into cdb_querytables_quoted
...
Conflicts:
test/extension/test.sh
9 years ago
Raul Ochoa
4be7d4a497
Use quote_ident to quote schema and table names when necessary
...
Fixes #133
9 years ago
Raul Ochoa
350c76f847
Add option to run tests by prefix
...
`bash test/extension/test.sh test_cdb_querytables`
will run all tests that start with test_cdb_querytables
9 years ago
Raul Ochoa
e28b6344aa
Assert it's not possible to get column names from a table without permissions
9 years ago
Raul Ochoa
2867a6fbad
Assert user can use its schema to retrieve column names
9 years ago
Raul Ochoa
7582f2cbc5
CDB_ColumnType uses schema and table from regclass
...
Fixes #130
9 years ago
Raul Ochoa
4b5c5dd275
CDB_ColumnNames uses schema and table name from regclass
...
Fixes #122
9 years ago
Raul Ochoa
eb6fc4fefb
Use CDB_ColumnType and CDB_ColumnNames in bash tests
9 years ago
Raul Ochoa
fc95566ddd
Remove test for unexistent table as there was already one
10 years ago
Raul Ochoa
7f58e1f690
Adds tests for cdb_tablemetadatatouch
...
- fixes tableoid by using the proper table oid
- tests quoted and unqouted call with OID
- tests non existent table to fail
10 years ago