Strange syntax error when create trigger
Hi User-List, I am experiencing very strange behavior: CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON marketdata.quotes FOR EACH ROW BEGIN ATOMIC -- select * from marketdata.quotes limit 1; END; ERROR: syntax error, unexpected '.', expecting WHILE in: "create trigger marketdata.calc_sdate before insert on marketdata." When I am creating trigger on table without schema it works fine. CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON t1 ... Assuming t1 created without schema. All combination of " around schema and table, schema only, table only didn't help. Am I doing something wrong or this is the bug? Thanks,John
On Fri, Apr 17, 2015 at 10:35:45PM +0000, Caroptions Caroptions wrote:
Hi User-List,
I am experiencing very strange behavior:
CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON marketdata.quotes FOR EACH ROW BEGIN ATOMIC -- select * from marketdata.quotes limit 1; END;
ERROR: syntax error, unexpected '.', expecting WHILE in: "create trigger marketdata.calc_sdate before insert on marketdata."
When I am creating trigger on table without schema it works fine. CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON t1 ...
Assuming t1 created without schema.
All combination of " around schema and table, schema only, table only didn't help.
Am I doing something wrong or this is the bug? Indeed a bug, we should allow for a fully qualified name (ie including schema name).
Niels
Thanks, John
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl
Bug Report: https://www.monetdb.org/bugzilla/show_bug.cgi?id=3710 Thanks,JohnDate: Tue, 21 Apr 2015 08:10:41 +0200 From: Niels.Nes@cwi.nl To: users-list@monetdb.org Subject: Re: Strange syntax error when create trigger On Fri, Apr 17, 2015 at 10:35:45PM +0000, Caroptions Caroptions wrote:
Hi User-List,
I am experiencing very strange behavior:
CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON marketdata.quotes FOR EACH ROW BEGIN ATOMIC -- select * from marketdata.quotes limit 1; END;
ERROR: syntax error, unexpected '.', expecting WHILE in: "create trigger marketdata.calc_sdate before insert on marketdata."
When I am creating trigger on table without schema it works fine. CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON t1 ...
Assuming t1 created without schema.
All combination of " around schema and table, schema only, table only didn't help.
Am I doing something wrong or this is the bug? Indeed a bug, we should allow for a fully qualified name (ie including schema name).
Niels
Thanks, John
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Caroptions Caroptions -
Niels Nes