Zeugswetter Andreas IZ5 wrote:
> >>> Another question is whether a SERIAL field should automatically
> >>> UNIQUE (ie, create a unique index on it to prevent mistakes in
> >>> 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.
In response to
pgsql-hackers by date
|Next:||From: Peter T Mount||Date: 1998-11-30 12:55:12|
|Subject: Re: [HACKERS] How to build Distributed Databases with JDBC and
|Previous:||From: Zeugswetter Andreas IZ5||Date: 1998-11-30 10:08:28|
|Subject: Re: [HACKERS] DROPping tables with SERIALs |