>>> 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.
pgsql-hackers by date
|Next:||From: Vadim Mikheev||Date: 1998-11-30 10:31:10|
|Subject: Re: [HACKERS] DROPping tables with SERIALs|
|Previous:||From: Akmal Hasan||Date: 1998-11-30 09:27:08|
|Subject: How to build Distributed Databases with JDBC and PostgreSQL?|