Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: foreign keys


Brett

FK support will be added in 3.20 beta 2 (available soon). Prior to that
release, it's just best not to include an FK clauses. The CONSTRAINT syntax
won't be supported at first however, only the REFERENCES syntax.

Regards

Peter Hearty
Lutris Technologies (UK)
----- Original Message -----
From: "Brett McLaughlin" <brett.mclaughlin@lutris.com>
To: <instantdb@enhydra.org>
Sent: Tuesday, August 22, 2000 2:52 AM
Subject: InstantDB: foreign keys


> Looking at the docs page, it looks like foreign keys are ignored - in
> other words, there is no referential integrity in InstantDB. Is this
> still true? In either case, what particular CREATE statement is
> supported for the FOREIGN KEY or REFERENCES construct? I'm an old Oracle
> guy, and syntax accepted there appears to be bombing on InstantDB. In
> particular, the
>
> CREATE TABLE foo (
>   colName INT,
>   CONSTRAINT colName ...
> );
>
> style syntax (which I thought was ANSI-92 compliant) doesn't get
> accepted. Anyone want to post a simple foreign key example that works on
> InstantDB? Much appreciated. It might be nice to have one of these in
> the examples (sql1.txt, sql2.txt, etc.) as well - that's how I figured
> out that InstantDB likes
>
> CREATE TABLE foo (
>   colName INT PRIMARY KEY NOT NULL
> );
>
> for example, as opposed to
>
> CREATE TABLE foo (
>   colName INT NOT NULL,
>   CONSTRAINT foo$pk PRIMARY KEY (colName)
> );
>
> Thanks,
> Brett
>
> --
> Brett McLaughlin, Enhydra Strategist
> Lutris Technologies, Inc.
> 1200 Pacific Avenue, Suite 300
> Santa Cruz, CA 95060 USA
> http://www.lutris.com
> http://www.enhydra.org
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.