Thank you much! You hit the nail on the head with your observation about the bldcmdid not being a primary key. I verified that an identical operation worked 100% correctly on a table where the primary key was also a serial type.
I needed the combination of a few keys to be unique. I naively used a PRIMARY KEY(cmdname, cmdvers) constraint to enforce uniqueness. After reading your reply, I changed to PRIMARY KEY(buildcmdid) and applied a UNIQUE(cmdname, cmdvers) constraint. Everything is now working like it should. I appreciate your patience with what was obviously a DB-newbie mistake and not an SA problem. Thanks again, Rick --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
