0x777

-- From 24 to 23
ALTER TABLE hdb_catalog.hdb_table DROP COLUMN configuration;

DROP VIEW IF EXISTS hdb_catalog.hdb_table_info_agg;
DROP VIEW IF EXISTS hdb_catalog.hdb_column;

CREATE VIEW hdb_catalog.hdb_column AS
     WITH primary_key_references AS (
            SELECT fkey.table_schema           AS src_table_schema
                 , fkey.table_name             AS src_table_name

0x777

ALTER TABLE hdb_catalog.hdb_table DROP COLUMN is_enum;

CREATE FUNCTION hdb_catalog.hdb_table_oid_check() RETURNS trigger AS
  $function$
BEGIN
  IF (EXISTS (SELECT 1 FROM information_schema.tables st WHERE st.table_schema = NEW.table_schema AND st.table_name = NEW.table_name)) THEN
    return NEW;
  ELSE
    RAISE foreign_key_violation using message = 'table_schema, table_name not in information_schema.tables';
    return NULL;

0x777

create or replace function add_on_update_trigger
       (schema_name text, table_name text, column_name text)
       returns void AS $body$
declare
  target_table text =
    quote_ident(schema_name) || '.' || quote_ident(table_name);
  trig_name text =
    quote_ident(
      'update_' || schema_name || '_' || table_name || '_' || column_name
    );

0x777

Keybase proof

I hereby claim:

• I am 0x777 on github.
• I am 0x777 (https://keybase.io/0x777) on keybase.
• I have a public key ASA2k6XN80WgTp3G1eaX-X4ZGxEZ1N4WkCgGwa8pkS7E8wo

To claim this, I am signing this object: