| Subject: | GraphViz producer fails on tables named 'node' |
| Date: | Fri, 18 Aug 2006 11:50:05 -0500 |
| To: | bug-SQL-Translator [...] rt.cpan.org |
| From: | Ted Carnahan <tcarnahan [...] ideaworks.com> |
CREATE TABLE node (
id int(10),
type_id int(10),
knowledgebase_id int(10)
);
Doesn't make graphviz, gives an error when creating a foreign key link
from this node to somewhere else. Turns out that it won't create any
such node because node is a Graphviz dot format reserved word. Needs to
be escaped, methinks (along with all of the other reserved words).
--
Ted Carnahan
Idea Works, Inc.
100 West Briarwood
Columbia, Missouri 65203 USA
P: (573) 445-4554
F: (573) 446-2199
tcarnahan@ideaworks.com
www.ideaworks.com