When casting, apparently Cockroachdb doesn't (yet) support pg_catalog.regclass although regclass works fine. It would help if CockroachDB could (eventually) support this, to avoid namespace clashes.
In Postgres
postgres2=> select 'a'::regclass::OID;
oid
----------
20041642
(1 row)
postgres2=> select 'a'::pg_catalog.regclass::OID;
oid
----------
20041642
(1 row)
In CockroachDB
bank=> \d a
Table "bank.a"
Column | Type | Collation | Nullable | Default
--------+--------+-------------------+----------+---------
b | bigint | Not Supported Yet | |
Indexes:
"primary" PRIMARY KEY, (Not Supported Yet)
bank=> select 'a'::regclass::OID;
'a'::REGCLASS::OID
--------------------
818765073
(1 row)
bank=> select 'a'::pg_catalog.regclass::OID;
ERROR: syntax error at or near "pg_catalog"
select 'a'::pg_catalog.regclass::OID;
^
Downstream issue robins/postgres#23 is dependent on this to be fixed.
When casting, apparently Cockroachdb doesn't (yet) support pg_catalog.regclass although regclass works fine. It would help if CockroachDB could (eventually) support this, to avoid namespace clashes.
In Postgres
In CockroachDB
Downstream issue robins/postgres#23 is dependent on this to be fixed.