LOG table changes ... - PostgreSQL Database

raptor

hi,

I want to track every change made to several tables...and was wondering
what is the best way... What are my thoughts at the moment are to make a
table like this :

id, table_name, field_name, old_value, new_value, timestamp

and triggers to do the logging.
but this will probably generate alot of traffic (not so worrying at the moment)

As I side effect of this I want to be able to make a snapshot of the TABLE at specified time..
any ideas on this too...

tia.

P.S. Other way would be to make a duplicate table and transffer the whole record, but
dont think this is a good solution

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1

Subscribe Post Reply

2101

Marius Andreiana

On Mon, 2004-07-19 at 14:52 +0300, ra****@tvskat.net wrote:

hi,

I want to track every change made to several tables...and was wondering
what is the best way...

See this
http://archives.postgresql.org/pgsql...1/msg00274.php

--
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #2

Similar topics

Copying a MySQL row to another table

by: Gordon Burditt | last post by:

What's the easiest way to copy a row from one table to another (with the same schema), without knowing in advance the number and types of the columns? The problem: I have several sets of tables...

MySQL Database

Do I need keys/indexes for a 3column table?

by: Randell D. | last post by:

Folks, My internet access is intermitent until I get my own connection inside the next ten days - I say this so that I can thank in advance who ever gives a few seconds to read/answer my...

MySQL Database

Changing the data type of a field in a table thru code

by: Peter | last post by:

Can anyone tell me how to change the data type of a field in a table created with a make table query? The field is a binary and must be changed to text. alternately does anyone know how to specify...

Microsoft Access / VBA

at wit's end about corrupted records in Access 2k table!

by: Lee Rouse | last post by:

Hello all, This is going to be a rather lengthy "question". I have an Access 2k database, separated front end/back end. Front end copies are on about 30 workstations and used frequently during...

Microsoft Access / VBA

Table Design

by: Stewart Allen | last post by:

Hi Just asking for ideas on table design. The design I have is as follows: *tblBuildData* BuildID (PK) AutoNumber ManufactureDate SerialNumber

Microsoft Access / VBA

SQL command to create new table?

by: Jacob | last post by:

A simple question: I've read a couple of things that indicates I can create a new table in my database using some SQL command. Is this correct? I would like to load a database into a DataSet,...

C# / C Sharp

Referential Integrity - linking multiple tables to transaction table

by: heyvinay | last post by:

I have transaction table where the rows entered into the transaction can come a result of changes that take place if four different tables. So the situation is as follows: Transaction Table...

Microsoft SQL Server

DB2 Trigger To Track Table Changes

by: keith.culpepper | last post by:

Can anyone please provide some assistance with a trigger that I need to develop. Here is the situation: Our program updates depend on database updates. If a client receives the program update...

DB2 Database

Using arrays to take records from a html table and update database

by: Ian Davies | last post by:

Hello Needing help with a suitable solution. I have extracted records into a table under three columns 'category', 'comment' and share (the category column also holds the index no of the record...

PHP

Automatic data changes in a form need to save to table

by: subhashkumar | last post by:

Running data Append to a table Dear All, I need a help from this forum, I was developing a small tools for stock market. I get stuck when trying to save the running changes in a data field...

Microsoft Access / VBA

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing