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@xxxxxxxxx 512.569.9461 (cell) http://jim.nasby.net -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
