Hi all,
I need to have two tables that are mostly synchronized in my database,
such that an edit to a row in one is made to the other, and vice versa.
Normally, this is done using views with rules, however my situation does
not allow editable views (http://trac.osgeo.org/fdo/ticket/346). So, I
nee
return new;
> end;
> $$ language plpgsql;
>
> this is protection under resursive triggers
>
> regards
> Pavel Stehule
>
>
>
>
> 2008/9/18 Michael Toews <[EMAIL PROTECTED]>:
>
>> Hi all,
>>
>> I need to have two tables that are mostly sy
TE PROCEDURE prim.sync_mytable_fn();
CREATE TRIGGER second_sync
BEFORE INSERT OR UPDATE OR DELETE
ON "second".mytable
FOR EACH ROW
EXECUTE PROCEDURE prim.sync_mytable_fn();
Michael Toews wrote:
> The INSERT and DELETE TG_OPs are straightforward (the simplest solution for
