Got syntax error when creating an function

[hallee9000]

Hi there, I just got an syntax error when creating a function in the dashboard. Here is the screenshot.

Here is my code:

  plv8.execute(
    `
      UPDATE design_files SET current_version = current_version + 1 WHERE id IN (
        SELECT design_file
        FROM file_versions
        WHERE id = $1
      )
    `,
    [version_id]
  );

[soedirgo]

Can you try changing your multiline string syntax? https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS

[w3b6x9]

@leadream we actually don't support plv8 in the dashboard at the moment. Please try either sql or plpgsql.

[hallee9000]

Thank you. @soedirgo @w3b6x9
I'll try to create function in the SQL editor.