Ng, > -----Original Message----- > From: ng [mailto:[email protected]] > Sent: Tuesday, September 18, 2012 4:24 PM > To: 'For discussion among Firebird Developers' > Subject: Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3925) Creating self- > referential FK crashes database (bug-check) whether constraint violation had > place > > hello > > we are using anonymous database triggers > > with the login / logout 1000 users fbserver memory is increasing to > aproximately 1476-1536K . > > > CREATE OR ALTER trigger DB_login_LOG > active on connect position 0 > as > declare variable ClAdr varchar(100); > declare variable ClPrg varchar(100); > declare variable SPrsId integer; > declare variable CPrsId integer; > begin > SELECT > MON$REMOTE_ADDRESS,mon$remote_process,mon$server_pid,d.mon$re > mote_pid > FROM MON$ATTACHMENTS D > WHERE mon$ATTACHMENT_ID = current_connection > Into :cladr, :clprg, :cprsid , :cprsid; > > -- insert into xx_xuserlog ....... > -- values ( current_connection,current_timestamp, ..... > when any do exit;
What does this have to do with the email subject. Do not hijack message threads. Please post a fresh message for a new subject/thread? Sean ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
