Tables related by key constraint must both be permanent or both be temporary created with ON COMMIT PRESERVE ROWS

Probable cause 

Tables involved in a key constraint relationship must both be permanent user tables or both be temporary tables created with ON COMMIT PRESERVE ROWS. Change the definition of one or both tables using ALTER TABLE.