cockroachdb / cockroachdb/cockroach

Support `pg_identify_object` function in Cockroach DB

Open
#117,126 0 comments 0 reactions 0 assignees View on GitHub
A-sql-builtins A-sql-pgcompat 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.**

We are getting the following error when trying to use Flyway to do a migration.

```
ERROR: org.flywaydb.compare.rg.exception.FlywayRGCompareException: org.flywaydb.compare.rg.exception.RGCompareException: 42883: unknown function: pg_identify_object(): function undefined
```
It seems like `pg_identify_object` is not implemented in Cockroach DB. This function is important to us since it seems to be used inside Flyway Enterprise Edition 10.4.1 and we use Flyway for our schema migrations.

**Describe the solution you'd like**
Implement `pg_identify_object` function in Cockroach DB. https://www.postgresql.org/docs/16/functions-info.html

**Describe alternatives you've considered**
NA

**Additional context**
NA

Jira issue: CRDB-34994

Epic CRDB-60810

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.