At 11:08 PM 21/10/2003 -0700, you wrote:

> >Assuming you have a generator + trigger supplying the PK value, col1:
> >
> >insert into enrollments (col2, col3, ...., classid, ....)
> >select col2, col3, ...., 456, ....
> >from enrollments
> >where classid <> 456
>
>No, I don't have a generator/trigger generating the PK.

You must be getting it from somewhere...if it's a composite of something,
then you aren't going to get unique keys by dup'ing rows back into the same
table, are you?