Skip to content

sql: pg_table_is_visible() doesn't work for indexes #88097

@knz

Description

@knz

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

Metadata

Metadata

Assignees

Labels

A-sql-pgcatalogA-sql-pgcompatSemantic compatibility with PostgreSQLA-sql-vtablesVirtual tables - pg_catalog, information_schema etcC-bugCode 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)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions