Home > Archive > PostgreSQL Discussion > May 2005 > Can postgresql catch all the sentences applies to one table?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Can postgresql catch all the sentences applies to one table?
Manuel García

2005-05-26, 11:23 am

Hello, Somebody knows If is possible to catch all the sentences applies to one table using triggers and function in C maybe, that's because, I need to create one log table with all the sentences. Once that I have that I going to use all the sentences to replicate that table in other database, and after the first load of this table I going to try to apply only the last sentences register on the source table.



If this is possible I like to know or maybe if somebody can advice me about some technical documentation



I am using postgresql 7.3



Somebody, can help me



Thanks in advanced.



Atte. Manuel
Vivek Khera

2005-05-26, 8:23 pm


On May 26, 2005, at 11:55 AM, Manuel García wrote:

> Hello, Somebody knows If is possible to catch all the sentences
> applies to one table using triggers and function in C maybe,
> that’s because, I need to create one log table with all the
> sentences. Once that I have that I going to use all the sentences
> to replicate that table in other database, and after the first load
> of this table I going to try to apply only the last sentences
> register on the source table.
>


There are at least two table replication projects that sounds like
they will solve whatever problem you're trying to solve. No need to
do all that work re-inventing it.


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com