On Mon, Nov 2, 2009 at 12:17 PM, Victor Mayevski <vit...@gmail.com> wrote: > Is it possible to implement triggers that fire up for each independent > session? For example, I am using TCL, define a function in TCL, > register it with SQLite, create a trigger to call that function every > time an update happens to some table. Well, it works just fine for > that specific open session. If I create another session using the > same database and the same setup, and insert some data into the table, > the trigger will only fire up for that session in which the update > happened, although technically, both sessions are using the same > database and the update happens to the same table. If it was possible > for the triggers to fire up in all sessions that are using the same > database, it would create yet another powerful utility like > inter-session communication/event notification etc.
Good lord! it would create an incredibly powerful mess. TRIGGERs, and all other SQL commands have to respect the boundaries and sanctity of the db connection, else there would be no data integrity. > > Thanks > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
