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: 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 creation
scripts. 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 check
then. Who's right? Can I report this as a bug?

(InstantDB version: 3.25, SQL Server version: 7.0)

Johan Stuyts
begin:vcard 
n:Stuyts;Johan
tel;work:+31 (0)20 320 89 55
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:j.stuyts@n200.com
fn:Johan Stuyts
end:vcard