Hi Ted, I was wrong about it only happening in production I was able to replicate it locally.
Each of the frameworks and applications have the postgresql.jar Thanks, Johnny On Aug 14, 2013, at 2:32 PM, Theodore Petrosky <[email protected]> wrote: > you said it only happens on the production box. I have a couple of deployment > boxes that I test deployments. can you duplicate this. and what about the > postgresql.jar. I always copy that to my Library folder and add it to the > Build Path. > > > On Aug 14, 2013, at 8:24 PM, Johnny Miller <[email protected]> wrote: > >> Hi Ted, >> >> Everything is going through EOF. I'm not doing any manual inserts. >> >> But what I think is happening is that if the PostgreSQL plugin is only in >> the framework and not the application itself for some reason EOF reverts to >> using eo_pk_table. >> >> I'm testing right now to see if that is the case. >> >> Thanks, >> >> Aloha, >> Mr. Johnny Miller >> Web Development Manager >> Kahalawai Media Company >> Lahaina, HI 96761 >> tel: (808) 661-7962 | mobile: (808) 283-0791 >> website | e-mail >> >> On Aug 14, 2013, at 2:17 PM, Theodore Petrosky <[email protected]> wrote: >> >>> I've noticed that WO's order of events is to read the lastvalue, then to >>> create an insert that includes the id. then it updated the sequence. so you >>> can get out of sequence if you manually inserted any rows and didn't check >>> to make sure you updated the seq. >>> >>> that said, i have a table with a sequence and I inserted data using the >>> next value from the sequence (lastvalue was 9) >>> >>> insert into table (firstname, id) values ('ted', 10); >>> >>> it inserted correctly into the user table however because I supplied the id >>> value, it did not update the sequence. This is documented behavior. >>> >>> How you got out of sync I don't know. Either you manually added a row, or >>> you are getting in the way of WO and inserting using raw SQL (you can but >>> you will have to resolve the primary key). >>> >>> I don't know if this is the issue. Just my musings >>> >>> Ted >>> >>> >>> On Aug 14, 2013, at 6:30 PM, Johnny Miller <[email protected]> wrote: >>> >>>> Hi, >>>> >>>> I'm using a PostgreSQL database and I'm having a problem with the sequence >>>> not getting updated. >>>> >>>> I'm using ERAttachment and I have pages that will generate thumbnails of >>>> the attachment for specific sizes. And for some reason when creating the >>>> thumbnail it will not update the sequence for ERAttachment. It stops >>>> using the sequence to generate the ID and switches over to EO_PK_TABLE so >>>> the thumbnails get properly saved. But the next time I go to add an >>>> attachment I get a EO general adapter exception because the sequence is >>>> behind the value in EO_PK_TABLE which holds the last generated ID. >>>> >>>> And it only seems to do this in production on my OS X 10.5.8 server box. >>>> >>>> Has anybody seen this before? >>>> >>>> Aloha, >>>> Mr. Johnny Miller >>>> Web Development Manager >>>> Kahalawai Media Company >>>> Lahaina, HI 96761 >>>> tel: (808) 661-7962 | mobile: (808) 283-0791 >>>> website | e-mail >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list ([email protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com >>>> >>>> This email sent to [email protected] >>> >> >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
