Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] foreign key constraints are not supported on foreign tables #10699

Open
tedyu opened this issue Nov 24, 2021 · 0 comments
Open

[YSQL] foreign key constraints are not supported on foreign tables #10699

tedyu opened this issue Nov 24, 2021 · 0 comments
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue

Comments

@tedyu
Copy link
Contributor

tedyu commented Nov 24, 2021

Jira Link: DB-1033

Description

yugabyte=# CREATE TABLE ref_table (id integer PRIMARY KEY);
CREATE TABLE
yugabyte=# CREATE FOREIGN TABLE ft2 (
yugabyte(#     c1 integer OPTIONS ("param 1" 'val1') REFERENCES ref_table (id),
yugabyte(#     c2 text OPTIONS (param2 'val2', param3 'val3'),
yugabyte(#     c3 date
yugabyte(# ) SERVER s0 OPTIONS (delimiter ',', quote '"', "be quoted" 'value');
WARNING:  'foreign data wrapper' is a beta feature!
LINE 1: CREATE FOREIGN TABLE ft2 (
        ^
HINT:  To suppress this warning, set the 'ysql_beta_feature_foreign data wrapper' yb-tserver gflag to true.
(Set 'ysql_beta_features' yb-tserver gflag to true to suppress the warning for all beta features.)
ERROR:  foreign key constraints are not supported on foreign tables
LINE 2:     c1 integer OPTIONS ("param 1" 'val1') REFERENCES ref_tab...
                                                  ^
@tedyu tedyu added the area/ysql Yugabyte SQL (YSQL) label Nov 24, 2021
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Aug 25, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue
Projects
Status: No status
Development

No branches or pull requests

3 participants