sql: store dependencies in pg_depend

[jayshrivastava]

We do not track dependencies in the table pg_catalog.pd_depend. Instead we use crdb_internal.forward_dependencies.

create table foo(i int);
CREATE TABLE

create view bar as select i from foo;
CREATE VIEW

select * from crdb_internal.forward_dependencies;
  descriptor_id | descriptor_name | index_id | dependedonby_id | dependedonby_type | dependedonby_index_id | dependedonby_name | dependedonby_details
----------------+-----------------+----------+-----------------+-------------------+-----------------------+-------------------+-----------------------
            461 | foo             |     NULL |             462 | view              |                     0 | NULL              | Columns: [1]
(2 rows)

root@localhost:26257/defaultdb> select * from pg_catalog.pg_depend;
  classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
----------+-------+----------+------------+----------+-------------+----------
(0 rows)

Describe the solution you'd like
For postgres compatibility, we should populate pg_depends.

[blathers-crl]

Hi @jayshrivastava, please add a C-ategory label to your issue. Check out the label system docs.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}