From sioutis@di.uoa.gr Wed Mar 30 12:30:11 2011
From: Michael Sioutis <sioutis@di.uoa.gr>
To: users-list@monetdb.org
Subject: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Wed, 30 Mar 2011 14:32:35 +0300
Message-ID: <AANLkTimh2=BTBRtG3gd3st1JdZjL4s2hLyKk4UbOuW-H@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6773717677548084160=="

--===============6773717677548084160==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

Hello,

I want to prevent an SQLException from occurring for tables that do not
exist in my database.
For example:
sql>DROP TABLE "locked";
SQLException:sql.catalog:DROP TABLE: no such table 'locked'

It seems (and is documented) that there is no such thing like "IF EXISTS" in
MonetDB.
Is there a way to circumvent the SQLException?

Mike



--===============6773717677548084160==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

SGVsbG8sPGRpdj48YnI+PC9kaXY+PGRpdj5JIHdhbnQgdG8gcHJldmVudCBhbiBTUUxFeGNlcHRp
b24gZnJvbaBvY2N1cnJpbmegZm9yIHRhYmxlcyB0aGF0IGRvIG5vdCBleGlzdCBpbiBteSBkYXRh
YmFzZS48L2Rpdj48ZGl2PkZvciBleGFtcGxlOjwvZGl2PjxkaXY+PGRpdj5zcWwmZ3Q7RFJPUCBU
QUJMRSAmcXVvdDtsb2NrZWQmcXVvdDs7PC9kaXY+PGRpdj5TUUxFeGNlcHRpb246c3FsLmNhdGFs
b2c6RFJPUCBUQUJMRTogbm8gc3VjaCB0YWJsZSAmIzM5O2xvY2tlZCYjMzk7PC9kaXY+CjwvZGl2
PjxkaXY+PGJyPjwvZGl2PjxkaXY+SXQgc2VlbXMgKGFuZCBpcyBkb2N1bWVudGVkKSB0aGF0IHRo
ZXJlIGlzIG5vIHN1Y2ggdGhpbmcgbGlrZSAmcXVvdDtJRiBFWElTVFMmcXVvdDsgaW4gTW9uZXRE
Qi48L2Rpdj48ZGl2PklzIHRoZXJlIGEgd2F5IHRvIGNpcmN1bXZlbnQgdGhlIFNRTEV4Y2VwdGlv
bj88L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pk1pa2U8L2Rpdj4K

--===============6773717677548084160==--