Re: How to enforce the use of the sequence for serial columns ?

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <jerry(at)jerrysievers(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to enforce the use of the sequence for serial columns ?
Date: 2006-12-14 07:58:29
Message-ID: CA896D7906BF224F8A6D74A1B7E54AB3198760@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>Trigger based solution where same trig can be used for any number of
tables by changing the parameter.

>Will throw one of 2 exceptions on failure to use sequence for the
insert.

Many thanks,
This seems to be the simplest solution,

Marc

Browse pgsql-admin by date

  From Date Subject
Next Message Eduardo J. Ortega 2006-12-14 10:28:18 Re: Backup
Previous Message Rajesh Kumar Mallah 2006-12-14 02:24:03 Re: Should duplicate indexes on same column and same table be allowed?