Syntax checking DO blocks and ALTER TABLE statements? - Mailing list pgsql-general

From Ron
Subject Syntax checking DO blocks and ALTER TABLE statements?
Date
Msg-id ef0b6d3f-e351-2aef-b09d-3f817cf83269@gmail.com
Whole thread Raw
Responses Re: Syntax checking DO blocks and ALTER TABLE statements?
RE: Syntax checking DO blocks and ALTER TABLE statements?
List pgsql-general
How does one go about syntax checking this?

do $$
begin if exists (select 1 from information_schema.table_constraints
        where constraint_name = 'error_to_web_service_error') then
             raise notice 'EXISTS error_to_web_service_error';
     else
         ALTER TABLE web_service_error
            ADD CONSTRAINT error_to_web_service_error FOREIGN KEY (error_id)
            REFERENCES error_code(error_id)
            ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;
     end if
end $$

(There are 222 ALTER TABLE ADD FOREIGN KEY statements that I'm wrapping in 
similar DO blocks, and want to make sure the statements are clean.)

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Order by not working
Next
From: "David G. Johnston"
Date:
Subject: Re: Syntax checking DO blocks and ALTER TABLE statements?