> --- Ursprüngliche Nachricht --- > Von: "Anhaus, Thomas" <[EMAIL PROTECTED]> > An: "Andreas Goldstein" <[EMAIL PROTECTED]>, > <[email protected]> > Betreff: AW: [FSID] DOMAIN.TRIGGERS always empty!? > Datum: Thu, 13 Oct 2005 08:27:14 +0200 > > Andreas Goldstein wrote : > > > >Hi Listmembers, > > > >I am using MaxDB 7.6.00.12 on a Windows XP system. Although I > >have defined > >certain triggers on several tables the table DOMAIN.TRIGGERS > >is empty and no > >triggers are shown in the SQL Studio sidebar. > > > >(DBAdmin: SELECT COUNT(*) FROM DOMAIN.TRIGGERS => 0) > > > >Is it a bug or do I misunderstand the reference? I expected to > >find a list > >of triggers in that table. > > > >Regards > > > > DOMAIN.TRIGGERS should indeed describe all your triggers, unless your > current user is not owner of the trigger tables. > > Best Regards, > Thomas
Hi Thomas, I thought that too, but on my playground instance there are only two users (DBAdmin and MONA). Mona is the only Member of a usergroup called 'BENUTZER'. I used both Users two count the lines of DOMAIN.TRIGGERS and the result is 0 for both of them :( So I tried this: DROP TABLE WWIND.ZZZ // create table WWIND.ZZZ ( id FIXED(10) default serial primary key, txt char(10)) // CREATE TRIGGER IT_ZZZ FOR WWIND.ZZZ AFTER INSERT EXECUTE ( IF TXT <> TXT THEN STOP (42, 'You should not see that!'); ) // select count(*) from domain.triggers And the result is: 0 Strange - isn't it? Kind Regards -- Highspeed-Freiheit. Bei GMX supergünstig, z.B. GMX DSL_Cityflat, DSL-Flatrate für nur 4,99 Euro/Monat* http://www.gmx.net/de/go/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
