PostgreSQL parser doesn't check if a function exists

[maxhawkins]

-- name: F :exec
SELECT doesntexist();

Compiles using the experimental Postgres parser, but it shouldn't since the function does not exist.

[kyleconroy]

Now that #635 has been merged, we're closer to fixing this. One blocker is functions defined by extensions. I need to update the generation script to support all built-in extensions.

[kyleconroy]

I've made a first pass at adding extension functions (#640). I need to add support for all extensions that ship with PostgreSQL, and then I think we can turn this on.

[kyleconroy]

I've added all the functions from popular PostgreSQL extensions. The last step is to add a configuration option to turn this on. The other possibility would be to turn this on by default and let people turn it off. Not sure which option we should pick.

[maxhawkins]

Is it possible to activate when CREATE EXTENSION is called?

[kyleconroy]

This will be released in v1.12.0 behind the strict_function_checks configuration flag.

{
	"version": "1",
	"packages": [
		{
			"name": "querytest",
			"path": "go",
			"schema": "query.sql",
			"queries": "query.sql",
			"engine": "postgresql",
			"strict_function_checks": true
		}
	]
}