Can't Update Primary Key in PostgreSQL

Subject: Can't Update Primary Key in PostgreSQL
From: Mac Dev <email@hidden>
Date: Thu, 15 Jun 2006 11:59:57 -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@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

Follow-Ups:
- Re: Can't Update Primary Key in PostgreSQL
  - From: Chuck Hill <email@hidden>
- Re: Can't Update Primary Key in PostgreSQL
  - From: Gary Teter <email@hidden>

Prev by Date: Re: Creating Charts and Graphs - Recommendations
Next by Date: Re: Can't Update Primary Key in PostgreSQL
Previous by thread: Re: Creating Charts and Graphs - Recommendations
Next by thread: Re: Can't Update Primary Key in PostgreSQL
Index(es):
- Date
- Thread