Re: drop column functionality

2006-08-20 Thread Bryan Pendleton
Tim Dudgeon wrote: 1. Should I apply the patch to the 10.1.3.1 sources (e.g. the db-derby-10.1.3.1-src.zip download) or something else? The patch is intended to be applied to the current trunk, which you can fetch from svn via svn checkout

drop column functionality

2006-08-19 Thread Tim Dudgeon
I'm looking to migrate an application to Derby as it appears to solve a number of performance issues I have with the current db. But it looks like there is no ALTER TABLE DROP COLUMN ... functionality. Is this really correct? If so, it's a complete show stopper for me as I need to dynamically

Re: drop column functionality

2006-08-19 Thread Bryan Pendleton
But it looks like there is no ALTER TABLE DROP COLUMN ... functionality. ... Is there an expectation for resolution? Hi Tim, Thanks for considering Derby; I think you will find it is very powerful. You are correct that ALTER TABLE DROP COLUMN is not currently present. However, as you've

Re: drop column functionality

2006-08-19 Thread Tim Dudgeon
Bryan Pendleton wrote: There are two open problems regarding that patch that I am still studying: - DROP COLUMN may not work properly if there are GRANTs on that column - DROP COLUMN may not work properly if there are VIEWs on that column Neither of those is an issue for me. My db is very