Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Indenting issue with Create Temporary Table statement #353

Open
Olamshin opened this issue Feb 28, 2025 · 0 comments
Open

Indenting issue with Create Temporary Table statement #353

Olamshin opened this issue Feb 28, 2025 · 0 comments

Comments

@Olamshin
Copy link

Version 5.5

CREATE OR REPLACE PROCEDURE do_something ()
LANGUAGE plpgsql
AS $$
DECLARE
    salt text;
BEGIN
    -- Create a temporary table
    CREATE TEMPORARY TABLE IF NOT EXISTS temp_id (
        id varchar
    ) ON COMMIT DELETE ROWS;
    TRUNCATE TABLE temp_id;
INSERT INTO temp_id
SELECT
    id
FROM
    jones;
END;
$$

The insert statement doesn't indent properly. Adding a comment before the insert statement resolves the issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant