-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: pg_table_is_visible() doesn't work for indexes #88097
Copy link
Copy link
Closed
Labels
A-sql-pgcatalogA-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQLA-sql-vtablesVirtual tables - pg_catalog, information_schema etcVirtual tables - pg_catalog, information_schema etcC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Description
Needed for #88061.
Describe the problem
PostgreSQL and CockroachDB differ on the following:
create table mytable(mycolumn int);
create index myidx on mytable(mycolumn);
select oid, pg_table_is_visible(oid) from pg_class where relname = 'myidx';In PostgreSQL, this returns properly true for the visibility.
In CockroachDB, we get NULL.
cc @rafiss for triage.
Jira issue: CRDB-19683
Epic: CRDB-23454
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-pgcatalogA-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQLA-sql-vtablesVirtual tables - pg_catalog, information_schema etcVirtual tables - pg_catalog, information_schema etcC-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)