X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fdupetrigger%2FREADME;fp=dbscripts%2Fdupetrigger%2FREADME;h=0000000000000000000000000000000000000000;hb=3a1b5c807cd4b49f7bb22a1b755be42220a4ae8f;hp=a506867e4df8c45590cf82e03173a9f262198340;hpb=60f1f87da66b4af8691510a0cb1006161cfd4d9f;p=mir.git diff --git a/dbscripts/dupetrigger/README b/dbscripts/dupetrigger/README deleted file mode 100755 index a506867e..00000000 --- a/dbscripts/dupetrigger/README +++ /dev/null @@ -1,16 +0,0 @@ -Dupe check Trigger -by Matthias "Trigger Hippy" Jordan - -The files in this directory are needed to create a PostgreSQL trigger that -is used to ensure that no comment and no article is posted twice. This -happens very often by accident and is very disturbing so we have to prevent -this somehow. Because Indymedia databases will hopefully grow big very fast, -we want to do this check as fast as possible. - -So Mir simply issues the INSERT. By this INSERT statement, a trigger gets, -well, triggered that calculates a CRC-32 checksum of the comment and -searches for rows with the same checksum. If it finds the checksum, the -INSERT gets aborted. If the checksum isn't found, it is appended to the row -and the INSERT is executed. - -The trigger works for INSERTs and UPDATEs.