Re: [SQL] check source of trigger

2002-09-26 Thread Rajesh Kumar Mallah.
Hi, In case you doing all this to replicate tables conside contrib/dbmirror it does it fairly elegantly. regds mallah. On Friday 20 September 2002 13:55, wit wrote: > Hello, > > I have a question about trigger. I have tables with the following > structure: > > create table A ( >e_codeA char

Re: [SQL] check source of trigger

2002-09-20 Thread Richard Huxton
On Friday 20 Sep 2002 9:25 am, wit wrote: > I have trigger and procedure on table B to capture any change and insert > into table logB: > create trigger trigger_b before insert or update or delete on B for > each row execute procedure log_change(); > > When I update e_codeA in table A, the co

[SQL] check source of trigger

2002-09-20 Thread wit
Hello, I have a question about trigger. I have tables with the following structure: create table A ( e_codeA char(5) default '' not null, n_codeA varchar(20) default '' not null, constraint A_pkey primary key ( e_codeA ) ); create table B ( e_codeB char(5) default '' not null, e_