search

okbob / plpgsql_check

plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).
https://groups.google.com/forum/#!forum/postgresql-extensions-hacking
Other
641 stars 53 forks source link

Table pragma not working with tab chars #167

Closed awn70 closed 10 months ago

awn70 commented 10 months ago

Hi, I try to use the table pragma to create a temporary table. There seems to be a problem when the pragma code contains a tab char:

perform plpgsql_check_pragma( 'table: my_tmp( id bigint, <tab>partno varchar(21) )' );

With the tab char the temporary table is not present and I get an error: relation "my_tmp" does not exist

Regards Andreas

okbob commented 10 months ago

pá 5. 1. 2024 v 15:39 odesílatel awn70 @.***> napsal:

Hi, I try to use the table pragma to create a temporary table. There seems to be a problem when the pragma code contains a tab char:

perform plpgsql_check_pragma( 'table: my_tmp( id bigint, partno varchar(21) )' );

With the tab char the temporary table is not present and I get an error: relation "my_tmp" does not exist

This commit 5671953c9b8c9cf108f22644784dbbfdabbd144d should fix it.

Please check.

Regards

Regards Andreas

— Reply to this email directly, view it on GitHub https://github.com/okbob/plpgsql_check/issues/167, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEFO43CPLQRNN436RI7QS3YNAGDRAVCNFSM6AAAAABBOQXLM6VHI2DSMVQWIX3LMV43ASLTON2WKOZSGA3DONBWGI3DQMY . You are receiving this because you are subscribed to this thread.Message ID: @.***>

awn70 commented 10 months ago

Ok, works now. Thank you