Re: Syntax checking DO blocks and ALTER TABLE statements?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Syntax checking DO blocks and ALTER TABLE statements?
Date: 2021-02-16 23:11:14
Message-ID: CAKFQuwYTyXCinTZfqjbm3uWR8gZQ-tssStxhAFFu3RQmSPUjDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 16, 2021 at 3:43 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

>
> How does one go about syntax checking this?
>
> (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.)
>
>
Begin a transaction, execute the DO, capture an error if there is one,
rollback the transaction.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Cross 2021-02-16 23:16:14 Re: Syntax checking DO blocks and ALTER TABLE statements?
Previous Message Ron 2021-02-16 22:42:56 Syntax checking DO blocks and ALTER TABLE statements?