From 5f818fe0588657ae8a62d58d33a47412587809be Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Wed, 22 Apr 2009 17:13:31 +0300 Subject: [PATCH] pgq: some cleanups also remove silly co_name default. --- sql/pgq/functions/pgq.unregister_consumer.sql | 4 ++-- sql/pgq/structure/tables.sql | 3 +-- 2 files changed, 3 insertions(+), 4 deletions(-) diff --git a/sql/pgq/functions/pgq.unregister_consumer.sql b/sql/pgq/functions/pgq.unregister_consumer.sql index 17e83728..7132395a 100644 --- a/sql/pgq/functions/pgq.unregister_consumer.sql +++ b/sql/pgq/functions/pgq.unregister_consumer.sql @@ -6,8 +6,8 @@ returns integer as $$ -- ---------------------------------------------------------------------- -- Function: pgq.unregister_consumer(2) -- --- Unsubscriber consumer from the queue. Also consumer's failed --- and retry events are deleted. +-- Unsubscriber consumer from the queue. Also consumer's +-- retry events are deleted. -- -- Parameters: -- x_queue_name - Name of the queue diff --git a/sql/pgq/structure/tables.sql b/sql/pgq/structure/tables.sql index 521d1a9d..f649761b 100644 --- a/sql/pgq/structure/tables.sql +++ b/sql/pgq/structure/tables.sql @@ -8,7 +8,6 @@ -- pgq.tick - Per-queue snapshots (ticks) -- pgq.event_* - Data tables -- pgq.retry_queue - Events to be retried later --- pgq.failed_queue - Events whose processing failed -- -- Its basically generalized and simplified Slony-I structure: -- sl_node - pgq.consumer @@ -37,7 +36,7 @@ create schema pgq; -- ---------------------------------------------------------------------- create table pgq.consumer ( co_id serial, - co_name text not null default 'fooz', + co_name text not null, constraint consumer_pkey primary key (co_id), constraint consumer_name_uq UNIQUE (co_name) -- 2.39.5