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 |
---|---|---|
Reports situations when you make SELECT from a function or a DBLINK without an alias with a type (for example, 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 | Warning |
Last modified: 13 May 2022