Deparse of CREATE TRIGGER … EXECUTE PROCEDURE gives statement with syntax error

[lwithers]

Hi,

If I try to parse and then de-parse the SQL:

CREATE TRIGGER tr AFTER INSERT ON rel FOR EACH ROW EXECUTE PROCEDURE p()

then I end up with the slightly different result:

CREATE TRIGGER tr AFTER INSERT ON rel FOR EACH ROW EXECUTE FUNCTION p()

Unfortunately, the latter is a syntax error:

postgres=# CREATE TRIGGER tr AFTER INSERT ON rel FOR EACH ROW EXECUTE FUNCTION p();
ERROR:  syntax error at or near "FUNCTION"
LINE 1: ...IGGER tr AFTER INSERT ON rel FOR EACH ROW EXECUTE FUNCTION p...

I have attached a reproducer: deparse_proc_func.go.gz

[lwithers]

Ah, and having raised the issue I discover this is due to a difference in PostgresQL 10 (which I am unfortunately still stuck with for another few months). In PostgresQL 11+, EXECUTE FUNCTION is accepted (and preferred) syntax.

I don't think there's anything for the project to do here, so closing.