Re: [GENERAL] triggers/functions across databases

2005-05-25 Thread Mike Nolan
> If you have databases that are dependent on each others data you should > probably move those databases into a new schema within one database... That's a non-trivial task, especially if some of the tables in the two databases have the same name. -- Mike Nolan ---(end o

Re: [GENERAL] triggers/functions across databases

2005-05-25 Thread Joshua D. Drake
Mike Nolan wrote: If you have databases that are dependent on each others data you should probably move those databases into a new schema within one database... That's a non-trivial task, especially if some of the tables in the two databases have the same name. Migrating from one database t

Re: [GENERAL] triggers/functions across databases

2005-05-25 Thread Joshua D. Drake
Eric Jones wrote: We are migrating from Informix to Postgres 7.4.7 and are having a difficult time finding if postgres can insert/update tables across different databases. Namely using functions/triggers when an update/insert is performed on a table it updates/inserts in a table on a different

Re: [GENERAL] triggers/functions across databases

2005-05-25 Thread Richard Huxton
Eric Jones wrote: We are migrating from Informix to Postgres 7.4.7 and are having a difficult time finding if postgres can insert/update tables across different databases. Namely using functions/triggers when an update/insert is performed on a table it updates/inserts in a table on a different

Re: [GENERAL] triggers/functions across databases

2005-05-25 Thread Scott Marlowe
On Wed, 2005-05-25 at 07:08, Eric Jones wrote: > We are migrating from Informix to Postgres 7.4.7 and are having a > difficult time finding if postgres can insert/update tables across > different databases. Namely using functions/triggers when an > update/insert is performed on a table it update

[GENERAL] triggers/functions across databases

2005-05-25 Thread Eric Jones
We are migrating from Informix to Postgres 7.4.7 and are having a difficult time finding if postgres can insert/update tables across different databases. Namely using functions/triggers when an update/insert is performed on a table it updates/inserts in a table on a different database. Informix