Hi, I will extend the CREATE TRIGGER documentation:
" The trigger need to be created in the same schema as the table. The schema name does not need to be specified when creating the trigger. " Regards, Thomas On Wed, Sep 8, 2010 at 6:02 PM, Rami <[email protected]> wrote: > Hi, > > When creating a trigger in schema PUBLIC > > CREATE TRIGGER T1 AFTER UPDATE ON FOO.BAR FOR EACH ROW CALL "MyClass"; > > the trigger is created into schema FOO not PUBLIC. > Is this intentional? > Because unqualified objects usually are created in the "working schema" > (where user is at the time of creation). > If this is intentional for some reason then it should at least be > documented. > > - Rami > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
