test.sql

## works

  create schema core;

  create table core.items (
    id serial primary key
  );

  create table core.other (
    id serial primary key,
    item_id int not null references core.items on delete restrict
  );

  create view api.core_other as
    select * from core.other;

  create view api.core_items as
    select * from core.items;
    
    
## does not work


 create table items (
    id serial primary key
  );

  create table other (
    id serial primary key,
    item_id int not null references items on delete restrict
  );

  create view api.other as
    select * from other;

  create view api.items as
    select * from items;