Hi Dave, Good question - will you file a Jira on the missing Cleanup documentation or should I?
This raises a related larger question I've been thinking about for a while now - maintaining our documentation. Gunnar has done an amazing job at prepping what we already have so that we are incredibly well documented. I've used plenty of open source code over the years that isn't nearly as well documented as Trafodion. This is a real advantage for our users. So I think we need to consider how we'll keep our documentation and website up to date, and track our documentation changes along with related features and fixes. The person who's most expert on the documentation changes required is the person who generated the changes behind the pull request. Given that, should we default to something like, "a pull request for a Jira should include not only the software but also related documentation and website changes"? If the pull request doesn't include the documentation for some reason, could we either leave the Jira open or create a new one tracking the missing documentation? I think it's up to us to decide what guidelines we want to have, but we should be clear about them and our committers should be clear on what the expectations from contributors. Our documentation right now is a big advantage for our users, and we need to keep it that way. I know that I've walked away from open source code whose documentation was too hard to use, and we don't want Trafodion to have that barrier to entry.... Thoughts? -Carol P. --------------------------------------------------------------- Email: [email protected] Twitter: @CarolP222 --------------------------------------------------------------- On Mon, Mar 28, 2016 at 8:38 AM, Dave Birdsall <[email protected]> wrote: > Hi Pierre, > > The syntax is > > CLEANUP TABLE <tablename>; > > I just noticed that it's not documented in the Trafodion SQL Reference. Not > sure why. (I looked for it here: > > http://trafodion.apache.org/docs/1.3.0/sql_reference/index.html#data_definition_language_statements > ) > > We'll have to fix that. > > Dave > > -----Original Message----- > From: Pierre Smits [mailto:[email protected]] > Sent: Monday, March 28, 2016 5:59 AM > To: [email protected] > Subject: Cleanup Trafodion 1.3 Sandbox > > Hi all, > > I recently used the VirtualBox image provided by Amanda to establish a PoC. > > While performing a drop schema cascade some tables are not removed and thus > the execution fails. > > This is the message I get: > > GIFT_CARD has invalid state and cannot be accessed. Use cleanup command to > drop it. > > The question is: how do I execute the cleanup command (and from where)? > > > Best regards, > Pierre Smits > > ORRTIZ.COM <http://www.orrtiz.com> > OFBiz based solutions & services > > OFBiz Extensions Marketplace > http://oem.ofbizci.net/oci-2/ >
