Doesn't work with psql meta-commands & plpgsql syntax?

markdrago / pgsanity

Check syntax of postgresql sql files

MIT License

316 stars 28 forks source link

Open bhaskar2khaneja opened 5 years ago

bhaskar2khaneja commented 5 years ago

Hi! Noticed the following two issues when using pgsanity:

pgsanity seems to throw an error on the first line in this SQL code:
```
\set start 1234
delete from x where y >= :start;
```

Also doesn't seem to catch syntax errors in plpgsql code block:

DO $zzz$
dsafdsf
BEGIN
update test set id=4 where city='def';
END
$zzz$ LANGUAGE plpgsql;

d2a-raudenaerde commented 5 years ago

Can confirm doesn't work inside code blocks. This is most unfortunate, as we are moving more and more to functions.