JetBrains Rider 2023.2 Help

Code Inspections in PostgreSQL

This topic lists all JetBrains Rider code inspections available in PostgreSQL.

You can toggle specific inspections or change their severity level on the Editor | Inspection Settings | Inspection Severity | Other Languages page of the IDE settings Control+Alt+S.

Inspection

Description

Default Severity

Postgres: Select from procedure call

Reports situations when you make SELECT from a function or a DBLINK without an alias with a type (for example, AS t1(s VARCHAR)).

This requirement does not apply to scalar functions.

Example (PostgreSQL):

CREATE FUNCTION produce_a_table() RETURNS RECORD AS $$ SELECT 1; $$ LANGUAGE sql; SELECT * FROM produce_a_table() AS s (c1 INT); SELECT * FROM produce_a_table() AS s (c1); SELECT * FROM DBLINK('dbname=mydb', 'SELECT proname, prosrc FROM pg_proc') AS t1;

The AS s (c1 INT) has a typed alias, while AS s (c1) and AS t1 do not. In this case, the second call of produce_a_table() and DBLINK() will be highlighted.

Warning Warning

Last modified: 13 May 2022