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

Support SET SESSION AUTHORIZATION DEFAULT #39821

Closed
mattcrdb opened this issue Aug 22, 2019 · 0 comments · Fixed by #40194

Comments

@mattcrdb
Copy link

commented Aug 22, 2019

The statement is issued implicitly from npgsql driver and is accepted by postgres.

Currently, it throws a syntax error 42601: syntax error at or near “default”.

Related to this forum post: https://forum.cockroachlabs.com/t/set-session-authorization-default-causes-syntax-error/3028

Postgres documentation here: https://www.postgresql.org/docs/10/sql-set-session-authorization.html

In our case, it would be a no-op so we should just be able to accept this.

cc @knz

craig bot pushed a commit that referenced this issue Aug 28, 2019
Merge #40194
40194: sql: a few compatibility features r=jordanlewis a=jordanlewis

- add pg_my_temp_schema() builtin
- add array overlaps (&&) operator
- add array contains (@>) and contained_by(<@) operators
- add support for SET SESSION AUTHORIZATION DEFAULT
- add pg_get_function_identity_arguments builtiin

Closes #18442.
Closes #33337.
Closes #39821.
Closes #40211.

Co-authored-by: Jordan Lewis <jordanthelewis@gmail.com>

@craig craig bot closed this in 1606c9d Aug 28, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
1 participant
You can’t perform that action at this time.