Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] DROPping tables with SERIALs

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] DROPping tables with SERIALs
Date: 1998-11-30 10:31:10
Message-ID: 366273EE.C4007810@krs.ru (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Peter T MountDate: 1998-11-30 12:55:12
Subject: Re: [HACKERS] How to build Distributed Databases with JDBC and PostgreSQL?
Previous:From: Zeugswetter Andreas IZ5Date: 1998-11-30 10:08:28
Subject: Re: [HACKERS] DROPping tables with SERIALs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group