Richard Broersma Jr wrote:
--- Paul Lambert <[EMAIL PROTECTED]> wrote:
The purpose being when a row in a table in one database is updated, it
will copy (or replicate I guess) the record into a different table into
another database in the same server. (deleting said record first if it
already exists)
What is the best way to do this within Postgres?
In postgresql, there are two parts to implementing a trigger; the trigger
function and the actual
trigger on the table that calls this function.
Here is a good example:
http://www.postgresql.org/docs/8.2/interactive/plpgsql-trigger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE
One other point to be aware of, Postgresql does not allow your to reference
other databases in the
DB-cluster directly. It is possible but you need to add a contrib module
called dblink:
http://pgfoundry.org/projects/snapshot/
Hope this helps,
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Perfect, thanks Richard.
Regards,
Paul.
--
Paul Lambert
Database Administrator
AutoLedgers
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
