Norman Yamada nyamada
Fri Jun 30 09:33:34 PDT 2006
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?


######################################################################
This e-mail is confidential and should not be redistributed or
forwarded by the recipient.  The information contained in this e-mail
message is intended only for the use of the individual or entity named
above.  If the reader of this message is not the intended recipient or
you have received this communication in error, please immediately
notify us by telephone.  Receipt by anyone other than the intended
recipient is not a waiver of any work-product or, if applicable,
attorney-client privilege.

This e-mail does not constitute an offering of any security.  Such an
offering may only be made by means of a private placement memorandum
or other disclosure document.  Nothing in this e-mail constitutes
investment advice.  Past performance is not indicative of future
results.  All e-mail to and from Millburn Ridgefield Corporation and
its affiliates is monitored, stored and made available to regulators
if requested.
######################################################################



More information about the Slony1-general mailing list