| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter T Mount | 1998-11-30 12:55:12 | Re: [HACKERS] How to build Distributed Databases with JDBC and PostgreSQL? |
| Previous Message | Zeugswetter Andreas IZ5 | 1998-11-30 10:08:28 | Re: [HACKERS] DROPping tables with SERIALs |