It is a SQL constraint that primary keys may not contain NULL values.
alex
[EMAIL PROTECTED] wrote:
>
> I don't know how this is in other DBMS, but e. g. Sybase SQL Anywhere 7, which we
>use, does not allow a part of a primary key to be NULL. Does anybody have a link to
>the spec, so we could check?
>
> -------- Original Message --------
> Subject: Re: Jonas & Oracle (21-Aug-2001 10:05)
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
> > Hi,
> >
> > Indeed, there is a problem when a primary key field has a 'null' value.
> > But I'm not sure that a field, which is a part of the primary key,
> > may logically have a 'null' value.
> >
> > Kind regards.
> > H�l�ne.
> > --
> > -=- H�l�ne JOANIN -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > mailto:[EMAIL PROTECTED] http://www.evidian.com
> > Phone: 33.4.76.29.73.53 Fax: 33.4.76.29.76.00
> > Download our EJB Server JOnAS at http://www.objectweb.org
> > ----
> > To unsubscribe, send email to [EMAIL PROTECTED] and
> > include in the body of the message "unsubscribe jonas-users".
> > For general help, send email to [EMAIL PROTECTED] and
> > include in the body of the message "help".
> >
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
>
> To: [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
>
> ----
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body of the message "unsubscribe jonas-users".
> For general help, send email to [EMAIL PROTECTED] and
> include in the body of the message "help".
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
