Thus spake Hannu Krosing
> "D'Arcy J.M. Cain" wrote:
> > Any chance of getting the FK semantics into the parser right away even
> > though it is ignored?
>
> We do have foreign key syntax in parser
>
> hannu=> create table foreign_tab(
> hannu-> f int,
> hannu-> foreign key(f) references primary_tab (i)
> hannu-> );
> NOTICE: CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented
>
> What do you mean by semantics here ?
> Should it check that the primary table and field(s) exist ?
Nope. That's exactly what I meant. I didn't realize that it was already
there. Sorry for the confusion.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.