Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. --- a/bucardo.schema
  2. +++ b/bucardo.schema
  3. @@ -73,8 +73,9 @@ RETURNS TRIGGER
  4. LANGUAGE plpgsql
  5. AS $bc$
  6. BEGIN
  7. -
  8. - NEW.setting = LOWER(NEW.setting);
  9. + IF NEW.name <> ALL('{log_conflict_file,warning_file,email_debug_file,flatfile_dir,reason_file,stats_script_url,stopfile,log_timer_format}') THEN
  10. + NEW.setting = LOWER(NEW.setting);
  11. + END IF;
  12.  
  13. IF (NEW.type IS NOT NULL and NEW.item IS NULL) THEN
  14. RAISE EXCEPTION 'Must provide a specific %', NEW.type;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement