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
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
participants (2)
-
Caroptions Caroptions -
Niels Nes