By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601536 fiddles created (47956 in the last week).
CREATE TABLE tablefindold
(
hostname character varying(16) not null primary key,
lastmiss timestamp without time zone,
lastfind timestamp without time zone,
uname character varying(64)
);
✓
hidden batch(es)
INSERT INTO tableFindOld(hostname, lastMiss, lastFind, uname)
VALUES('pcname', DEFAULT, '2019-03-04 11:38:04', 'billy')
ON CONFLICT (tablefindold.hostname)
DO UPDATE SET lastFind='2019-03-04 11:38:04', uname='billy'
WHERE tableFindOld.hostname='pcname';
ERROR: syntax error at or near ")"
LINE 3: ON CONFLICT (tablefindold.hostname)
^
hidden batch(es)
INSERT INTO tableFindOld(hostname, lastMiss, lastFind, uname)
VALUES('pcname', DEFAULT, '2019-03-04 11:38:04', 'billy')
ON CONFLICT (hostname)
DO UPDATE SET lastFind='2019-03-04 11:38:04', uname='billy'
WHERE tableFindOld.hostname='pcname';
