On Tue, 2021-11-16 at 15:24 +0530, Sanjay Minni wrote:
>
> On Tue, 16 Nov 2021 at 14:50, Laurenz Albe wrote:
> > On Tue, 2021-11-16 at 13:56 +0530, Sanjay Minni wrote:
> > > I need to keep a copy of old data as the rows are changed.
> > >
> > > For a general RDBMS I could think of keeping all t
On 2021-11-16 13:56:51 +0530, Sanjay Minni wrote:
> I need to keep a copy of old data as the rows are changed.
>
> For a general RDBMS I could think of keeping all the data in the same table
> with a flag to indicate older copies of updated / deleted rows or keep a
> parallel table and copy thes
Alban,
Its a simple financial transaction processing application, the application
permits editing / updating / deleting of entered data even multiple times
but audit trail of the data tracing through all versions to its original
must be preserved.
(as outlined - Programmatically i could approach i
> On 16 Nov 2021, at 10:20, Laurenz Albe wrote:
>
> On Tue, 2021-11-16 at 13:56 +0530, Sanjay Minni wrote:
>> I need to keep a copy of old data as the rows are changed.
>>
>> For a general RDBMS I could think of keeping all the data in the same table
>> with a flag
>> to indicate older copie
Are you referring to Table Partitioning ?
https://www.postgresql.org/docs/14/ddl-partitioning.html
with warm regards
Sanjay Minni
+91-9900-902902
http://planage.com
https://www.linkedin.com/in/sanjayminni/
On Tue, 16 Nov 2021 at 14:50, Laurenz Albe wrote:
> On Tue, 2021-11-16 at 13:56 +0530,
On Tue, 2021-11-16 at 13:56 +0530, Sanjay Minni wrote:
> I need to keep a copy of old data as the rows are changed.
>
> For a general RDBMS I could think of keeping all the data in the same table
> with a flag
> to indicate older copies of updated / deleted rows or keep a parallel table
> and
I need to keep a copy of old data as the rows are changed.
For a general RDBMS I could think of keeping all the data in the same table
with a flag to indicate older copies of updated / deleted rows or keep a
parallel table and copy these rows into the parallel data under program /
trigger control
