Update of /cvsroot/monetdb/sql/src/sql
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv11294
Modified Files:
replicas.sql
Log Message:
Synchronisation commit.
U replicas.sql
Index: replicas.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/sql/replicas.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- replicas.sql 4 Sep 2009 20:37:12 -0000 1.3
+++ replicas.sql 5 Sep 2009 07:41:29 -0000 1.4
@@ -34,6 +34,14 @@
-- store for the master name.
CREATE TABLE sys.replicas(uri varchar(100) NOT NULL, tag int, stamp timestamp);
+-- Initialize this table with the location of the current system
+INSERT INTO sys.replicas VALUES( master(), 0, now());
+
+-- If your are the master return its uri. Otherwise locate the first master
+-- value in the replicas table.
+CREATE FUNCTION master() RETURNS string EXTERNAL NAME master.getName;
+
-- Controling the synchronisation by the slave
CREATE PROCEDURE master_start(uri string) EXTERNAL NAME master."start";
+CREATE PROCEDURE master_start(uri string, tag bigint) EXTERNAL NAME
master."start";
CREATE PROCEDURE master_stop(uri string) EXTERNAL NAME master."stop";
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
