PostgreSQL to remote database fails #14
Description
Trying to run benchmarks on a remote PostgreSQL DB 9.5 (Ubuntu 16.04) fails and wants to send an online report.
The error log in the server log says:
2017-05-18 16:08:06 CEST [40173-11] postgres@postgres ERROR: syntax error at or near "COMIT" at character 702
2017-05-18 16:08:06 CEST [40173-12] postgres@postgres STATEMENT: CREATE OR REPLACE FUNCTION InsertToTable1(_id bigint, _symbol text, _time timestamp without time zone, _bid double precision, _ask double precision, _bidsize int, _asksize int, _provider text ) RETURNS int LANGUAGE plpgsql AS $$
DECLARE
rowCount RECORD;
BEGIN
IF exists(select * from fanuc where id=_id) THEN
UPDATE fanuc SET symbol =_symbol, time = _time, bid = _bid, ask = _ask, bidsize = _bidsize, asksize =_asksize, provider = _provider WHERE ID = _id;
ELSE
INSERT INTO fanuc VALUES(_id,_symbol,_time,_bid, _ask, _bidsize, _asksize, _provider);
END IF;
COMIT;
RETURN 0;
END
$$;
2017-05-18 16:08:06 CEST [40173-13] postgres@postgres ERROR: function inserttotable1(bigint, text, timestamp without time zone, double precision, double precision, integer, integer, text) does not exist at character 8
2017-05-18 16:08:06 CEST [40173-14] postgres@postgres HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2017-05-18 16:08:06 CEST [40173-15] postgres@postgres STATEMENT: SELECT InsertToTable1(CAST(2476635885972918365 as bigint),
CAST('CHFBGN' as text),
CAST('18.05.2017 16:05:41' as timestamp without time zone),
CAST('1.5857' as double precision),
CAST('1.5863' as double precision),
CAST(2993 as int),
CAST(2034 as int),
CAST('NASDAQ' as text));