Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement

[Philip Alger]

Hi Jian,


> doc said trigger name can not be schema-qualified,
> we can not do:
> CREATE TRIGGER public.modified_a BEFORE UPDATE OF a ON main_table
> FOR EACH ROW WHEN (OLD.a <> NEW.a) EXECUTE PROCEDURE
> trigger_func('modified_a');


That's correct. The function wouldn't produce that output though.

+ nameList = textToQualifiedNameList(trgName);
> + DeconstructQualifiedName(nameList, &schemaName, &objName);
>
> So the above ``textToQualifiedNameList(trgName);`` part is wrong?
>

I am handling quoted trigger names. Is that wrong?

-- 
Best,
Phil Alger