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 notenforceuniqueness


Johan

Well spotted!

Pete

----- Original Message -----
From: Johan Stuyts <j.stuyts@n200.com>
Date: Tuesday, January 2, 2001 3:42 pm
Subject: Re: InstantDB: Primary keys on a single column do not 
enforceuniqueness

> Hi,
> 
> Specifying the uniqueness and primary key constraints as table 
> constraintsinstead of column constraints works in both InstantDB 
> and SQL Server (and is
> SQL-92 compliant).
> 
> Johan
> 
> Peter Hearty wrote:
> 
> > 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.
> 

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