On Dec 17, 2010, at 10:34 AM, Melvin Davidson wrote:
> >please don't name your constraint using the same name you named your
> >table.
>
> I can't believe I missed the obvious, but that's why it's better to have someone else
> take a look.
> Thanks for spotting that. I've tacked on _pk to the constraint. Fixed!
FWIW, I find it useful to provide some kind of indication of what fields are in the index in the index name, ie:
xtmp_changed_ids__pk_seq_all.
--
Jim C. Nasby, Database Architect jim@nasby.net
512.569.9461 (cell) http://jim.nasby.net