>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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster