Michael Dengler wrote: > I am trying to find out how to use a trigger function on a table to copy > any > inserted row to a remote PG server.
Have a look at contrib/dblink. You'll have to think what you want to happen in error scenarios. For example, if the connection is down, or it brakes just after inserting the row to the other db, but before committing. Or if the insert on the other server succeeds, but the local transaction aborts. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
