Subscriptions relatedNode return null about issues HOT 8 CLOSED

    {
      pluginHook,
      simpleSubscriptions: true,
      graphiql: true,
      graphileBuildOptions: {
        pgStrictFunctions: true,
      },
      pgDefaultRole: 'guest',
      dynamicJson: true,
      jwtSecret: JWT_SECRET,
      jwtPgTypeIdentifier: 'tocu_schema.jwt_token',
      exportGqlSchemaPath:
        process.env.NODE_ENV === 'production' ? './schema.graphql' : undefined,
      classicIds: true,
      setofFunctionsContainNulls: false,
    },

CREATE SEQUENCE tocu_schema.person_id_seq;

CREATE TABLE tocu_schema.person (
  id int NOT NULL DEFAULT NEXTVAL('tocu_schema.person_id_seq') PRIMARY KEY,
  name text not null CHECK (char_length(name) < 80),
  username citext UNIQUE CHECK (username is not null and username ~* '^[a-z](?:[a-z\d]|-(?=[a-z\d])|\.(?=[a-z\d])){2,38}$'),
  password text,
  role tocu_schema.role_enum not null default 'customer',
  vip boolean not null default false,
  mobile_phone text UNIQUE check(mobile_phone ~ '^(030|031|032|033|034|035|036|037|038|039|050|051|052|053|054|055|056|057|058|059|070|071|072|073|074|075|076|077|078|079|080|081|082|083|084|085|086|087|088|089|090|091|092|093|094|095|096|097|098|099)\d{7}$'),
  mobile_phone_verified boolean DEFAULT FALSE,
  fb_id text unique check (fb_id ~ '^[0-9\.]+$'),
  fb_username text unique check(fb_username ~ '^[a-z\d.]{5,}$'),
  unread_notifications_count integer not null default 0,
  last_notification_id integer references tocu_schema.notification(id) on delete restrict,
  note text,
  created_by integer references tocu_schema.person(id),
  updated_by integer references tocu_schema.person(id),
  created_at timestamp not null DEFAULT now(),
  updated_at timestamp not null DEFAULT now(),
  search_words tsvector
);

CREATE INDEX person_idx ON tocu_schema.person USING GIN(search_words, updated_at, mobile_phone);

comment on table tocu_schema.district is E'@omit create';

grant select on table tocu_schema.person to boss, manager, sales, support_online, customer, shipper, cashier, warehouse_manager, warehouse_staff, visitor;
grant insert, update on table tocu_schema.person to boss, manager, sales, support_online;
grant usage on sequence tocu_schema.person_id_seq to boss, manager, sales, support_online;

-- Row security
alter table tocu_schema.person enable row level security;
create policy select_me on tocu_schema.person for select to boss, manager, sales, support_online, customer, shipper, cashier, warehouse_manager, warehouse_staff, visitor
  using (id = current_setting('jwt.claims.person_id')::integer);
create policy select_customer on tocu_schema.person for select to boss, manager, sales, support_online
  using (true);

create policy insert_person on tocu_schema.person for insert to boss, manager, sales, support_online
  with check (created_by = current_setting('jwt.claims.person_id')::integer);

create policy update_me on tocu_schema.person for update to boss, manager, sales, support_online, customer, shipper, cashier, warehouse_manager, warehouse_staff, visitor
  using (id = current_setting('jwt.claims.person_id')::integer);
create policy update_customer on tocu_schema.person for update to boss, manager, sales, support_online
  using (true);

create or replace function tocu_schema.notification_added_notify()
  returns trigger as $$
begin
  perform pg_notify(
    'postgraphile:notification_added:' || new.id,
    json_build_object(
      '__node__', json_build_array('people', new.id)
    )::text
  );
  return new;
end;
$$
LANGUAGE plpgsql strict SECURITY DEFINER;

create trigger notification_added_notify_trigger after update of last_notification_id on tocu_schema.person
  for each row EXECUTE PROCEDURE tocu_schema.notification_added_notify();

{
  pluginHook,
  simpleSubscriptions: true,
  graphiql: true,
  graphileBuildOptions: {
    pgStrictFunctions: true,
  },
  // pgDefaultRole: 'guest',
  dynamicJson: true,
  jwtSecret: JWT_SECRET,
  jwtPgTypeIdentifier: 'tocu_schema.jwt_token',
  exportGqlSchemaPath:
    process.env.NODE_ENV === 'production' ? './schema.graphql' : undefined,
  classicIds: true,
  setofFunctionsContainNulls: false,
},