Guys,

I've been asked by a colleague about methods to keep track of
'previous' contents of a table - i.e. changes made and a way of
getting back to a previous state. Now, I know INSERT/UPDATE/DELETE
triggers to maintain an accompanying table is a way to do this. But, I
have a nagging feeling that somebody has at one point put together
such a feature in a generic fashion... I thought there was a 'time
machine' module in contrib! Searches through the mailing lists have
not turned up any specific pointers.

Aanyone else remember this, and remember where? Or am I misguided and
deluded!

Thanks, Lee.

Wed, 18 Dec 2002 16:59:21 +0000
Lee Kindness <lkindness@csl.co.uk>
Table Timemachine!
Lee Kindness <lkindness@csl.co.uk> writes:
> I have a nagging feeling that somebody has at one point put together
> such a feature in a generic fashion... I thought there was a 'time
> machine' module in contrib!

contrib/spi/timetravel.*

I haven't ever tried it ...

			regards, tom lane

Wed, 18 Dec 2002 12:31:37 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Table Timemachine! 
How to send request to server to cancel a query with libpq API?
Thanks

Wenzhe


Wed, 18 Dec 2002 09:57:00 -0800
Wenzhe Zhou <wzhou@cisco.com>
How to cancel a query with libpq
PQrequestCancel()....but that would work with Async queries or if you 
are using
7.3, you can timeout via postgresql.conf:statement_timeout and then send the
cancellation request to the backend.....

Wenzhe Zhou wrote:

>How to send request to server to cancel a query with libpq API?
>Thanks
>
>Wenzhe
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>  
>




Wed, 18 Dec 2002 10:58:44 -0800
Medi Montaseri <medi.montaseri@intransa.com>
Re: How to cancel a query with libpq
Tom Lane writes:
 > Lee Kindness <lkindness@csl.co.uk> writes:
 > > I have a nagging feeling that somebody has at one point put together
 > > such a feature in a generic fashion... I thought there was a 'time
 > > machine' module in contrib!
 > contrib/spi/timetravel.*
 > I haven't ever tried it ...

It's really quite good. Could do with an update - it uses abstime
internally and the docs refer to 'currabstime' which is no longer
around.

Nice.

Lee.

Thu, 19 Dec 2002 17:35:47 +0000
Lee Kindness <lkindness@csl.co.uk>
Re: Table Timemachine! 
Lee Kindness <lkindness@csl.co.uk> writes:
> Tom Lane writes:
>>> Lee Kindness <lkindness@csl.co.uk> writes:
>>>> I have a nagging feeling that somebody has at one point put together
>>>> such a feature in a generic fashion... I thought there was a 'time
>>>> machine' module in contrib!

>>> contrib/spi/timetravel.*

>>> I haven't ever tried it ...

> It's really quite good. Could do with an update - it uses abstime
> internally and the docs refer to 'currabstime' which is no longer
> around.

Patches cheerfully accepted ;-)

			regards, tom lane

Thu, 19 Dec 2002 12:44:59 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Table Timemachine! 