src1=# SELECT pg_get_trigger_ddl(2, 'foo_trigger'); ERROR: trigger "foo_trigger" for table "(null)" does not exist src1=# SELECT pg_get_trigger_ddl(0, 'foo_trigger'); ERROR: trigger "foo_trigger" for table "(null)" does not exist
this error message is use facing, is the above error message what we expected?
Thank you for checking that. Short answer: no.
Please see v2. The latest version should take care of the (null) relation issue now, since it is checking if the OID exists for the table. I've included a test for that as well. It should return a clearer error if the relation does not exist.
