Re: Can't Update Primary Key in PostgreSQL

2006-06-15 Thread Chuck Hill
Nick, I have exposed primary keys with Postgres and not had this exception. I don't think that is the (or the only) cause. Carefully check the definitions of this PK and all the FK relations to it to ensure they are identical (same internal type, same external type, same value type etc.

Re: Can't Update Primary Key in PostgreSQL

2006-06-15 Thread Gary Teter
Turn off the class property on the pk for the entity, and use a method like this to get the pk: public static Integer id(EOEnterpriseObject anEnterpriseObject) { EOEditingContext ec = anEnterpriseObject.editingContext(); if (ec != null) { EOGlobalID globalID = an

Can't Update Primary Key in PostgreSQL

2006-06-15 Thread Mac Dev
Hello,It's me again.  The guy who just recently moved the database from MSSQL 7 to PostgreSQL 8.1.I am getting errors like this whenever I try to save changes in my defaultEditingContext:java.lang.IllegalStateException: cannot update primary-key 'user_ID' from '11795' to '11795' on object:{values .