Re: timetravel.c - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: timetravel.c
Date
Msg-id 200307200125.h6K1Ps102104@candle.pha.pa.us
Whole thread Raw
In response to timetravel.c  (Böjthe Zoltán <zbojthe@arcinfo.hu>)
Responses Re: timetravel.c  (Böjthe Zoltán <urdeso@arcinfo.hu>)
List pgsql-patches
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
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_dump fix
Next
From: Bruce Momjian
Date:
Subject: Re: Minor pager corrections in print.c and help.c (psql)