Christopher Elkins wrote:
>
> > I'd like to resubmit this very simple patch-- I'm using hsql
> > in server mode and in order to run newapp.sh more than
> > once, I need the script to automatically delete pre-existing
> > tables. (Not a problem when running hsql in-memory)
> >
>
> I did not commit this patch previously because hSQL dies a cold, hard death if
> you call 'drop table foo' for a table that does not already exist. What we
> really need is 'drop table if exists foo', but hSQL does not support this
> syntax. :-(
>
> Any ideas for a workaround?
Is it possible to query for the existance of the table using a script or
small Java program before dropping the table?
--
Daniel Rall <[EMAIL PROTECTED]>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
