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.
In response to
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2009-03-31 14:57:35|
|Subject: Re: [GENERAL] pgstattuple triggered checkpoint failure
and database outage?|
|Previous:||From: Greg Stark||Date: 2009-03-31 14:44:49|
|Subject: Re: string_to_array with empty input|