Norman Yamada wrote:
> One further thought --
>
> In our complicated schema crossing, the tables in the different
> schemas use the same trigger function as well as same trigger name --
> could this cause a problem?
>
> tmc=# select tgrelid,tgname, tgfoid from pg_trigger where tgname like
> 'run_market%';
> tgrelid | tgname | tgfoid
> ----------+------------------------+--------
> 19333 | run_market_aft_ins_upd | 19051
> 19554 | run_market_aft_ins_upd | 19051
> 22991168 | run_market_aft_ins_upd | 19051
> (3 rows)
>
> There are three run_market tables: one in schema public, one in stage,
> one in research. Each has a trigger called "run_market_aft_ins_upd" ,
> but all three point to the same trigger function. Is this a problem?
It's always worth trying these things out on "scratch monkeys" before
afflicting anything important like Mabel with it (see the somewhat
funny, somewhat sad story on that here
<http://www.catb.org/jargon/html/S/scratch-monkey.html>), but I'd not
expect any conflicts.
The triggers that get hidden are the ones on replicated tables.
Simply using a function shouldn't cause a conflict...
------
A possibly not quite 100% accurate recount of the sad tale of Mabel...
My friend Bud used to be the intercept man at a computer vendor for
calls when an irate customer called. Seems one day Bud was sitting at
his desk when the phone rang.
Bud: Hello. Voice: YOU KILLED MABEL!!
B: Excuse me? V: YOU KILLED MABEL!!
This went on for a couple of minutes and Bud was getting nowhere, so he
decided to alter his approach to the customer.
B: HOW DID I KILL MABEL? V: YOU PM'ED MY MACHINE!!
Well to avoid making a long story even longer, I will abbreviate what had
happened. The customer was a Biologist at the University of Blah-de-blah,
and he had one of our computers that controlled gas mixtures that Mabel (the
monkey) breathed. Now Mabel was not your ordinary monkey. The University
had spent years teaching Mabel to swim, and they were studying the effects
that different gas mixtures had on her physiology. It turns out that the
repair folks had just gotten a new Calibrated Power Supply (used to
calibrate analog equipment), and at their first opportunity decided to
calibrate the D/A converters in that computer. This changed some of the gas
mixtures and poor Mabel was asphyxiated. Well Bud then called the branch
manager for the repair folks:
Manager: Hello
B: This is Bud, I heard you did a PM at the University of
Blah-de-blah.
M: Yes, we really performed a complete PM. What can I do
for You?
B: Can You Swim?
The moral is, of course, that you should always mount a scratch monkey.
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
