>>> Another question is whether a SERIAL field should automatically
be
>>> UNIQUE (ie, create a unique index on it to prevent mistakes in
manual
>>> insertion of values for the field).
>
>> Once again - I would like to see SERIAL compatible with
>> SERIAL/IDENTY in other RDBMSes.
>
>Yes, and? What do the other ones do?
In Informix you need to create the unique index explicitly. I like this
because it keeps
things flexible. The unique constraint could be on a compount key.
Andreas