Thread: Trigger ad mutli database

Trigger ad mutli database

From
Dorine Periolat
Date:
hi,

is it possible to make a trigger on Table T1 on
a database B1 that makes an action on a Table T2 on
a database B2 ???

I'm using postgre 7.2

Thanks
Dorine

Re: Trigger ad mutli database

From
Jaime Casanova
Date:
On 7/28/05, Dorine Periolat <dorinep@gmail.com> wrote:
> hi,
>
> is it possible to make a trigger on Table T1 on
> a database B1 that makes an action on a Table T2 on
> a database B2 ???
>
> I'm using postgre 7.2
>
> Thanks
> Dorine

No, at least you are using contrib/dblink

what about upgrading and using schemas (it's available since 7.4, IIRC)?


--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

Fwd: Trigger ad mutli database

From
Jaime Casanova
Date:
On 7/28/05, Dorine Periolat <dorinep@gmail.com> wrote:
>

Always send a copy to the list... not only because is better to get
more answers but i actually see little my own mail... just check the
lists... ;)

> What is contrib/dblink ?
>
Is a module some contrib to make querys that take tables from more
than one database... if you install from sources you can enter in
<pgsql_src_path>/contrib to see dblink there are instructions to
install...

i don't use it... so i can't help you with the instalation nor the
use... some one in the list maybe can answer you...

> I can't upgrade, the company wants the solution to stay on 7.2
>
that's bad... we are currently in 8.0.3 and developing 8.1... if, in
future, you come here with one of the 7.2 already found bugs...
claiming something really bad happens to your data... it will be
entirely _your fault_ and the answers can be directed in that way...


--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)


--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)