Re: Inserting data in other db
Re: Inserting data in other db
От:
Michael Fuhr <mike@fuhr.org>
Дата:
On Thu, Sep 01, 2005 at 01:09:55PM +0000, Toff wrote: > I want to insert data from a table in a database to a table of another > database when the data is added in the first table, thus using a trigger on > the 1st table. > So, is there some way to acces a 2nd database within functions of the 1st > database? Or do I have to write an extrenal application to do the > datatransfer? You could use contrib/dblink or a function written in a procedural language like PL/Perl that can access external data sources, but beware that you won't get transactional semantics. If you roll back the transaction in the first database, you don't have a way to propogate that rollback to the second database. -- Michael Fuhr
Inserting data in other db
От:
"Toff" <kristoff.six@telenet.be>
Дата:
Hi, I want to insert data from a table in a database to a table of another database when the data is added in the first table, thus using a trigger on the 1st table. So, is there some way to acces a 2nd database within functions of the 1st database? Or do I have to write an extrenal application to do the datatransfer? I know the copy from db and copy to db commands, but then the data cant be automaticly inserted in the 2nd database..... as far as I know. Kind regards, Kristoff
