On Tue, 19 Jun 2007, Jeff Davis wrote:
I have a table in my database that holds information on policies and this
table is linked to a number of other tables. I need to be able to keep a
history of all changes to a policy over time. The other tables that are
linked to policy also need to store hi
On Thu, 2007-06-14 at 10:57 -0700, Lza wrote:
> Can anyone help me with this problem?
>
> I have a table in my database that holds information on policies and
> this table is linked to a number of other tables. I need to be able to
> keep a history of all changes to a policy over time. The other t
am Fri, dem 15.06.2007, um 8:21:45 -0400 mailte Francisco Reyes folgendes:
> Lza writes:
>
> >I have a table in my database that holds information on policies and
> >this table is linked to a number of other tables. I need to be able to
> >keep a history of all changes to a policy over time. The
Lza writes:
I have a table in my database that holds information on policies and
this table is linked to a number of other tables. I need to be able to
keep a history of all changes to a policy over time. The other tables
There is a postgresql project which I just saw last night.
Don't recall
On Thu, 14 Jun 2007, Lza wrote:
> Does anyone have any suggestions on how to store historical
> information in databases?
-- I have tables:
create table history_columns (
column_id smallint primary key,
column_name varchar(63) not null,
table_name varchar(63) not null,
am Thu, dem 14.06.2007, um 10:57:43 -0700 mailte Lza folgendes:
> Can anyone help me with this problem?
>
> I have a table in my database that holds information on policies and
> this table is linked to a number of other tables. I need to be able to
> keep a history of all changes to a policy ove
On Thu, 14 Jun 2007, Lza wrote:
When I run a query on the policy table for a certain period, I also need
to be able to pull the correct related rows (i.e. the information that
would have been in the table at that time) from the tables linked to it.
Check out "Developing Time-Oriented Database
Can anyone help me with this problem?
I have a table in my database that holds information on policies and
this table is linked to a number of other tables. I need to be able to
keep a history of all changes to a policy over time. The other tables
that are linked to policy also need to store histo
On Jun 14, 12:57 pm, Lza <[EMAIL PROTECTED]> wrote:
> Can anyone help me with this problem?
>
> I have a table in my database that holds information on policies and
> this table is linked to a number of other tables. I need to be able to
> keep a history of all changes to a policy over time. The ot