Search Postgresql Archives

Syntax checking DO blocks and ALTER TABLE statements?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux