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]

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.