Re: [HACKERS] SQL Standard Feature T211
On 3/9/17 18:39, Kevin Grittner wrote: > With the addition of transition tables we have all four, although > I'm not sure whether the CREATE TRIGGER statement conforms closely > enough to claim the feature. The two basic issues I can think of > are: > - we don't allow the OLD and NEW transition variable names to be >specified -- using hard-coded values instead > - we don't support the standard formats, >instead supporting only our EXECUTE PROCEDURE syntax > > Do we leave T211, "Basic trigger capability" on our "unsupported" > list until those two points are addressed? Those seem pretty big ones. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] SQL Standard Feature T211
[separate thread from transition table patch, since a different audience might be interested] Four things are required to claim support for Feature T211, "Basic trigger capability": - support for the CREATE TRIGGER statement - the ability to declare and reference transition tables for AFTER triggers - support for the DROP TRIGGER statement - support for TRIGGER in the GRANT and REVOKE statements With the addition of transition tables we have all four, although I'm not sure whether the CREATE TRIGGER statement conforms closely enough to claim the feature. The two basic issues I can think of are: - we don't allow the OLD and NEW transition variable names to be specified -- using hard-coded values instead - we don't support the standard formats, instead supporting only our EXECUTE PROCEDURE syntax Do we leave T211, "Basic trigger capability" on our "unsupported" list until those two points are addressed? Does anyone know of anything else that would need to be done? -- Kevin Grittner -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers