CREATE TABLE data
(
  meta_data character varying,
  s_ep_mkd character varying,
  id bigserial NOT NULL
)

CREATE TABLE meta_data
(
  year integer NOT NULL,
  month integer NOT NULL,
  inn character varying NOT NULL,
  kpp character varying,
  ogrn character varying,
  adr_code character varying NOT NULL,
  doc_type integer NOT NULL,
  vers_form character varying NOT NULL,
  id bigserial NOT NULL

ALTER TABLE data ADD CONSTRAINT external_key FOREIGN KEY (id) REFERENCES meta_data (id)
   ON UPDATE NO ACTION ON DELETE NO ACTION;
CREATE INDEX fki_external_key ON data(id);

ОШИБКА:  в целевой внешней таблице "meta_data" нет ограничения уникальности, соответствующего данным ключам

-- Table: data

-- DROP TABLE data;

CREATE TABLE data
(
  meta_data character varying,
  s_ep_mkd character varying,
  id bigserial NOT NULL,
  CONSTRAINT external_key_one FOREIGN KEY (id)
      REFERENCES meta_data (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE data
  OWNER TO patya;

-- Index: fki_external_key_one

-- DROP INDEX fki_external_key_one;

CREATE INDEX fki_external_key_one
  ON data
  USING btree
  (id );

-- Index: index_test

-- DROP INDEX index_test;

CREATE UNIQUE INDEX index_test
  ON data
  USING btree
  (meta_data COLLATE pg_catalog."default" , s_ep_mkd COLLATE pg_catalog."default" , id );