Postgres Pro
Downloads
Home   >   mailing lists

Re: How to enforce the use of the sequence for serial columns ? - Mailing list pgsql-admin

From Marc Mamin
Subject Re: How to enforce the use of the sequence for serial columns ?
Date
Msg-id CA896D7906BF224F8A6D74A1B7E54AB3198760@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to How to enforce the use of the sequence for serial columns ?  ("Marc Mamin" <M.Mamin@intershop.de>)
List pgsql-admin
Tree view 

>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

pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: Should duplicate indexes on same column and same table be allowed?
Next
From: "Eduardo J. Ortega"
Date:
Subject: Re: Backup