|Subject||RE: [IB-Architect] Primary key not set to unique|
|Author||Claudio Valderrama C.|
> -----Original Message-----Andrew, this is not a support list, please. You know already where to post.
> From: csswa [mailto:csswa@...]
> Sent: Jueves 31 de Enero de 2002 21:43
> I was surprised to discover that a primary key created from a domain
> was not created automatically as unique.
Download the beta documentation for IB6 or purchase the media kit of IB6.5
that includes the supposedly amended documentation.
A primary key is unique and doesn't accept null values. Furthermore, the
engine creates behind scenes a unique index to support it.
What you observed is a result of some corruption that happened in your db
before you defined the PK, hence when you created it, it didn't work as
expected. The db was already spoiled in some way.
No more to say here since this is not the correct forum for support
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://www.cvalde.com - http://www.firebirdSQL.org