Syntax error at or near $1

syntax error at or near $1

ERROR: syntax error at or near "$1" This error below appears every once in a while in the idempiere logs. I have attached a result of the query. 13. The following query: Ecto.Adapters.SQL.query(Wsmig.Repo, "ALTER SEQUENCE public.customers_id_seq RESTART WITH $1",[1502]) fails with the. · "ERROR: there is no parameter $1" in "EXECUTE.. USING..;" statement in plpgsql · SQL injection in Postgres functions vs prepared. syntax error at or near $1

Syntax error at or near $1 - for

''\r'';
END LOOP;
RETURN devices;
END;
' LANGUAGE 'plpgsql';

------------
Ryan J. Booz
Research Programmer
Penn State University
Information Technology Services
TLT/CLC
rxb19(at)psu(dot)edu

In response to

Responses

Browse pgsql-general by date