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.

Sign up for GitHub

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

Jump to bottom

[YSQL] Feature Support - EXTENSION #1154

Closed
nocaway opened this issue Apr 5, 2019 · 4 comments
Closed

[YSQL] Feature Support - EXTENSION #1154

nocaway opened this issue Apr 5, 2019 · 4 comments
Assignees
@m-iancu
Labels
area/ysql Yugabyte SQL (YSQL) integration/graphql/hasura Features related to running Hasura GraphQL on YugabyteDB kind/enhancement This is an enhancement of an existing feature
Projects
YSQL

Comments

@nocaway
Copy link
Contributor

nocaway commented Apr 5, 2019

Extension is not yet supported.
@nocaway nocaway added kind/enhancement This is an enhancement of an existing feature area/ysql Yugabyte SQL (YSQL) labels Apr 5, 2019
@nocaway nocaway added this to To do in YSQL via automation Apr 5, 2019
@nocaway nocaway self-assigned this Apr 5, 2019
@Negashev
Copy link

Negashev commented May 14, 2019 •
edited

+1

@m-iancu m-iancu added the integration/graphql/hasura Features related to running Hasura GraphQL on YugabyteDB label Jun 13, 2019
@m-iancu m-iancu self-assigned this Jun 13, 2019
@m-iancu m-iancu moved this from To do to In progress in YSQL Jun 13, 2019
@dodilp
Copy link

dodilp commented Jul 13, 2019 •
edited

This is needed for the AdventureWorks dataset

-- Support to auto-generate UUIDs (aka GUIDs)
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

CREATE EXTENSION tablefunc;

m-iancu added a commit that referenced this issue Jul 22, 2019
@m-iancu
[YSQL] #1154 #1156 Support for Triggers and Extensions
9f4c158 
Summary:
Support triggers and extensions as beta features.
Current limitations (to be addressed in followup commits):
 - for triggers, transition tables (i.e. REFERENCES clause) and
   constraint (deferrable) triggers are not yet supported.
 - extensions are supported in general but specific extensions may
    require additional features that are not yet supported (e.g. `CREATE TYPE`)

Test Plan:
Added the following tests to the TestPgRegressBetaFeatures suite:
- yb_pg_create_function_1
- yb_pg_create_function_2
- yb_pg_triggers
- yb_triggers
- yb_extensions

Reviewers: neil, mikhail, dmitry, neha

Reviewed By: neha

Subscribers: neha, kannan, yql

Differential Revision: https://phabricator.dev.yugabyte.com/D6843
@m-iancu m-iancu mentioned this issue Jul 22, 2019
Closed
@m-iancu
Copy link
Contributor

m-iancu commented Jul 22, 2019

General issue fixed in 9f4c158. Specific extensions will be tracked in separate issues.
Currently opened #1867 to track uuid-ossp support. Note that pgcrypto is already supported and it has support for generating UUIDs (e.g. gen_random_uuid()). cc @dodilp

@m-iancu m-iancu closed this as completed Jul 22, 2019
YSQL automation moved this from In progress to Done Jul 22, 2019
@frozenspider frozenspider mentioned this issue Feb 12, 2020
Open
@shaunstoltz
Copy link

This is resolved by pr #9576

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@m-iancu m-iancu

Labels
area/ysql Yugabyte SQL (YSQL) integration/graphql/hasura Features related to running Hasura GraphQL on YugabyteDB kind/enhancement This is an enhancement of an existing feature
Projects
YSQL
  
Done
Milestone
No milestone
Development

No branches or pull requests
6 participants
@mbautin @shaunstoltz @dodilp @m-iancu @Negashev @nocaway