thanks... after this query also it is showing default triggers ( am very much worried that how the system triggers are created using my username ....
ok i posted this in the group you specified.. On Tue, Mar 11, 2008 at 8:03 PM, Sergey Benner <[EMAIL PROTECTED]> wrote: > Again :) Try this query. > > > > select usename,relname, tgname, tgtype, proname, prosrc, tgisconstraint, > tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs, > tgattr, tgargs from (pg_trigger join pg_class c on tgrelid=c.oid ) > join pg_proc on (tgfoid=pg_proc.oid) join pg_user pu on > c.relowner=pu.usesysid where pu.usename='YOURUSERNAME'; > > > > Please post such questions to the [EMAIL PROTECTED] list. > > Cheers, > Sergey > >
