In master, the 'web_user_pi_timestamp' trigger on 'web_user_personal_info' is
being defined in:
'rhnsat/tables/web_user_personal_info.sql' (SNIP#1)
Then redefined in (and the filename is all wrong):
'rhnsat/tables/web_user_contact_permission.sql' (SNIP#2)
The net effect is that the 'web_user_pi_timestamp' trigger is begin installed
as:
BEFORE INSERT OR UPDATE ON web_user_personal_info
FOR EACH ROW
BEGIN
:new.modified := sysdate;
END;
instead of:
before insert or update on web_user_personal_info
for each row
begin
:new.email_uc := upper(:new.email);
:new.modified := sysdate;
end;
Does anyone know what was really intended here?
I've corrected for the net effect in pgsql but wanted to be sure the intended effect was
being achieved.
Thanks,
Jeff
SNIP #1
-------------------
2904 -- SQL relevant contents from file rhnsat/tables/web_user_personal_info.sql
...
2943 create or replace trigger
2944 web_user_pi_timestamp
2945 before insert or update on web_user_personal_info
2946 for each row
2947 begin
2948 :new.email_uc := upper(:new.email);
2949 :new.modified := sysdate;
2950 end;
2951 /
SNIP#2
----------------------
36408 -- SQL relevant contents from file
rhnsat/tables/web_user_contact_permission_triggers.sql
36409 create or replace trigger
36410 web_user_pi_timestamp
36411 BEFORE INSERT OR UPDATE ON web_user_personal_info
36412 FOR EACH ROW
36413 BEGIN
36414 :new.modified := sysdate;
36415 END;
36416 /
36417 show errors
_______________________________________________
Spacewalk-devel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-devel
