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: Primary keys on a single column do not enforceuniqueness


Johan

In this case, SQL Server is the compliant database. IDB does this so as 
to be able to import data from databases which do not enforce PK 
uniqueness.

Pete

----- Original Message -----
From: Johan Stuyts <j.stuyts@n200.com>
Date: Wednesday, December 20, 2000 10:09 am
Subject: InstantDB: Primary keys on a single column do not enforce 
uniqueness

> Hi,
> 
> I'm using InstantDB as a development database and SQL Server as a
> deployment database. I want to create SQL-92 compliant database 
> creationscripts. I need all my single-column primary keys (the 
> usual IDs) to be
> unique. According to the SQL spec specifiying either 'PRIMARY KEY' or
> 'UNIQUE' enforces a uniqueness check on the column. SQL Server 
> does not
> accept a 'CREATE TABLE' statement in which I provide both 'PRIMARY 
> KEY'and 'UNIQUE'. InstantDB however does no uniqueness check if I only
> specify 'PRIMARY KEY'. It also allows me to specify both 'PRIMARY KEY'
> and 'UNIQUE' and when I do it ofcourse does perform the uniqueness 
> checkthen. Who's right? Can I report this as a bug?
> 
> (InstantDB version: 3.25, SQL Server version: 7.0)
> 
> Johan Stuyts
> 

-----------------------------------------------------------------------------
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.