Skip to content

2.27.0.0-b276

2.27.0.0-b276: [#9979] YSQL: Remove beta label for Foreign Data Wrappers
@karthik-ramanathan-3006 karthik-ramanathan-3006 tagged this 27 Jun 13:18 
Summary:
This revision removes the beta warning for the following commands associated with Foreign Data Wrappers:

- Foreign Data Wrapper
  - `CREATE FOREIGN DATA WRAPPER`
  - `ALTER FOREIGN DATA WRAPPER`

- Foreign Server
  - `CREATE SERVER`
  - `ALTER SERVER`

- Foreign Table
  - `CREATE FOREIGN TABLE`

- User Mapping
  - `CREATE USER MAPPING`
  - `ALTER USER MAPPING`
  - `DROP USER MAPPING`

**Notes**
 - `DROP FOREIGN DATA WRAPPER`, `DROP SERVER`, `DROP FOREIGN TABLE` are all already whitelisted commands under DropStmt.
 - `ALTER FOREIGN TABLE` is also already whitelisted under AlterTableStmt, AlterObjectSchemaStmt, RenameStmt.

This revision whitelists the SQL commands related to FDW, not the data wrappers themselves.
Currently, postgres_fdw and file_fdw are data wrappers that are supported by YugabyteDB.

Output:
```
yugabyte=# CREATE FOREIGN DATA WRAPPER postgres_fdw2
  HANDLER postgres_fdw_handler
  VALIDATOR postgres_fdw_validator;
CREATE FOREIGN DATA WRAPPER

yugabyte=# ALTER FOREIGN DATA WRAPPER postgres_fdw2 RENAME TO postgres_fdw3;
ALTER FOREIGN DATA WRAPPER

yugabyte=# DROP FOREIGN DATA WRAPPER postgres_fdw3;
DROP FOREIGN DATA WRAPPER
```
Jira: DB-1452

Test Plan: Run Jenkins

Reviewers: fizaa, smishra

Reviewed By: fizaa

Subscribers: yql

Tags: #jenkins-ready

Differential Revision: https://phorge.dev.yugabyte.com/D45062
Assets 2
Loading