Changes for PostgreSQL compatibility #2256
Description
- PR: sql: add alias timezone for time zone session var cockroach#19931
- The
time zonesession variable (with a space) has been renamedtimezone(without a space), andSET TIMEZONEandSHOW TIMEZONEare now supported alongside the existingSET TIME ZONEandSHOW TIME ZONEsyntax. Also,SET TIMEZONE =can now be used as an alternative toSET TIMEZONE TO.
- The
- PR: sql: transaction_read_only should return off cockroach#19971
- The
transaction_read_onlysession variable is now supported. It is always set tooff.
- The
- PR: sql: name the transaction settings like PG does cockroach#20264
- The
transaction isolation level,transaction priority, andtransaction statussession variables have been renamedtransaction_isolation,transaction_priority, andtransaction_status.
- The