Included to_media into the checksum so users can post the same comment to

different articles.

diff --git a/dbscripts/dupetrigger/INSTALL b/dbscripts/dupetrigger/INSTALL
index e7687f7..331a3ed 100755 (executable)
--- a/dbscripts/dupetrigger/INSTALL
+++ b/dbscripts/dupetrigger/INSTALL
@@ -1,5 +1,10 @@
 To install the trigger do the following:
 
+# cp Makefile-dist Makefile
+
+# edit Makefile
+(and change pathnames and PGVERSION if neccessary).
+
 # make
 (This makes the trigger binary and places it in /tmp with permissions 644)
 

diff --git a/dbscripts/dupetrigger/dupetrigger.c b/dbscripts/dupetrigger/dupetrigger.c
index 201314b..d780bbd 100755 (executable)
--- a/dbscripts/dupetrigger/dupetrigger.c
+++ b/dbscripts/dupetrigger/dupetrigger.c
@@ -121,11 +121,11 @@ Datum dupecheck(void)
        int                     ret = 0, i, fnumber;
        long rowstrlen = 0,
                crc;
-       int maxitems = 3,
-               num;
+       int maxitems = 4;
        char *items[maxitems],
                *rowstring,
                *query;
+       int num;
        
        /* Make sure trigdata is pointing at what I expect */
 #ifdef PG70
@@ -160,6 +160,7 @@ Datum dupecheck(void)
        items[0] = SPI_getvalue(rettuple, tupdesc, SPI_fnumber(tupdesc, "creator"));
        items[1] = SPI_getvalue(rettuple, tupdesc, SPI_fnumber(tupdesc, "title"));
        items[2] = SPI_getvalue(rettuple, tupdesc, SPI_fnumber(tupdesc, "description"));
+       items[3] = SPI_getvalue(rettuple, tupdesc, SPI_fnumber(tupdesc, "to_media"));
 
        for (i=0; (i < maxitems); i++)
        {