2016-03-30 16:50:16 MSK 6212 6969967ERROR:  deadlock detected
2016-03-30 16:50:16 MSK 6212 6969967DETAIL:
        Process 6212 waits for ShareUpdateExclusiveLock on relation 12530961 of database 10065830; blocked by process 8476.
	Process 8476 waits for AccessExclusiveLock on relation 10067977 of database 10065830; blocked by process 6212.

DECLARE

    m_tablename TEXT;
    m_startdate TEXT;
    m_enddate TEXT;

BEGIN
  	m_startdate := to_char ( CURRENT_DATE, 'YYYY_MM_DD' );
  	m_tablename := substring ( TG_TABLE_NAME from 6 ) || '_' || m_startdate;
 
    PERFORM 1
        FROM   pg_catalog.pg_class c
        JOIN   pg_catalog.pg_namespace n ON n.oid = c.relnamespace AND n.nspname = 'oi'
        WHERE  c.relkind = 'r'
        AND    c.relname = m_tablename;
 
  	IF NOT FOUND THEN
          m_enddate := m_startdate::TIMESTAMP WITH TIME ZONE + INTERVAL '1 day';
          BEGIN 
              EXECUTE 'CREATE UNLOGGED TABLE oi.' || m_tablename || ' (
                  CHECK (( date_save_db_begin >= ' || quote_literal ( m_startdate ) || '::TIMESTAMP WITH TIME ZONE)
                     AND ( date_save_db_begin < ' || quote_literal ( m_enddate ) || '::TIMESTAMP WITH TIME ZONE))
                ) INHERITS (oi.' || TG_TABLE_NAME || ');';

              EXECUTE 'ALTER TABLE oi.' || m_tablename || ' OWNER TO "spoarchive";
              			GRANT SELECT, INSERT ON TABLE oi.' || m_tablename || ' TO "users";';

              
                CASE 

                    WHEN substring ( TG_TABLE_NAME from 'crm' ) = 'crm' THEN
                    	EXECUTE ' CREATE INDEX ' || m_tablename || '_idx ON oi.' || m_tablename || ' USING btree (id);
                                ALTER TABLE oi.' || m_tablename || ' ADD CONSTRAINT ' || m_tablename || '_pkey PRIMARY KEY(id);
                                ALTER TABLE oi.' || m_tablename || ' ADD CONSTRAINT ' || m_tablename || '_fkey 
                            FOREIGN KEY (id) REFERENCES cls(id)
                                ON DELETE NO ACTION
                                ON UPDATE NO ACTION
                                NOT DEFERRABLE';

                    ELSE
                        NULL;
                END CASE;
            EXCEPTION
                WHEN duplicate_table THEN
                	NULL;
            END;
	END IF;
 
	EXECUTE 'INSERT INTO oi.' || m_tablename || ' VALUES ($1.*)' USING NEW;

	
	RETURN NULL;
END;

CREATE OR REPLACE FUNCTION oi.tr (
)
RETURNS trigger AS
$body$
***
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY DEFINER
COST 100;