Andreas Pflug <pgadmin at pse-consulting.de> writes:

> Hannu Krosing wrote:
>
>>On E, 2005-10-03 at 16:47 +0000, Andreas Pflug wrote:
>>
>>
>>>When subscribing, I got the following error on the receiver slon:
>>>
>>>declare LOG cursor for select
>>>   log_origin,
>>>   from "_test".sl_log_1 where log_origin = 1 and ( order by log_actionseq;
>>>
>>>
>>
>>IIRC this happens when you subscribe a set with no tables/sequences in
>>it
>>
>>
>
> Correct. So either subscribing an empty set must be disabled, or that
> problem caught in slon. Seems I'll have to modify the event queue
> manually.

It's a bit harder than that...  One could use SET MOVE TABLE or SET
DROP TABLE to empty out a set.

But certainly adding an advisory notice that subscribing an empty set
is a bad idea would be a reasonable thing to do.

FYI, the problem is where there are no tables.  Having sequences
doesn't help :-(.
-- 
(format nil "~S@~S" "cbbrowne" "ca.afilias.info")
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)