Zeugswetter Andreas IZ5 wrote:
>
> >>> 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.
Agreed.
Vadim