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


Mon, 30 Nov 1998 11:08:28 +0100
Zeugswetter Andreas IZ5 <Andreas.Zeugswetter@telecom.at>
Re: [HACKERS] DROPping tables with SERIALs 
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

Mon, 30 Nov 1998 17:31:10 +0700
Vadim Mikheev <vadim@krs.ru>
Re: [HACKERS] DROPping tables with SERIALs