select reports_smeta($proj_id, $addr_id, true) as lo_id

select reports_exploration($proj_id, $addr_id, $dep_id, true) as lo_id

-- Table: reports_cache

-- DROP TABLE reports_cache;

CREATE TABLE reports_cache
(
  id serial NOT NULL,
  created_at timestamp without time zone DEFAULT now(),
  report_name report_name_domain NOT NULL,
  data_hash data_hash_domain NOT NULL,
  lo_id oid NOT NULL,
  texlog text,
  str_key character varying( 512 ),
  CONSTRAINT reports_cache_pkey PRIMARY KEY (id),
  CONSTRAINT reports_cache_lo_id_key UNIQUE (lo_id),
  CONSTRAINT reports_cache_report_name_key UNIQUE (report_name, data_hash)
) 
WITHOUT OIDS;

-- Index: reports_cache_str_key_indx

-- DROP INDEX reports_cache_str_key_indx;

CREATE INDEX reports_cache_str_key_indx
  ON reports_cache
  USING btree
  (str_key);

-- Trigger: del_reports_cache_lo on reports_cache

-- DROP TRIGGER del_reports_cache_lo ON reports_cache;

CREATE TRIGGER del_reports_cache_lo
  BEFORE DELETE
  ON reports_cache
  FOR EACH ROW
  EXECUTE PROCEDURE reports_cache_clean_lo();

 id |         created_at         | report_name |            data_hash             | lo_id | texlog |          str_key        
----+----------------------------+-------------+----------------------------------+-------+--------+---------------------------
  71  |  2006 - 12 - 26   16 : 48 : 57 . 827837  | smeta       | 284a7ea1c84db43f1093e5d248b12340 |  27302  | <NULL> | proj_id:  45  addr_id: NULL