From aee065d518412d2163a5c4dabd6ca9d2e00f95ad Mon Sep 17 00:00:00 2001 From: Ian Jackson Date: Thu, 27 Aug 2009 15:54:49 +0100 Subject: [PATCH] Instructions for deleting black dye --- yarrg/devel-notes | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) diff --git a/yarrg/devel-notes b/yarrg/devel-notes index fef5adc..f4f6066 100644 --- a/yarrg/devel-notes +++ b/yarrg/devel-notes @@ -1,9 +1,28 @@ + +removing an obsolete commodity: + + select * from (select * from sell union select * from buy) left outer join commods using (commodid) where commods.commodname = 'Black dye' limit 10; + +if that produces no output then: + + begin; + delete from commods where commodname like 'Black dye'; + select * from (select * from sell union select * from buy) left outer join commods using (commodid) where commods.commodname is null limit 10; + +and if that produces no output then: + commit; +otherwise + rollback; + +======================================= + ceb's example route: alpha,byrne,papaya,turtle,jorvik,luthien example mixed arbitrage/trade xi,heph +======================================== To remedy bug fixed in 01c14767c024ac56686dbbfcd88d9f3a0b4b1574, did this: -- 2.30.2