cockroachdb / cockroachdb/cockroach
sql: support user defined function in pg_temp schema
Open
C-enhancement
T-sql-foundations
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
**Is your feature request related to a problem? Please describe.**
In postgres, you can create temporary functions by creating a function with a name prefixed by `pg_temp` schema name. Currently, this is disallowed in cockroach DB. To enable that we'd need to expand the synthetic descriptor to be able to cache it or actually materialize temp schemas.
Jira issue: CRDB-28669
Epic CRDB-17128
Contributor guide
Assessment
This issue has not been assessed yet.