X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fdupetrigger%2Fpostgresql.sript;fp=dbscripts%2Fdupetrigger%2Fpostgresql.sript;h=3879cf962732d270a025e6ca98fae9bc1beea7be;hb=b3132149d517abd59716bf4e157968f3a9e33582;hp=220016bebdba24418fd95be9f0b697b39960cd37;hpb=d7f3b64f7669225f5bff82dfdb0075ddb0638eae;p=mir.git diff --git a/dbscripts/dupetrigger/postgresql.sript b/dbscripts/dupetrigger/postgresql.sript index 220016be..3879cf96 100755 --- a/dbscripts/dupetrigger/postgresql.sript +++ b/dbscripts/dupetrigger/postgresql.sript @@ -2,6 +2,6 @@ DROP FUNCTION dupecheck(); DROP TRIGGER commdupetrigger ON comment; DROP TRIGGER contentdupetrigger ON content; -CREATE FUNCTION dupecheck() RETURNS OPAQUE AS '/pub/Dokumente/Indymedia/de-tech/Mir/src/dupetrigger.so' LANGUAGE 'C'; +CREATE FUNCTION dupecheck() RETURNS OPAQUE AS '/var/lib/postgres/data/dupetrigger.so' LANGUAGE 'C'; CREATE TRIGGER contentdupetrigger BEFORE INSERT OR UPDATE ON content FOR EACH ROW EXECUTE PROCEDURE dupecheck("no", "title", "subtitle", "creator", "description", "content_data"); CREATE TRIGGER commdupetrigger BEFORE INSERT OR UPDATE ON comment FOR EACH ROW EXECUTE PROCEDURE dupecheck("no", "creator", "to_media", "description", "title");