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.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk