*** dcmwai has quit IRC *** mnemoc_ has joined #gnuenterprise *** mnemoc has quit IRC *** sjc has joined #gnuenterprise *** reinhard has joined #gnuenterprise good morning anybody could test if ggcvs working? ggcvs? it is gnue-gsdgen actually oh I have lost my copyright assignment paperwork damn dimas: I used it 3 days ago and AFAICT no change since that but let me svn up and test again dimas: works perfectly for me please be aware you have to run it on the *db* connection not on the appserver connection that was the mistake reinhard: thanks *** wt has quit IRC *** lekma has joined #gnuenterprise morning everyone hello lekma hi dimas *** sjc has quit IRC *** johannesV has joined #gnuenterprise *** holycow has joined #gnuenterprise *** johannesV_ has joined #gnuenterprise *** johannesV has quit IRC *** jcater has joined #gnuenterprise reinhard, are you there ? yes i do have a prob with OnValidate ok, back are you in the office atm ? yes ok *** SachaS has quit IRC *** holycow has quit IRC *** neilt has joined #gnuenterprise hello all hey neilt! how nice to see you! hello, long time I've been away you wouldn't believe people are already using appserver in production! cool well... at least one does :-) I just svn'ed the current source it looks like you (and the team) have made a lot of progress yes (where I take "you" as a plural "you") brb, going to watch news on TV *** sjc has joined #gnuenterprise holy crabby patties back bbl *** johannesV_ has quit IRC hey chillywill, how are you doing? *** johannesV has joined #gnuenterprise neilt: fine thanks you guys should check this out: http://www.devx.com/dbzone/Article/22093 ow, I really did a number on my little toe stubbed/jammed it good *** SachaS has joined #gnuenterprise reinhard, are you still there ? no I am again here :) i've tried the following situation: session a changes the zip of 'spock' and session b changes the street of 'spock' ok ERROR POSTING RECORD # 1 ERROR: could not serialize access due to concurrent update i've tried to reproduce this situation using psql doing the same steps, the second update-statement is *blocking* which means psql continues execution only when the first session sends it's commit which command gives you the ERROR? the second commit ok problem is, we're not only changing street or zip but also gnue_modifydate/gnue_modify_user which is the real clash i think ah you might be correct but, i've tried that with psql too did you set transaction isolation to serializable in psql? yes i've tried that situation in psql too, with succes where the last commit was the winner success == same error or success = no error? ah ok no error the main difference is that in psql it's blocking and in gnue it's not might be interesting to try with different postgres drivers maybe it's a shortcoming of psycopg right heh GMTY GMTA actually :) you could make a python script reproducing the error with psycopg another interesting point would be how this behaves using forms so you can easily try with different db's and different drivers actually i have a language-interface-script doing this now I think it would be good if you could commit the testcases you use especially if it's python scripts langauge-interface-scripts is what i mean there, yes :) *** lekma has quit IRC ok, i've tried it with sample.gfd and it behaves the same way how are the other postgresql drivers called ? pygresql and pypgsql you can forget popy as it's not maintained any more anyway pygresql is not working in common :) AttributeError: Connection instance has no attribute '_pg_encoding' will fix that oops maybe it was me who broke that yes I was it hadn't noticed that pygresql overwrites Connection.connect no need to send SET CLIENT_ENCODING in connect but rather _pg_encoding should be set because postgres forgets about CLIENT_ENCODING on end of transaction ah, ok so it was necessary to move the SET CLIENT_ENCODING to the start of every transaction *** neilt has quit IRC wow using pygresql it's working ! will try the scripts now yes using pygresql concurrent updates *are* working which deb do i need to dl for pypgsql ? *** dcmwai has joined #gnuenterprise ok, i'm off for today ... i think i can commit appserver tomorrow, changes are good looking ... bye *** johannesV has quit IRC *** holycow has joined #gnuenterprise *** wendall911 has joined #gnuenterprise * dcmwai is away: I'm busy *** holycow has quit IRC *** holycow has joined #gnuenterprise *** reinhard has quit IRC *** mdean_ has joined #gnuenterprise *** mdean has quit IRC *** mdean_ has quit IRC *** wendall911 has quit IRC *** sjc has quit IRC * dcmwai is away: I'm busy