ERROR: Temporary table for ... not found

Reason:

You attempted to use the copy_rows() function without there being a temporary table

Resolution:

If you are using copy_rows() without the loader then ensure that the new rows are placed into a temporary table with the same name as the target table prior to calling copy_rows().

You can use the following command to create a temporary table:

CREATE TEMPORARY TABLE <table> (LIKE <table>);

Where <table> is the name of the target table.

Tips:

• Did you create a temporary table to hold the new rows?
• Are you calling copy_rows() from the same session that created the temporary table?
• See copy_rows() for further information.