Can't Update Primary Key in PostgreSQL

Thu, 15 Jun 2006 12:01:55 -0700

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 ...

This was not happening when I was using the old MSSQL.  I searched the list archive and found this:

Hunter,

By any chance, would you have set the pk to be a class property, would you?

r.

On 21/04/2004, at 7:49, Hunter Hillegas wrote:

I have an issue with EOF that I can't figure out. I've seen some discussion of similar issues on the list but no solution...

WO 5.2.3/Java 1.4.2 Panther 10.3.3

Basically, EOF is trying to update my primary key but it hasn't changed.

1. Create entity.
2. Save entity.
3. Fetch entity.
4. Update entity.
5. Save entity.

Step 5 generates this exception:

java.lang.IllegalStateException: cannot update primary-key 'recNum' from '4' to '4' on object:{values = {recNum = 4; season = "Spring 2007"; summary = "sdfasdfasdf"; coverImageUri = "1300989293-5838.jpg"; issueDepartments = ("<IssueDepartment 9ce8f3 ...
_______________________________________________

I have the PK set as class property because it is used as key for some direct action pages.  Is there anyway to not have the PK updated when saving?

Any help is greatly appreciated.  Thank you very much for reading.

Regards,

Nick Yang



 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to