diff db/pubsub.sql @ 295:bed30cef11a8

fixed bad queries in pubsub.sql file
author Goffi <goffi@goffi.org>
date Thu, 20 Aug 2015 14:06:49 +0200
parents df1edebb0466
children 05c875a13a62
line wrap: on
line diff
--- a/db/pubsub.sql	Sun Aug 16 01:32:42 2015 +0200
+++ b/db/pubsub.sql	Thu Aug 20 14:06:49 2015 +0200
@@ -16,9 +16,7 @@
     send_last_published_item text NOT NULL DEFAULT 'on_sub'
         CHECK (send_last_published_item IN ('never', 'on_sub')),
     publish_model text NOT NULL DEFAULT 'publishers'
-        CHECK (publish_model IN ('publishers', 'subscribers', 'open')),
-	UNIQUE (node, pep) WHERE pep IS NOT NULL,
-	UNIQUE (node) WHERE pep IS NULL
+        CHECK (publish_model IN ('publishers', 'subscribers', 'open'))
 );
 
 /* we need 2 partial indexes to manage NULL value for PEP */