• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• source code
• enableTrigger.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.harness.change.expectedSql.postgresql.enableTrigger.sql Maven / Gradle / Ivy

CREATE OR REPLACE FUNCTION test_function()
RETURNS trigger
AS $$
BEGIN
RAISE NOTICE 'Test trigger function created'
RETURN NEW
END
$$
LANGUAGE plpgsql
CREATE TRIGGER test_trigger
BEFORE INSERT ON public.posts
FOR EACH ROW EXECUTE PROCEDURE test_function()
ALTER TABLE public.posts  DISABLE TRIGGER test_trigger
ALTER TABLE public.posts  ENABLE TRIGGER test_trigger