Thread: How to insert into another db instance in pl/plsql...

Hi,
    I this question seems out of place on the other mailing lists, so I
posted here.

    Basically, the problem is this:
I have 2 database instances. InstanceA & InstanceB
In InstanceA, I have a trigger on a table which, when activated, will
insert a row into some table in InstaceB.
The trigger is written in pl/pgsql.

How can this be done?

Any help would be greatly appreciated.
Rick

On Monday 06 Jan 2003 4:06 pm, Rick Szeto wrote:
> Hi,
>     I this question seems out of place on the other mailing lists, so I
> posted here.
>
>     Basically, the problem is this:
> I have 2 database instances. InstanceA & InstanceB
> In InstanceA, I have a trigger on a table which, when activated, will
> insert a row into some table in InstaceB.
> The trigger is written in pl/pgsql.
>
> How can this be done?

You probably want to look at the dblink package in contrib/dblink.
Alternatively, you'd have to do it with a daemon application LISTENing for
messages from your trigger.
Alternatively, you could use schemas in 7.3 to make it look like you have two
databases.

Option 1 seems to be what you're after. I think 7.3 dblink has had some
reworking, so if you can upgrade first that might be an idea.

--
  Richard Huxton