On 8/30/2004 11:20 AM, Christopher Browne wrote:

> Jan Wieck <JanWieck at Yahoo.com> writes:
>> On 8/29/2004 9:15 PM, Brian Hirt wrote:
>>
>>> i'm looking through the solnik commands, and i don't see an obvious
>>> way to remove a table from a set.
>>> do i have to drop the set, create a new set and subscribe it?
>>
>> You are right, this command is (still) missing. I was hoping that 
>> someone will find this annoying and actually sit down and get familiar 
>> with all the code pieces involved to implement it :-)
> 
> This should be a Simple Matter Of Programming based on how tables get
> subscribed/unsubscribed within the context of a subscription, right?
> 
> Thus, on each node, we do:
>   perform schemadoc.alterTableRestore(v_tab_row.tab_id);
>   perform schemadoc.tableDropKey(v_tab_row.tab_id);
>   delete from sl_table where id = tab_id;
> 
> I should see if I can do this one; there's a few more components to
> it, but it oughtn't be too bad:
> 
>  1.  Need to augment the grammar to know about "set drop table"
> 
>  2.  Need to have a C function for set_drop_table
> 
>  3.  Need a stored procedure, droptable(), which initiates the event
> 
>  4.  Need another stored procedure, droptable_int() which does the
>       alterTableRestore(), tableDropKey()
> 
>  5.  I presume (haven't looked) that slon needs to have a case
>       statement added to allow it to propagate the "DROP_TABLE" 
>       event.

That pretty much sums it up. See, see, someone already studied the code. 
Mission accomplished.

> 
> That doesn't look too terribly nasty, as little projects go.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #