Re: [HACKERS] CREATE CONSTRAINT TRIGGER compatibility issue

2007-11-03 Thread Tom Lane
I wrote: > 4. Try to auto-update inside the backend. I don't have an exact > proposal for how this would work, but I'm thinking in terms of having > the conversion key off CREATE CONSTRAINT TRIGGER commands referencing > one of the built-in RI_FKey_xxx trigger functions. The tricky part here > is

[HACKERS] CREATE CONSTRAINT TRIGGER compatibility issue

2007-11-03 Thread Tom Lane
Back when we agreed that we should treat CREATE CONSTRAINT TRIGGER as a documented, non-deprecated user command, I made a change so that it would use the specified name as the actual name of the trigger in pg_trigger. Pre-8.3 releases would auto-generate sorta-unique names of the form "RI_Constrai