Re: triggers/functions across databases

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 database. Informix can do this with no problem but we were
> wondering if there is an easy way for postgres to do this. I've searched
> numerous sites and found vague answers. Thanks in advance.

If you have databases that are dependent on each others data you should
probably move those databases into a new schema within one database...

See the create schema command.

Otherwise you could use dblink but it would not be my suggestion.

Sincerely,

Joshua D. Drake

>
> Eric Jones
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/