tada / pljava

PL/Java is a free add-on module that brings Java™ Stored Procedures, Triggers, Functions, Aggregates, Operators, Types, etc., to the PostgreSQL™ backend.
http://tada.github.io/pljava/
Other
238 stars 77 forks source link

Fail validation if function declares `TRANSFORM FOR TYPE` #402

Closed jcflack closed 1 year ago

jcflack commented 2 years ago

PostgreSQL's TRANSFORM FOR TYPE mechanism is only meaningful for a PL whose handler function itself does the work of looking up and applying the transforms.

https://www.postgresql.org/message-id/61FDBCFE.3090800%40anastigmatix.net

It follows that a PL that doesn't apply transforms ought to say so when validating a function declaration that includes a TRANSFORM clause.

It would arguably be better to say so even earlier, at an attempted CREATE TRANSFORM that names the PL, but there is not currently a validator function applied at that time.

jcflack commented 1 year ago

Believed resolved in 1.6.5.