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