PhpStorm 2021.2 Help

Code Inspections in PostgreSQL

This topic lists all PhpStorm code inspections available in PostgreSQL.

You can toggle specific inspections or change their severity level on the Editor | Inspections page of the IDE settings Ctrl+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: 16 July 2021