You attempted to use the copy_rows() function without there being a temporary table
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.
- 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.