Great. Please send over the file as an attachment and I will see that it is added, or even better, use diff -c against the 7.3.2 version and your new version so we can see the changes.
--------------------------------------------------------------------------- Böjthe Zoltán wrote: > Hi! > > I am a new person in list. I am dont good speak english, sorry. > > I rewritten the contrib/spy/timetravel.c, because: > > on original version of postgresql 7.3.2-7.3.3: > > the UPDATE not work on timetravel.example if I added > >create unique index tttest_idx on tttest (price_id,price_off); > >update tttest set price_val = 30 where price_id = 3; > ERROR: Cannot insert a duplicate key into unique index tttest_idx > > And UPDATE not work on table tttest after > >alter table tttest add column q1 text; > >alter table tttest add column q2 int; > >alter table tttest drop column q1; > >update tttest set price_val = 30 where price_id = 3; > ERROR: Parameter '$5' is out of range > (because the trigger is added the deleted q1 column for insert statement) > > And I add a new optional feature: my new timetravel have +3 optional > parameters: > inserter_user, updater_user, deleter_user. > > And I add a new function: get_timetravel for get timetravel status > without change it. > > A big difference: > the old version on UPDATE changed oid on active ('infinity') record, > the new version UPDATE keep oid, and the overdued record have a new oid. > > What am I doing with this? Send file with attachement to this list? > > Sorry for my english > > Zoltan > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend