Nikhil Sontakke escribió: > > >> As triggers are executed in order of their names, we've prefixed the > > >> trigger names with "zz". This should work fine as long as no-one uses > > >> trigger-name which starts with "zz". > > > > this seems a lot fragile... why system generated triggers has to be > > executed following the same rules (talking about order of execution) > > as user triggers? can't we simply execute them first or last or maybe > > be clever and mark one to be executed first and others last? > > AFAICS, we do not have any category like system triggers. So yeah, it would > have been nice to generate triggers with names (starting with __ for > example) for such special triggers. But I don't think we disallow > user-triggers starting with underscores etc.
We already have system triggers -- the FK triggers. I don't think we've had all that much trouble with them. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
