From papito.dit@gmail.com Wed Mar 30 13:41:21 2011
From: Michael Sioutis <papito.dit@gmail.com>
To: users-list@monetdb.org
Subject: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Wed, 30 Mar 2011 16:41:15 +0300
Message-ID: <AANLkTinMB57VV0z_kmXL_4CbC09y08ENZFivjth7YnNw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2914225599634368851=="

--===============2914225599634368851==
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



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

PG1ldGEgaHR0cC1lcXVpdj0iY29udGVudC10eXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJz
ZXQ9dXRmLTgiPjxzcGFuIGNsYXNzPSJBcHBsZS1zdHlsZS1zcGFuIiBzdHlsZT0iYm9yZGVyLWNv
bGxhcHNlOiBjb2xsYXBzZTsgZm9udC1mYW1pbHk6IGFyaWFsLCBzYW5zLXNlcmlmOyBmb250LXNp
emU6IDEzcHg7ICI+SGVsbG8sPGRpdj48YnI+PC9kaXY+PGRpdj5JIHdhbnQgdG8gcHJldmVudCBh
biBTUUxFeGNlcHRpb24gZnJvbaBvY2N1cnJpbmegZm9yIHRhYmxlcyB0aGF0IGRvIG5vdCBleGlz
dCBpbiBteSBkYXRhYmFzZS48L2Rpdj4KPGRpdj5Gb3IgZXhhbXBsZTo8L2Rpdj48ZGl2PjxkaXY+
c3FsJmd0O0RST1AgVEFCTEUgJnF1b3Q7bG9ja2VkJnF1b3Q7OzwvZGl2PjxkaXY+U1FMRXhjZXB0
aW9uOnNxbC5jYXRhbG9nOkRST1AgVEFCTEU6IG5vIHN1Y2ggdGFibGUgJiMzOTtsb2NrZWQmIzM5
OzwvZGl2PjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+SXQgc2VlbXMgKGFuZCBpcyBkb2N1bWVu
dGVkKSB0aGF0IHRoZXJlIGlzIG5vIHN1Y2ggdGhpbmcgbGlrZSAmcXVvdDtJRiBFWElTVFMmcXVv
dDsgaW4gTW9uZXREQi48L2Rpdj4KPGRpdj5JcyB0aGVyZSBhIHdheSB0byBjaXJjdW12ZW50IHRo
ZSBTUUxFeGNlcHRpb24/PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5NaWtlPC9kaXY+PC9zcGFu
Pgo=

--===============2914225599634368851==--


From Fabian.Groffen@cwi.nl Wed Mar 30 13:47:53 2011
From: Fabian Groffen <Fabian.Groffen@cwi.nl>
To: users-list@monetdb.org
Subject: Re: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Wed, 30 Mar 2011 15:47:46 +0200
Message-ID: <20110330134746.GS90632@cwi.nl>
In-Reply-To: <AANLkTinMB57VV0z_kmXL_4CbC09y08ENZFivjth7YnNw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7449675726604006153=="

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

On 30-03-2011 16:41:15 +0300, Michael Sioutis wrote:
> 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?

no.

However, you could just check if the table exists by looking it up with
a query, if that helps you from your application.


--===============7449675726604006153==--


From Stefan.Manegold@cwi.nl Wed Mar 30 13:53:59 2011
From: Stefan.Manegold@cwi.nl
To: users-list@monetdb.org
Subject: Re: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Wed, 30 Mar 2011 15:53:51 +0200
Message-ID: <20110330135351.GA8228@cwi.nl>
In-Reply-To: <AANLkTinMB57VV0z_kmXL_4CbC09y08ENZFivjth7YnNw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6692003866364573140=="

--===============6692003866364573140==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Mike,

may I ask why you want to drop a table that does not exist?

Stefan

On Wed, Mar 30, 2011 at 04:41:15PM +0300, Michael Sioutis wrote:
> Hello,
>=20
> 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'
>=20
> It seems (and is documented) that there is no such thing like "IF EXISTS" in
> MonetDB.
> Is there a way to circumvent the SQLException?
>=20
> Mike

> ---------------------------------------------------------------------------=
---
> Enable your software for Intel(R) Active Management Technology to meet the
> growing manageability and security demands of your customers. Businesses
> are taking advantage of Intel(R) vPro (TM) technology - will your software =

> be a part of the solution? Download the Intel(R) Manageability Checker=20
> today! http://p.sf.net/sfu/intel-dev2devmar

> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users(a)lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users


--=20
| Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
| http://CWI.nl/~manegold/ | Science Park 123 (L321) |
| Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |


--===============6692003866364573140==--


From stefan@konink.de Wed Mar 30 13:56:38 2011
From: Stefan de Konink <stefan@konink.de>
To: users-list@monetdb.org
Subject: Re: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Wed, 30 Mar 2011 15:55:59 +0200
Message-ID: <7A2335BC-221C-4F21-A5E9-5301D50B79CE@konink.de>
In-Reply-To: <20110330135351.GA8228@cwi.nl>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7588863944088632011=="

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

Because somepeople have scripts that clean up, and dont want these  
parts to run outside a transaction?

Stefan

Op 30 mrt 2011 om 15:53 heeft Stefan.Manegold(a)cwi.nl het volgende  
geschreven:\

> Mike,
>
> may I ask why you want to drop a table that does not exist?
>
> Stefan
>
> On Wed, Mar 30, 2011 at 04:41:15PM +0300, Michael Sioutis wrote:
>> 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
>
>> --- 
>> --- 
>> --- 
>> ---------------------------------------------------------------------
>> Enable your software for Intel(R) Active Management Technology to  
>> meet the
>> growing manageability and security demands of your customers.  
>> Businesses
>> are taking advantage of Intel(R) vPro (TM) technology - will your  
>> software
>> be a part of the solution? Download the Intel(R) Manageability  
>> Checker
>> today! http://p.sf.net/sfu/intel-dev2devmar
>
>> _______________________________________________
>> MonetDB-users mailing list
>> MonetDB-users(a)lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
>
> -- 
> | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
> | http://CWI.nl/~manegold/ | Science Park 123 (L321) |
> | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |
>
> --- 
> --- 
> --- 
> ---------------------------------------------------------------------
> Enable your software for Intel(R) Active Management Technology to  
> meet the
> growing manageability and security demands of your customers.  
> Businesses
> are taking advantage of Intel(R) vPro (TM) technology - will your  
> software
> be a part of the solution? Download the Intel(R) Manageability Checker
> today! http://p.sf.net/sfu/intel-dev2devmar
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users(a)lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users


--===============7588863944088632011==--


From sioutis@di.uoa.gr Thu Mar 31 10:28:41 2011
From: Michael Sioutis <sioutis@di.uoa.gr>
To: users-list@monetdb.org
Subject: Re: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Thu, 31 Mar 2011 13:28:31 +0300
Message-ID: <AANLkTikcLLNqkWLH1XaOGozrBPaAuKbfe0a5OBv7kFXx@mail.gmail.com>
In-Reply-To: <7A2335BC-221C-4F21-A5E9-5301D50B79CE@konink.de>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============3083877938617065372=="

--===============3083877938617065372==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Well yes, actually I don't want to deal with an SQLException in my code.
Having an SQL query (SELECT name FROM tables WHERE name like
'table_I_want_to_drop';)
to see if the table is there as Fabian suggested and then move on to
dropping it if it
exists by checking the results of the query, works for me.

I was trying to find out if there is a single SQL query that would do that
like for example in Ms SQL, but reading a bit the documentation
of MonetDB I couldn't come up with sth.

Mike

On Wed, Mar 30, 2011 at 4:55 PM, Stefan de Konink <stefan(a)konink.de> wrote:

> Because somepeople have scripts that clean up, and dont want these
> parts to run outside a transaction?
>
> Stefan
>
> Op 30 mrt 2011 om 15:53 heeft Stefan.Manegold(a)cwi.nl het volgende
> geschreven:\
>
> > Mike,
> >
> > may I ask why you want to drop a table that does not exist?
> >
> > Stefan
> >
> > On Wed, Mar 30, 2011 at 04:41:15PM +0300, Michael Sioutis wrote:
> >> 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
> >
> >> ---
> >> ---
> >> ---
> >> ---------------------------------------------------------------------
> >> Enable your software for Intel(R) Active Management Technology to
> >> meet the
> >> growing manageability and security demands of your customers.
> >> Businesses
> >> are taking advantage of Intel(R) vPro (TM) technology - will your
> >> software
> >> be a part of the solution? Download the Intel(R) Manageability
> >> Checker
> >> today! http://p.sf.net/sfu/intel-dev2devmar
> >
> >> _______________________________________________
> >> MonetDB-users mailing list
> >> MonetDB-users(a)lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/monetdb-users
> >
> >
> > --
> > | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
> > | http://CWI.nl/~manegold/ | Science Park 123 (L321) |
> > | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |
> >
> > ---
> > ---
> > ---
> > ---------------------------------------------------------------------
> > Enable your software for Intel(R) Active Management Technology to
> > meet the
> > growing manageability and security demands of your customers.
> > Businesses
> > are taking advantage of Intel(R) vPro (TM) technology - will your
> > software
> > be a part of the solution? Download the Intel(R) Manageability Checker
> > today! http://p.sf.net/sfu/intel-dev2devmar
> > _______________________________________________
> > MonetDB-users mailing list
> > MonetDB-users(a)lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
>
> ---------------------------------------------------------------------------=
---
> Enable your software for Intel(R) Active Management Technology to meet the
> growing manageability and security demands of your customers. Businesses
> are taking advantage of Intel(R) vPro (TM) technology - will your software
> be a part of the solution? Download the Intel(R) Manageability Checker
> today! http://p.sf.net/sfu/intel-dev2devmar
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users(a)lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>



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

V2VsbCB5ZXMsIGFjdHVhbGx5IEkgZG9uJiMzOTt0IHdhbnQgdG8gZGVhbCB3aXRoIGFuIFNRTEV4
Y2VwdGlvbiBpbiBteSBjb2RlLqA8ZGl2PkhhdmluZyBhbiBTUUwgcXVlcnkgKFNFTEVDVCBuYW1l
IEZST00gdGFibGVzIFdIRVJFIG5hbWUgbGlrZSAmIzM5O3RhYmxlX0lfd2FudF90b19kcm9wJiMz
OTs7KaA8L2Rpdj48ZGl2PnRvIHNlZSBpZiB0aGUgdGFibGUgaXMgdGhlcmUgYXMgRmFiaWFuIHN1
Z2dlc3RlZCBhbmQgdGhlbiBtb3ZlIG9uIHRvIGRyb3BwaW5nIGl0IGlmIGl0PC9kaXY+CjxtZXRh
IGh0dHAtZXF1aXY9ImNvbnRlbnQtdHlwZSIgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0
Zi04Ij48ZGl2PmV4aXN0cyBieSBjaGVja2luZyB0aGUgcmVzdWx0cyBvZiB0aGUgcXVlcnksIHdv
cmtzIGZvciBtZS48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pkkgd2FzIHRyeWluZyB0byBmaW5k
IG91dCBpZiB0aGVyZSBpcyBhIHNpbmdsZSBTUUwgcXVlcnkgdGhhdCB3b3VsZCBkbyB0aGF0IGxp
a2UgZm9yIGV4YW1wbGUgaW4gTXMgU1FMLCBidXQgcmVhZGluZyBhIGJpdCB0aGUgZG9jdW1lbnRh
dGlvbjwvZGl2Pgo8ZGl2Pm9mIE1vbmV0REIgSSBjb3VsZG4mIzM5O3QgY29tZSB1cCB3aXRoIHN0
aC48L2Rpdj48ZGl2PqCgPC9kaXY+PGRpdj5NaWtlPGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9x
dW90ZSI+T24gV2VkLCBNYXIgMzAsIDIwMTEgYXQgNDo1NSBQTSwgU3RlZmFuIGRlIEtvbmluayA8
c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzpzdGVmYW5Aa29uaW5rLmRlIj5zdGVm
YW5Aa29uaW5rLmRlPC9hPiZndDs8L3NwYW4+IHdyb3RlOjxicj4KPGJsb2NrcXVvdGUgY2xhc3M9
ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjAgMCAwIC44ZXg7Ym9yZGVyLWxlZnQ6MXB4ICNj
Y2Mgc29saWQ7cGFkZGluZy1sZWZ0OjFleDsiPkJlY2F1c2Ugc29tZXBlb3BsZSBoYXZlIHNjcmlw
dHMgdGhhdCBjbGVhbiB1cCwgYW5kIGRvbnQgd2FudCB0aGVzZTxicj4KcGFydHMgdG8gcnVuIG91
dHNpZGUgYSB0cmFuc2FjdGlvbj88YnI+Cjxicj4KU3RlZmFuPGJyPgo8YnI+Ck9wIDMwIG1ydCAy
MDExIG9tIDE1OjUzIGhlZWZ0IDxhIGhyZWY9Im1haWx0bzpTdGVmYW4uTWFuZWdvbGRAY3dpLm5s
Ij5TdGVmYW4uTWFuZWdvbGRAY3dpLm5sPC9hPiBoZXQgdm9sZ2VuZGU8YnI+Cmdlc2NocmV2ZW46
XDxicj4KPGRpdj48ZGl2PjwvZGl2PjxkaXYgY2xhc3M9Img1Ij48YnI+CiZndDsgTWlrZSw8YnI+
CiZndDs8YnI+CiZndDsgbWF5IEkgYXNrIHdoeSB5b3Ugd2FudCB0byBkcm9wIGEgdGFibGUgdGhh
dCBkb2VzIG5vdCBleGlzdD88YnI+CiZndDs8YnI+CiZndDsgU3RlZmFuPGJyPgomZ3Q7PGJyPgom
Z3Q7IE9uIFdlZCwgTWFyIDMwLCAyMDExIGF0IDA0OjQxOjE1UE0gKzAzMDAsIE1pY2hhZWwgU2lv
dXRpcyB3cm90ZTo8YnI+CiZndDsmZ3Q7IEhlbGxvLDxicj4KJmd0OyZndDs8YnI+CiZndDsmZ3Q7
IEkgd2FudCB0byBwcmV2ZW50IGFuIFNRTEV4Y2VwdGlvbiBmcm9tIG9jY3VycmluZyBmb3IgdGFi
bGVzIHRoYXQgZG88YnI+CiZndDsmZ3Q7IG5vdDxicj4KJmd0OyZndDsgZXhpc3QgaW4gbXkgZGF0
YWJhc2UuPGJyPgomZ3Q7Jmd0OyBGb3IgZXhhbXBsZTo8YnI+CiZndDsmZ3Q7IHNxbCZndDtEUk9Q
IFRBQkxFICZxdW90O2xvY2tlZCZxdW90Ozs8YnI+CiZndDsmZ3Q7IFNRTEV4Y2VwdGlvbjpzcWwu
Y2F0YWxvZzpEUk9QIFRBQkxFOiBubyBzdWNoIHRhYmxlICYjMzk7bG9ja2VkJiMzOTs8YnI+CiZn
dDsmZ3Q7PGJyPgomZ3Q7Jmd0OyBJdCBzZWVtcyAoYW5kIGlzIGRvY3VtZW50ZWQpIHRoYXQgdGhl
cmUgaXMgbm8gc3VjaCB0aGluZyBsaWtlICZxdW90O0lGPGJyPgomZ3Q7Jmd0OyBFWElTVFMmcXVv
dDsgaW48YnI+CiZndDsmZ3Q7IE1vbmV0REIuPGJyPgomZ3Q7Jmd0OyBJcyB0aGVyZSBhIHdheSB0
byBjaXJjdW12ZW50IHRoZSBTUUxFeGNlcHRpb24/PGJyPgomZ3Q7Jmd0Ozxicj4KJmd0OyZndDsg
TWlrZTxicj4KJmd0Ozxicj4KJmd0OyZndDsgLS0tPGJyPgomZ3Q7Jmd0OyAtLS08YnI+CiZndDsm
Z3Q7IC0tLTxicj4KJmd0OyZndDsgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPGJyPgomZ3Q7Jmd0OyBFbmFibGUgeW91
ciBzb2Z0d2FyZSBmb3IgSW50ZWwoUikgQWN0aXZlIE1hbmFnZW1lbnQgVGVjaG5vbG9neSB0bzxi
cj4KJmd0OyZndDsgbWVldCB0aGU8YnI+CiZndDsmZ3Q7IGdyb3dpbmcgbWFuYWdlYWJpbGl0eSBh
bmQgc2VjdXJpdHkgZGVtYW5kcyBvZiB5b3VyIGN1c3RvbWVycy48YnI+CiZndDsmZ3Q7IEJ1c2lu
ZXNzZXM8YnI+CiZndDsmZ3Q7IGFyZSB0YWtpbmcgYWR2YW50YWdlIG9mIEludGVsKFIpIHZQcm8g
KFRNKSB0ZWNobm9sb2d5IC0gd2lsbCB5b3VyPGJyPgomZ3Q7Jmd0OyBzb2Z0d2FyZTxicj4KJmd0
OyZndDsgYmUgYSBwYXJ0IG9mIHRoZSBzb2x1dGlvbj8gRG93bmxvYWQgdGhlIEludGVsKFIpIE1h
bmFnZWFiaWxpdHk8YnI+CiZndDsmZ3Q7IENoZWNrZXI8YnI+CiZndDsmZ3Q7IHRvZGF5ISA8YSBo
cmVmPSJodHRwOi8vcC5zZi5uZXQvc2Z1L2ludGVsLWRldjJkZXZtYXIiIHRhcmdldD0iX2JsYW5r
Ij5odHRwOi8vcC5zZi5uZXQvc2Z1L2ludGVsLWRldjJkZXZtYXI8L2E+PGJyPgomZ3Q7PGJyPgom
Z3Q7Jmd0OyBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzxi
cj4KJmd0OyZndDsgTW9uZXREQi11c2VycyBtYWlsaW5nIGxpc3Q8YnI+CiZndDsmZ3Q7IDxhIGhy
ZWY9Im1haWx0bzpNb25ldERCLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmdlLm5ldCI+TW9uZXREQi11
c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQ8L2E+PGJyPgomZ3Q7Jmd0OyA8YSBocmVmPSJodHRw
czovL2xpc3RzLnNvdXJjZWZvcmdlLm5ldC9saXN0cy9saXN0aW5mby9tb25ldGRiLXVzZXJzIiB0
YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGlu
Zm8vbW9uZXRkYi11c2VyczwvYT48YnI+CiZndDs8YnI+CiZndDs8YnI+CiZndDsgLS08YnI+CiZn
dDsgfCBTdGVmYW4uTWFuZWdvbGQgQCBDV0kubmwgfCBEQiBBcmNoaXRlY3R1cmVzIChJTlMxKSB8
PGJyPgomZ3Q7IHwgPGEgaHJlZj0iaHR0cDovL0NXSS5ubC9+bWFuZWdvbGQvIiB0YXJnZXQ9Il9i
bGFuayI+aHR0cDovL0NXSS5ubC9+bWFuZWdvbGQvPC9hPiB8IFNjaWVuY2UgUGFyayAxMjMgKEwz
MjEpIHw8YnI+CiZndDsgfCBUZWwuOiArMzEgKDApMjAgNTkyLTQyMTIgfCAxMDk4IFhHIEFtc3Rl
cmRhbSCgKE5MKSB8PGJyPgomZ3Q7PGJyPgomZ3Q7IC0tLTxicj4KJmd0OyAtLS08YnI+CiZndDsg
LS0tPGJyPgomZ3Q7IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTxicj4KJmd0OyBFbmFibGUgeW91ciBzb2Z0d2FyZSBm
b3IgSW50ZWwoUikgQWN0aXZlIE1hbmFnZW1lbnQgVGVjaG5vbG9neSB0bzxicj4KJmd0OyBtZWV0
IHRoZTxicj4KJmd0OyBncm93aW5nIG1hbmFnZWFiaWxpdHkgYW5kIHNlY3VyaXR5IGRlbWFuZHMg
b2YgeW91ciBjdXN0b21lcnMuPGJyPgomZ3Q7IEJ1c2luZXNzZXM8YnI+CiZndDsgYXJlIHRha2lu
ZyBhZHZhbnRhZ2Ugb2YgSW50ZWwoUikgdlBybyAoVE0pIHRlY2hub2xvZ3kgLSB3aWxsIHlvdXI8
YnI+CiZndDsgc29mdHdhcmU8YnI+CiZndDsgYmUgYSBwYXJ0IG9mIHRoZSBzb2x1dGlvbj8gRG93
bmxvYWQgdGhlIEludGVsKFIpIE1hbmFnZWFiaWxpdHkgQ2hlY2tlcjxicj4KJmd0OyB0b2RheSEg
PGEgaHJlZj0iaHR0cDovL3Auc2YubmV0L3NmdS9pbnRlbC1kZXYyZGV2bWFyIiB0YXJnZXQ9Il9i
bGFuayI+aHR0cDovL3Auc2YubmV0L3NmdS9pbnRlbC1kZXYyZGV2bWFyPC9hPjxicj4KJmd0OyBf
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzxicj4KJmd0OyBN
b25ldERCLXVzZXJzIG1haWxpbmcgbGlzdDxicj4KJmd0OyA8YSBocmVmPSJtYWlsdG86TW9uZXRE
Qi11c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQiPk1vbmV0REItdXNlcnNAbGlzdHMuc291cmNl
Zm9yZ2UubmV0PC9hPjxicj4KJmd0OyA8YSBocmVmPSJodHRwczovL2xpc3RzLnNvdXJjZWZvcmdl
Lm5ldC9saXN0cy9saXN0aW5mby9tb25ldGRiLXVzZXJzIiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6
Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vbW9uZXRkYi11c2VyczwvYT48
YnI+Cjxicj4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPGJyPgpFbmFibGUgeW91ciBzb2Z0d2FyZSBm
b3IgSW50ZWwoUikgQWN0aXZlIE1hbmFnZW1lbnQgVGVjaG5vbG9neSB0byBtZWV0IHRoZTxicj4K
Z3Jvd2luZyBtYW5hZ2VhYmlsaXR5IGFuZCBzZWN1cml0eSBkZW1hbmRzIG9mIHlvdXIgY3VzdG9t
ZXJzLiBCdXNpbmVzc2VzPGJyPgphcmUgdGFraW5nIGFkdmFudGFnZSBvZiBJbnRlbChSKSB2UHJv
IChUTSkgdGVjaG5vbG9neSAtIHdpbGwgeW91ciBzb2Z0d2FyZTxicj4KYmUgYSBwYXJ0IG9mIHRo
ZSBzb2x1dGlvbj8gRG93bmxvYWQgdGhlIEludGVsKFIpIE1hbmFnZWFiaWxpdHkgQ2hlY2tlcjxi
cj4KdG9kYXkhIDxhIGhyZWY9Imh0dHA6Ly9wLnNmLm5ldC9zZnUvaW50ZWwtZGV2MmRldm1hciIg
dGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly9wLnNmLm5ldC9zZnUvaW50ZWwtZGV2MmRldm1hcjwvYT48
YnI+Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fPGJyPgpN
b25ldERCLXVzZXJzIG1haWxpbmcgbGlzdDxicj4KPGEgaHJlZj0ibWFpbHRvOk1vbmV0REItdXNl
cnNAbGlzdHMuc291cmNlZm9yZ2UubmV0Ij5Nb25ldERCLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmdl
Lm5ldDwvYT48YnI+CjxhIGhyZWY9Imh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xpc3Rz
L2xpc3RpbmZvL21vbmV0ZGItdXNlcnMiIHRhcmdldD0iX2JsYW5rIj5odHRwczovL2xpc3RzLnNv
dXJjZWZvcmdlLm5ldC9saXN0cy9saXN0aW5mby9tb25ldGRiLXVzZXJzPC9hPjxicj4KPC9kaXY+
PC9kaXY+PC9ibG9ja3F1b3RlPjwvZGl2Pjxicj48L2Rpdj4K

--===============3083877938617065372==--


From papito.dit@gmail.com Thu Mar 31 10:29:03 2011
From: Michael Sioutis <papito.dit@gmail.com>
To: users-list@monetdb.org
Subject: Re: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Thu, 31 Mar 2011 13:28:57 +0300
Message-ID: <AANLkTim_-jeZq6YFgbbu3hNZDTKbMYEFqObY_KB8tfS5@mail.gmail.com>
In-Reply-To: <7A2335BC-221C-4F21-A5E9-5301D50B79CE@konink.de>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============6141888896170290065=="

--===============6141888896170290065==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Well yes, actually I don't want to deal with an SQLException in my code.
Having an SQL query (SELECT name FROM tables WHERE name like
'table_I_want_to_drop';)
to see if the table is there as Fabian suggested and then move on to
dropping it if it
exists by checking the results of the query, works for me.

I was trying to find out if there is a single SQL query that would do that
like for example in Ms SQL, but reading a bit the documentation
of MonetDB I couldn't come up with sth.

Mike

On Wed, Mar 30, 2011 at 4:55 PM, Stefan de Konink <stefan(a)konink.de> wrote:

> Because somepeople have scripts that clean up, and dont want these
> parts to run outside a transaction?
>
> Stefan
>
> Op 30 mrt 2011 om 15:53 heeft Stefan.Manegold(a)cwi.nl het volgende
> geschreven:\
>
> > Mike,
> >
> > may I ask why you want to drop a table that does not exist?
> >
> > Stefan
> >
> > On Wed, Mar 30, 2011 at 04:41:15PM +0300, Michael Sioutis wrote:
> >> 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
> >
> >> ---
> >> ---
> >> ---
> >> ---------------------------------------------------------------------
> >> Enable your software for Intel(R) Active Management Technology to
> >> meet the
> >> growing manageability and security demands of your customers.
> >> Businesses
> >> are taking advantage of Intel(R) vPro (TM) technology - will your
> >> software
> >> be a part of the solution? Download the Intel(R) Manageability
> >> Checker
> >> today! http://p.sf.net/sfu/intel-dev2devmar
> >
> >> _______________________________________________
> >> MonetDB-users mailing list
> >> MonetDB-users(a)lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/monetdb-users
> >
> >
> > --
> > | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
> > | http://CWI.nl/~manegold/ | Science Park 123 (L321) |
> > | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |
> >
> > ---
> > ---
> > ---
> > ---------------------------------------------------------------------
> > Enable your software for Intel(R) Active Management Technology to
> > meet the
> > growing manageability and security demands of your customers.
> > Businesses
> > are taking advantage of Intel(R) vPro (TM) technology - will your
> > software
> > be a part of the solution? Download the Intel(R) Manageability Checker
> > today! http://p.sf.net/sfu/intel-dev2devmar
> > _______________________________________________
> > MonetDB-users mailing list
> > MonetDB-users(a)lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
>
> ---------------------------------------------------------------------------=
---
> Enable your software for Intel(R) Active Management Technology to meet the
> growing manageability and security demands of your customers. Businesses
> are taking advantage of Intel(R) vPro (TM) technology - will your software
> be a part of the solution? Download the Intel(R) Manageability Checker
> today! http://p.sf.net/sfu/intel-dev2devmar
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users(a)lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>



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

PG1ldGEgaHR0cC1lcXVpdj0iY29udGVudC10eXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJz
ZXQ9dXRmLTgiPjxzcGFuIGNsYXNzPSJBcHBsZS1zdHlsZS1zcGFuIiBzdHlsZT0iYm9yZGVyLWNv
bGxhcHNlOiBjb2xsYXBzZTsgZm9udC1mYW1pbHk6IGFyaWFsLCBzYW5zLXNlcmlmOyBmb250LXNp
emU6IDEzcHg7ICI+V2VsbCB5ZXMsIGFjdHVhbGx5IEkgZG9uJiMzOTt0IHdhbnQgdG8gZGVhbCB3
aXRoIGFuIFNRTEV4Y2VwdGlvbiBpbiBteSBjb2RlLqA8ZGl2PgpIYXZpbmcgYW4gU1FMIHF1ZXJ5
IChTRUxFQ1QgbmFtZSBGUk9NIHRhYmxlcyBXSEVSRSBuYW1lIGxpa2UgJiMzOTt0YWJsZV9JX3dh
bnRfdG9fZHJvcCYjMzk7OymgPC9kaXY+PGRpdj50byBzZWUgaWYgdGhlIHRhYmxlIGlzIHRoZXJl
IGFzIEZhYmlhbiBzdWdnZXN0ZWQgYW5kIHRoZW4gbW92ZSBvbiB0byBkcm9wcGluZyBpdCBpZiBp
dDwvZGl2PjxkaXY+ZXhpc3RzIGJ5IGNoZWNraW5nIHRoZSByZXN1bHRzIG9mIHRoZSBxdWVyeSwg
d29ya3MgZm9yIG1lLjwvZGl2Pgo8ZGl2Pjxicj48L2Rpdj48ZGl2Pkkgd2FzIHRyeWluZyB0byBm
aW5kIG91dCBpZiB0aGVyZSBpcyBhIHNpbmdsZSBTUUwgcXVlcnkgdGhhdCB3b3VsZCBkbyB0aGF0
IGxpa2UgZm9yIGV4YW1wbGUgaW4gTXMgU1FMLCBidXQgcmVhZGluZyBhIGJpdCB0aGUgZG9jdW1l
bnRhdGlvbjwvZGl2PjxkaXY+b2YgTW9uZXREQiBJIGNvdWxkbiYjMzk7dCBjb21lIHVwIHdpdGgg
c3RoLjwvZGl2PjxkaXY+CqCgPC9kaXY+PGRpdj5NaWtlPC9kaXY+PC9zcGFuPjxicj48ZGl2IGNs
YXNzPSJnbWFpbF9xdW90ZSI+T24gV2VkLCBNYXIgMzAsIDIwMTEgYXQgNDo1NSBQTSwgU3RlZmFu
IGRlIEtvbmluayA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzpzdGVmYW5Aa29u
aW5rLmRlIj5zdGVmYW5Aa29uaW5rLmRlPC9hPiZndDs8L3NwYW4+IHdyb3RlOjxicj48YmxvY2tx
dW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MCAwIDAgLjhleDtib3JkZXIt
bGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4OyI+CkJlY2F1c2Ugc29tZXBlb3Bs
ZSBoYXZlIHNjcmlwdHMgdGhhdCBjbGVhbiB1cCwgYW5kIGRvbnQgd2FudCB0aGVzZTxicj4KcGFy
dHMgdG8gcnVuIG91dHNpZGUgYSB0cmFuc2FjdGlvbj88YnI+Cjxicj4KU3RlZmFuPGJyPgo8YnI+
Ck9wIDMwIG1ydCAyMDExIG9tIDE1OjUzIGhlZWZ0IDxhIGhyZWY9Im1haWx0bzpTdGVmYW4uTWFu
ZWdvbGRAY3dpLm5sIj5TdGVmYW4uTWFuZWdvbGRAY3dpLm5sPC9hPiBoZXQgdm9sZ2VuZGU8YnI+
Cmdlc2NocmV2ZW46XDxicj4KPGRpdj48ZGl2PjwvZGl2PjxkaXYgY2xhc3M9Img1Ij48YnI+CiZn
dDsgTWlrZSw8YnI+CiZndDs8YnI+CiZndDsgbWF5IEkgYXNrIHdoeSB5b3Ugd2FudCB0byBkcm9w
IGEgdGFibGUgdGhhdCBkb2VzIG5vdCBleGlzdD88YnI+CiZndDs8YnI+CiZndDsgU3RlZmFuPGJy
PgomZ3Q7PGJyPgomZ3Q7IE9uIFdlZCwgTWFyIDMwLCAyMDExIGF0IDA0OjQxOjE1UE0gKzAzMDAs
IE1pY2hhZWwgU2lvdXRpcyB3cm90ZTo8YnI+CiZndDsmZ3Q7IEhlbGxvLDxicj4KJmd0OyZndDs8
YnI+CiZndDsmZ3Q7IEkgd2FudCB0byBwcmV2ZW50IGFuIFNRTEV4Y2VwdGlvbiBmcm9tIG9jY3Vy
cmluZyBmb3IgdGFibGVzIHRoYXQgZG88YnI+CiZndDsmZ3Q7IG5vdDxicj4KJmd0OyZndDsgZXhp
c3QgaW4gbXkgZGF0YWJhc2UuPGJyPgomZ3Q7Jmd0OyBGb3IgZXhhbXBsZTo8YnI+CiZndDsmZ3Q7
IHNxbCZndDtEUk9QIFRBQkxFICZxdW90O2xvY2tlZCZxdW90Ozs8YnI+CiZndDsmZ3Q7IFNRTEV4
Y2VwdGlvbjpzcWwuY2F0YWxvZzpEUk9QIFRBQkxFOiBubyBzdWNoIHRhYmxlICYjMzk7bG9ja2Vk
JiMzOTs8YnI+CiZndDsmZ3Q7PGJyPgomZ3Q7Jmd0OyBJdCBzZWVtcyAoYW5kIGlzIGRvY3VtZW50
ZWQpIHRoYXQgdGhlcmUgaXMgbm8gc3VjaCB0aGluZyBsaWtlICZxdW90O0lGPGJyPgomZ3Q7Jmd0
OyBFWElTVFMmcXVvdDsgaW48YnI+CiZndDsmZ3Q7IE1vbmV0REIuPGJyPgomZ3Q7Jmd0OyBJcyB0
aGVyZSBhIHdheSB0byBjaXJjdW12ZW50IHRoZSBTUUxFeGNlcHRpb24/PGJyPgomZ3Q7Jmd0Ozxi
cj4KJmd0OyZndDsgTWlrZTxicj4KJmd0Ozxicj4KJmd0OyZndDsgLS0tPGJyPgomZ3Q7Jmd0OyAt
LS08YnI+CiZndDsmZ3Q7IC0tLTxicj4KJmd0OyZndDsgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPGJyPgomZ3Q7Jmd0
OyBFbmFibGUgeW91ciBzb2Z0d2FyZSBmb3IgSW50ZWwoUikgQWN0aXZlIE1hbmFnZW1lbnQgVGVj
aG5vbG9neSB0bzxicj4KJmd0OyZndDsgbWVldCB0aGU8YnI+CiZndDsmZ3Q7IGdyb3dpbmcgbWFu
YWdlYWJpbGl0eSBhbmQgc2VjdXJpdHkgZGVtYW5kcyBvZiB5b3VyIGN1c3RvbWVycy48YnI+CiZn
dDsmZ3Q7IEJ1c2luZXNzZXM8YnI+CiZndDsmZ3Q7IGFyZSB0YWtpbmcgYWR2YW50YWdlIG9mIElu
dGVsKFIpIHZQcm8gKFRNKSB0ZWNobm9sb2d5IC0gd2lsbCB5b3VyPGJyPgomZ3Q7Jmd0OyBzb2Z0
d2FyZTxicj4KJmd0OyZndDsgYmUgYSBwYXJ0IG9mIHRoZSBzb2x1dGlvbj8gRG93bmxvYWQgdGhl
IEludGVsKFIpIE1hbmFnZWFiaWxpdHk8YnI+CiZndDsmZ3Q7IENoZWNrZXI8YnI+CiZndDsmZ3Q7
IHRvZGF5ISA8YSBocmVmPSJodHRwOi8vcC5zZi5uZXQvc2Z1L2ludGVsLWRldjJkZXZtYXIiIHRh
cmdldD0iX2JsYW5rIj5odHRwOi8vcC5zZi5uZXQvc2Z1L2ludGVsLWRldjJkZXZtYXI8L2E+PGJy
PgomZ3Q7PGJyPgomZ3Q7Jmd0OyBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fXzxicj4KJmd0OyZndDsgTW9uZXREQi11c2VycyBtYWlsaW5nIGxpc3Q8YnI+CiZn
dDsmZ3Q7IDxhIGhyZWY9Im1haWx0bzpNb25ldERCLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmdlLm5l
dCI+TW9uZXREQi11c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQ8L2E+PGJyPgomZ3Q7Jmd0OyA8
YSBocmVmPSJodHRwczovL2xpc3RzLnNvdXJjZWZvcmdlLm5ldC9saXN0cy9saXN0aW5mby9tb25l
dGRiLXVzZXJzIiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQv
bGlzdHMvbGlzdGluZm8vbW9uZXRkYi11c2VyczwvYT48YnI+CiZndDs8YnI+CiZndDs8YnI+CiZn
dDsgLS08YnI+CiZndDsgfCBTdGVmYW4uTWFuZWdvbGQgQCBDV0kubmwgfCBEQiBBcmNoaXRlY3R1
cmVzIChJTlMxKSB8PGJyPgomZ3Q7IHwgPGEgaHJlZj0iaHR0cDovL0NXSS5ubC9+bWFuZWdvbGQv
IiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL0NXSS5ubC9+bWFuZWdvbGQvPC9hPiB8IFNjaWVuY2Ug
UGFyayAxMjMgKEwzMjEpIHw8YnI+CiZndDsgfCBUZWwuOiArMzEgKDApMjAgNTkyLTQyMTIgfCAx
MDk4IFhHIEFtc3RlcmRhbSCgKE5MKSB8PGJyPgomZ3Q7PGJyPgomZ3Q7IC0tLTxicj4KJmd0OyAt
LS08YnI+CiZndDsgLS0tPGJyPgomZ3Q7IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTxicj4KJmd0OyBFbmFibGUgeW91
ciBzb2Z0d2FyZSBmb3IgSW50ZWwoUikgQWN0aXZlIE1hbmFnZW1lbnQgVGVjaG5vbG9neSB0bzxi
cj4KJmd0OyBtZWV0IHRoZTxicj4KJmd0OyBncm93aW5nIG1hbmFnZWFiaWxpdHkgYW5kIHNlY3Vy
aXR5IGRlbWFuZHMgb2YgeW91ciBjdXN0b21lcnMuPGJyPgomZ3Q7IEJ1c2luZXNzZXM8YnI+CiZn
dDsgYXJlIHRha2luZyBhZHZhbnRhZ2Ugb2YgSW50ZWwoUikgdlBybyAoVE0pIHRlY2hub2xvZ3kg
LSB3aWxsIHlvdXI8YnI+CiZndDsgc29mdHdhcmU8YnI+CiZndDsgYmUgYSBwYXJ0IG9mIHRoZSBz
b2x1dGlvbj8gRG93bmxvYWQgdGhlIEludGVsKFIpIE1hbmFnZWFiaWxpdHkgQ2hlY2tlcjxicj4K
Jmd0OyB0b2RheSEgPGEgaHJlZj0iaHR0cDovL3Auc2YubmV0L3NmdS9pbnRlbC1kZXYyZGV2bWFy
IiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL3Auc2YubmV0L3NmdS9pbnRlbC1kZXYyZGV2bWFyPC9h
Pjxicj4KJmd0OyBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
Xzxicj4KJmd0OyBNb25ldERCLXVzZXJzIG1haWxpbmcgbGlzdDxicj4KJmd0OyA8YSBocmVmPSJt
YWlsdG86TW9uZXREQi11c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQiPk1vbmV0REItdXNlcnNA
bGlzdHMuc291cmNlZm9yZ2UubmV0PC9hPjxicj4KJmd0OyA8YSBocmVmPSJodHRwczovL2xpc3Rz
LnNvdXJjZWZvcmdlLm5ldC9saXN0cy9saXN0aW5mby9tb25ldGRiLXVzZXJzIiB0YXJnZXQ9Il9i
bGFuayI+aHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vbW9uZXRk
Yi11c2VyczwvYT48YnI+Cjxicj4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPGJyPgpFbmFibGUgeW91
ciBzb2Z0d2FyZSBmb3IgSW50ZWwoUikgQWN0aXZlIE1hbmFnZW1lbnQgVGVjaG5vbG9neSB0byBt
ZWV0IHRoZTxicj4KZ3Jvd2luZyBtYW5hZ2VhYmlsaXR5IGFuZCBzZWN1cml0eSBkZW1hbmRzIG9m
IHlvdXIgY3VzdG9tZXJzLiBCdXNpbmVzc2VzPGJyPgphcmUgdGFraW5nIGFkdmFudGFnZSBvZiBJ
bnRlbChSKSB2UHJvIChUTSkgdGVjaG5vbG9neSAtIHdpbGwgeW91ciBzb2Z0d2FyZTxicj4KYmUg
YSBwYXJ0IG9mIHRoZSBzb2x1dGlvbj8gRG93bmxvYWQgdGhlIEludGVsKFIpIE1hbmFnZWFiaWxp
dHkgQ2hlY2tlcjxicj4KdG9kYXkhIDxhIGhyZWY9Imh0dHA6Ly9wLnNmLm5ldC9zZnUvaW50ZWwt
ZGV2MmRldm1hciIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly9wLnNmLm5ldC9zZnUvaW50ZWwtZGV2
MmRldm1hcjwvYT48YnI+Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fPGJyPgpNb25ldERCLXVzZXJzIG1haWxpbmcgbGlzdDxicj4KPGEgaHJlZj0ibWFpbHRv
Ok1vbmV0REItdXNlcnNAbGlzdHMuc291cmNlZm9yZ2UubmV0Ij5Nb25ldERCLXVzZXJzQGxpc3Rz
LnNvdXJjZWZvcmdlLm5ldDwvYT48YnI+CjxhIGhyZWY9Imh0dHBzOi8vbGlzdHMuc291cmNlZm9y
Z2UubmV0L2xpc3RzL2xpc3RpbmZvL21vbmV0ZGItdXNlcnMiIHRhcmdldD0iX2JsYW5rIj5odHRw
czovL2xpc3RzLnNvdXJjZWZvcmdlLm5ldC9saXN0cy9saXN0aW5mby9tb25ldGRiLXVzZXJzPC9h
Pjxicj4KPC9kaXY+PC9kaXY+PC9ibG9ja3F1b3RlPjwvZGl2Pjxicj4K

--===============6141888896170290065==--


From Stefan.Manegold@cwi.nl Thu Mar 31 11:06:08 2011
From: Stefan.Manegold@cwi.nl
To: users-list@monetdb.org
Subject: Re: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Thu, 31 Mar 2011 13:05:59 +0200
Message-ID: <20110331110559.GA30956@cwi.nl>
In-Reply-To: <AANLkTim_-jeZq6YFgbbu3hNZDTKbMYEFqObY_KB8tfS5@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7866662934418490556=="

--===============7866662934418490556==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Mar 31, 2011 at 01:28:57PM +0300, Michael Sioutis wrote:
> Well yes, actually I don't want to deal with an SQLException in my code.
> Having an SQL query (SELECT name FROM tables WHERE name like
> 'table_I_want_to_drop';)
> to see if the table is there as Fabian suggested and then move on to
> dropping it if it
> exists by checking the results of the query, works for me.

Good. ;-)

> I was trying to find out if there is a single SQL query that would do that
> like for example in Ms SQL, but reading a bit the documentation
> of MonetDB I couldn't come up with sth.

What does such a Ms SQL query look like?
And is that SQL:2003 standard or a proprietary Ms SQL extensions?

Stefan

> Mike
>=20
> On Wed, Mar 30, 2011 at 4:55 PM, Stefan de Konink <stefan(a)konink.de> wrot=
e:
>=20
> > Because somepeople have scripts that clean up, and dont want these
> > parts to run outside a transaction?
> >
> > Stefan
> >
> > Op 30 mrt 2011 om 15:53 heeft Stefan.Manegold(a)cwi.nl het volgende
> > geschreven:\
> >
> > > Mike,
> > >
> > > may I ask why you want to drop a table that does not exist?
> > >
> > > Stefan
> > >
> > > On Wed, Mar 30, 2011 at 04:41:15PM +0300, Michael Sioutis wrote:
> > >> 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
> > >
> > >> ---
> > >> ---
> > >> ---
> > >> ---------------------------------------------------------------------
> > >> Enable your software for Intel(R) Active Management Technology to
> > >> meet the
> > >> growing manageability and security demands of your customers.
> > >> Businesses
> > >> are taking advantage of Intel(R) vPro (TM) technology - will your
> > >> software
> > >> be a part of the solution? Download the Intel(R) Manageability
> > >> Checker
> > >> today! http://p.sf.net/sfu/intel-dev2devmar
> > >
> > >> _______________________________________________
> > >> MonetDB-users mailing list
> > >> MonetDB-users(a)lists.sourceforge.net
> > >> https://lists.sourceforge.net/lists/listinfo/monetdb-users
> > >
> > >
> > > --
> > > | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
> > > | http://CWI.nl/~manegold/ | Science Park 123 (L321) |
> > > | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |
> > >
> > > ---
> > > ---
> > > ---
> > > ---------------------------------------------------------------------
> > > Enable your software for Intel(R) Active Management Technology to
> > > meet the
> > > growing manageability and security demands of your customers.
> > > Businesses
> > > are taking advantage of Intel(R) vPro (TM) technology - will your
> > > software
> > > be a part of the solution? Download the Intel(R) Manageability Checker
> > > today! http://p.sf.net/sfu/intel-dev2devmar
> > > _______________________________________________
> > > MonetDB-users mailing list
> > > MonetDB-users(a)lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/monetdb-users
> >
> >
> > -------------------------------------------------------------------------=
-----
> > Enable your software for Intel(R) Active Management Technology to meet the
> > growing manageability and security demands of your customers. Businesses
> > are taking advantage of Intel(R) vPro (TM) technology - will your software
> > be a part of the solution? Download the Intel(R) Manageability Checker
> > today! http://p.sf.net/sfu/intel-dev2devmar
> > _______________________________________________
> > MonetDB-users mailing list
> > MonetDB-users(a)lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/monetdb-users
> >

> ---------------------------------------------------------------------------=
---
> Create and publish websites with WebMatrix
> Use the most popular FREE web apps or write code yourself;=20
> WebMatrix provides all the features you need to develop and=20
> publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users(a)lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users


--=20
| Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
| http://CWI.nl/~manegold/ | Science Park 123 (L321) |
| Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |


--===============7866662934418490556==--


From Fabian.Groffen@cwi.nl Thu Mar 31 11:10:26 2011
From: Fabian Groffen <Fabian.Groffen@cwi.nl>
To: users-list@monetdb.org
Subject: Re: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Thu, 31 Mar 2011 13:08:39 +0200
Message-ID: <20110331110839.GT887@cwi.nl>
In-Reply-To: <20110331110559.GA30956@cwi.nl>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7097644262111484163=="

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

On 31-03-2011 13:05:59 +0200, Stefan.Manegold(a)cwi.nl wrote:
> On Thu, Mar 31, 2011 at 01:28:57PM +0300, Michael Sioutis wrote:
> > Well yes, actually I don't want to deal with an SQLException in my code.
> > Having an SQL query (SELECT name FROM tables WHERE name like
> > 'table_I_want_to_drop';)
> > to see if the table is there as Fabian suggested and then move on to
> > dropping it if it
> > exists by checking the results of the query, works for me.
> 
> Good. ;-)
> 
> > I was trying to find out if there is a single SQL query that would do that
> > like for example in Ms SQL, but reading a bit the documentation
> > of MonetDB I couldn't come up with sth.
> 
> What does such a Ms SQL query look like?
> And is that SQL:2003 standard or a proprietary Ms SQL extensions?

Extension, like MySQL's "IF EXISTS" clause at the end of the query.


--===============7097644262111484163==--


From papito.dit@gmail.com Thu Mar 31 11:39:45 2011
From: Michael Sioutis <papito.dit@gmail.com>
To: users-list@monetdb.org
Subject: Re: [MonetDB-users] DROP TABLE IF EXISTS <table>;
Date: Thu, 31 Mar 2011 14:39:38 +0300
Message-ID: <AANLkTi=9yR=frbt3eTYwAiTveWU28EeoAub_4EZdPivV@mail.gmail.com>
In-Reply-To: <20110331110559.GA30956@cwi.nl>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1804765087794203727=="

--===============1804765087794203727==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

I stumbled upon this on google:
IF EXISTS(SELECT 1 FROM sys.objects WHERE OBJECT_ID =3D
OBJECT_ID(N'table_to_drop') AND type =3D (N'U'))
DROP TABLE table_to_drop

I believe it's an extension.

Mike

On Thu, Mar 31, 2011 at 2:05 PM, <Stefan.Manegold(a)cwi.nl> wrote:

> On Thu, Mar 31, 2011 at 01:28:57PM +0300, Michael Sioutis wrote:
> > Well yes, actually I don't want to deal with an SQLException in my code.
> > Having an SQL query (SELECT name FROM tables WHERE name like
> > 'table_I_want_to_drop';)
> > to see if the table is there as Fabian suggested and then move on to
> > dropping it if it
> > exists by checking the results of the query, works for me.
>
> Good. ;-)
>
> > I was trying to find out if there is a single SQL query that would do
> that
> > like for example in Ms SQL, but reading a bit the documentation
> > of MonetDB I couldn't come up with sth.
>
> What does such a Ms SQL query look like?
> And is that SQL:2003 standard or a proprietary Ms SQL extensions?
>
> Stefan
>
> > Mike
> >
> > On Wed, Mar 30, 2011 at 4:55 PM, Stefan de Konink <stefan(a)konink.de>
> wrote:
> >
> > > Because somepeople have scripts that clean up, and dont want these
> > > parts to run outside a transaction?
> > >
> > > Stefan
> > >
> > > Op 30 mrt 2011 om 15:53 heeft Stefan.Manegold(a)cwi.nl het volgende
> > > geschreven:\
> > >
> > > > Mike,
> > > >
> > > > may I ask why you want to drop a table that does not exist?
> > > >
> > > > Stefan
> > > >
> > > > On Wed, Mar 30, 2011 at 04:41:15PM +0300, Michael Sioutis wrote:
> > > >> 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
> > > >
> > > >> ---
> > > >> ---
> > > >> ---
> > > >>
> ---------------------------------------------------------------------
> > > >> Enable your software for Intel(R) Active Management Technology to
> > > >> meet the
> > > >> growing manageability and security demands of your customers.
> > > >> Businesses
> > > >> are taking advantage of Intel(R) vPro (TM) technology - will your
> > > >> software
> > > >> be a part of the solution? Download the Intel(R) Manageability
> > > >> Checker
> > > >> today! http://p.sf.net/sfu/intel-dev2devmar
> > > >
> > > >> _______________________________________________
> > > >> MonetDB-users mailing list
> > > >> MonetDB-users(a)lists.sourceforge.net
> > > >> https://lists.sourceforge.net/lists/listinfo/monetdb-users
> > > >
> > > >
> > > > --
> > > > | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
> > > > | http://CWI.nl/~manegold/ | Science Park 123 (L321) |
> > > > | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |
> > > >
> > > > ---
> > > > ---
> > > > ---
> > > > ---------------------------------------------------------------------
> > > > Enable your software for Intel(R) Active Management Technology to
> > > > meet the
> > > > growing manageability and security demands of your customers.
> > > > Businesses
> > > > are taking advantage of Intel(R) vPro (TM) technology - will your
> > > > software
> > > > be a part of the solution? Download the Intel(R) Manageability
> Checker
> > > > today! http://p.sf.net/sfu/intel-dev2devmar
> > > > _______________________________________________
> > > > MonetDB-users mailing list
> > > > MonetDB-users(a)lists.sourceforge.net
> > > > https://lists.sourceforge.net/lists/listinfo/monetdb-users
> > >
> > >
> > >
> ---------------------------------------------------------------------------=
---
> > > Enable your software for Intel(R) Active Management Technology to meet
> the
> > > growing manageability and security demands of your customers.
> Businesses
> > > are taking advantage of Intel(R) vPro (TM) technology - will your
> software
> > > be a part of the solution? Download the Intel(R) Manageability Checker
> > > today! http://p.sf.net/sfu/intel-dev2devmar
> > > _______________________________________________
> > > MonetDB-users mailing list
> > > MonetDB-users(a)lists.sourceforge.net
> > > https://lists.sourceforge.net/lists/listinfo/monetdb-users
> > >
>
> >
> ---------------------------------------------------------------------------=
---
> > Create and publish websites with WebMatrix
> > Use the most popular FREE web apps or write code yourself;
> > WebMatrix provides all the features you need to develop and
> > publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
>
> > _______________________________________________
> > MonetDB-users mailing list
> > MonetDB-users(a)lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
>
> --
> | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
> | http://CWI.nl/~manegold/ | Science Park 123 (L321) |
> | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam  (NL) |
>
>
> ---------------------------------------------------------------------------=
---
> Create and publish websites with WebMatrix
> Use the most popular FREE web apps or write code yourself;
> WebMatrix provides all the features you need to develop and
> publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users(a)lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>



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

PG1ldGEgaHR0cC1lcXVpdj0iY29udGVudC10eXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJz
ZXQ9dXRmLTgiPjxzcGFuIGNsYXNzPSJBcHBsZS1zdHlsZS1zcGFuIiBzdHlsZT0iZm9udC1mYW1p
bHk6IEFyaWFsLCBIZWx2ZXRpY2EsIHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogMTNweDsgIj48ZGl2
PjxzcGFuIGNsYXNzPSJBcHBsZS1zdHlsZS1zcGFuIiBzdHlsZT0iZm9udC1mYW1pbHk6IEFyaWFs
LCBIZWx2ZXRpY2EsIHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogMTNweDsgIj5JIHN0dW1ibGVkIHVw
b24gdGhpcyBvbiBnb29nbGU6PC9zcGFuPjwvZGl2PgpJRiBFWElTVFMoU0VMRUNUIDEgRlJPTSBz
eXMub2JqZWN0cyBXSEVSRSBPQkpFQ1RfSUQgPSBPQkpFQ1RfSUQoTiYjMzk7dGFibGVfdG9fZHJv
cCYjMzk7KSBBTkQgdHlwZSA9IChOJiMzOTtVJiMzOTspKTxicj5EUk9QIFRBQkxFIHRhYmxlX3Rv
X2Ryb3A8L3NwYW4+PGRpdj48Zm9udCBjbGFzcz0iQXBwbGUtc3R5bGUtc3BhbiIgZmFjZT0iQXJp
YWwsIEhlbHZldGljYSwgc2Fucy1zZXJpZiI+PGJyPgo8L2ZvbnQ+PC9kaXY+PGRpdj48Zm9udCBj
bGFzcz0iQXBwbGUtc3R5bGUtc3BhbiIgZmFjZT0iQXJpYWwsIEhlbHZldGljYSwgc2Fucy1zZXJp
ZiI+SSBiZWxpZXZlIGl0JiMzOTtzIGFuIGV4dGVuc2lvbi48YnI+PC9mb250PjxkaXY+PGZvbnQg
Y2xhc3M9IkFwcGxlLXN0eWxlLXNwYW4iIGZhY2U9IkFyaWFsLCBIZWx2ZXRpY2EsIHNhbnMtc2Vy
aWYiPjxicj48L2ZvbnQ+PC9kaXY+PGRpdj4KPGZvbnQgY2xhc3M9IkFwcGxlLXN0eWxlLXNwYW4i
IGZhY2U9IkFyaWFsLCBIZWx2ZXRpY2EsIHNhbnMtc2VyaWYiPk1pa2U8L2ZvbnQ+PGRpdj48YnI+
PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPk9uIFRodSwgTWFyIDMxLCAyMDExIGF0IDI6MDUgUE0s
ICA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzpTdGVmYW4uTWFuZWdvbGRAY3dp
Lm5sIj5TdGVmYW4uTWFuZWdvbGRAY3dpLm5sPC9hPiZndDs8L3NwYW4+IHdyb3RlOjxicj4KPGJs
b2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjAgMCAwIC44ZXg7Ym9y
ZGVyLWxlZnQ6MXB4ICNjY2Mgc29saWQ7cGFkZGluZy1sZWZ0OjFleDsiPjxkaXYgY2xhc3M9Imlt
Ij5PbiBUaHUsIE1hciAzMSwgMjAxMSBhdCAwMToyODo1N1BNICswMzAwLCBNaWNoYWVsIFNpb3V0
aXMgd3JvdGU6PGJyPgomZ3Q7IFdlbGwgeWVzLCBhY3R1YWxseSBJIGRvbiYjMzk7dCB3YW50IHRv
IGRlYWwgd2l0aCBhbiBTUUxFeGNlcHRpb24gaW4gbXkgY29kZS48YnI+CiZndDsgSGF2aW5nIGFu
IFNRTCBxdWVyeSAoU0VMRUNUIG5hbWUgRlJPTSB0YWJsZXMgV0hFUkUgbmFtZSBsaWtlPGJyPgom
Z3Q7ICYjMzk7dGFibGVfSV93YW50X3RvX2Ryb3AmIzM5OzspPGJyPgomZ3Q7IHRvIHNlZSBpZiB0
aGUgdGFibGUgaXMgdGhlcmUgYXMgRmFiaWFuIHN1Z2dlc3RlZCBhbmQgdGhlbiBtb3ZlIG9uIHRv
PGJyPgomZ3Q7IGRyb3BwaW5nIGl0IGlmIGl0PGJyPgomZ3Q7IGV4aXN0cyBieSBjaGVja2luZyB0
aGUgcmVzdWx0cyBvZiB0aGUgcXVlcnksIHdvcmtzIGZvciBtZS48YnI+Cjxicj4KPC9kaXY+R29v
ZC4gOy0pPGJyPgo8ZGl2IGNsYXNzPSJpbSI+PGJyPgomZ3Q7IEkgd2FzIHRyeWluZyB0byBmaW5k
IG91dCBpZiB0aGVyZSBpcyBhIHNpbmdsZSBTUUwgcXVlcnkgdGhhdCB3b3VsZCBkbyB0aGF0PGJy
PgomZ3Q7IGxpa2UgZm9yIGV4YW1wbGUgaW4gTXMgU1FMLCBidXQgcmVhZGluZyBhIGJpdCB0aGUg
ZG9jdW1lbnRhdGlvbjxicj4KJmd0OyBvZiBNb25ldERCIEkgY291bGRuJiMzOTt0IGNvbWUgdXAg
d2l0aCBzdGguPGJyPgo8YnI+CjwvZGl2PldoYXQgZG9lcyBzdWNoIGEgTXMgU1FMIHF1ZXJ5IGxv
b2sgbGlrZT88YnI+CkFuZCBpcyB0aGF0IFNRTDoyMDAzIHN0YW5kYXJkIG9yIGEgcHJvcHJpZXRh
cnkgTXMgU1FMIGV4dGVuc2lvbnM/PGJyPgo8YnI+ClN0ZWZhbjxicj4KPGRpdj48ZGl2PjwvZGl2
PjxkaXYgY2xhc3M9Img1Ij48YnI+CiZndDsgTWlrZTxicj4KJmd0Ozxicj4KJmd0OyBPbiBXZWQs
IE1hciAzMCwgMjAxMSBhdCA0OjU1IFBNLCBTdGVmYW4gZGUgS29uaW5rICZsdDs8YSBocmVmPSJt
YWlsdG86c3RlZmFuQGtvbmluay5kZSI+c3RlZmFuQGtvbmluay5kZTwvYT4mZ3Q7IHdyb3RlOjxi
cj4KJmd0Ozxicj4KJmd0OyAmZ3Q7IEJlY2F1c2Ugc29tZXBlb3BsZSBoYXZlIHNjcmlwdHMgdGhh
dCBjbGVhbiB1cCwgYW5kIGRvbnQgd2FudCB0aGVzZTxicj4KJmd0OyAmZ3Q7IHBhcnRzIHRvIHJ1
biBvdXRzaWRlIGEgdHJhbnNhY3Rpb24/PGJyPgomZ3Q7ICZndDs8YnI+CiZndDsgJmd0OyBTdGVm
YW48YnI+CiZndDsgJmd0Ozxicj4KJmd0OyAmZ3Q7IE9wIDMwIG1ydCAyMDExIG9tIDE1OjUzIGhl
ZWZ0IDxhIGhyZWY9Im1haWx0bzpTdGVmYW4uTWFuZWdvbGRAY3dpLm5sIj5TdGVmYW4uTWFuZWdv
bGRAY3dpLm5sPC9hPiBoZXQgdm9sZ2VuZGU8YnI+CiZndDsgJmd0OyBnZXNjaHJldmVuOlw8YnI+
CiZndDsgJmd0Ozxicj4KJmd0OyAmZ3Q7ICZndDsgTWlrZSw8YnI+CiZndDsgJmd0OyAmZ3Q7PGJy
PgomZ3Q7ICZndDsgJmd0OyBtYXkgSSBhc2sgd2h5IHlvdSB3YW50IHRvIGRyb3AgYSB0YWJsZSB0
aGF0IGRvZXMgbm90IGV4aXN0Pzxicj4KJmd0OyAmZ3Q7ICZndDs8YnI+CiZndDsgJmd0OyAmZ3Q7
IFN0ZWZhbjxicj4KJmd0OyAmZ3Q7ICZndDs8YnI+CiZndDsgJmd0OyAmZ3Q7IE9uIFdlZCwgTWFy
IDMwLCAyMDExIGF0IDA0OjQxOjE1UE0gKzAzMDAsIE1pY2hhZWwgU2lvdXRpcyB3cm90ZTo8YnI+
CiZndDsgJmd0OyAmZ3Q7Jmd0OyBIZWxsbyw8YnI+CiZndDsgJmd0OyAmZ3Q7Jmd0Ozxicj4KJmd0
OyAmZ3Q7ICZndDsmZ3Q7IEkgd2FudCB0byBwcmV2ZW50IGFuIFNRTEV4Y2VwdGlvbiBmcm9tIG9j
Y3VycmluZyBmb3IgdGFibGVzIHRoYXQgZG88YnI+CiZndDsgJmd0OyAmZ3Q7Jmd0OyBub3Q8YnI+
CiZndDsgJmd0OyAmZ3Q7Jmd0OyBleGlzdCBpbiBteSBkYXRhYmFzZS48YnI+CiZndDsgJmd0OyAm
Z3Q7Jmd0OyBGb3IgZXhhbXBsZTo8YnI+CiZndDsgJmd0OyAmZ3Q7Jmd0OyBzcWwmZ3Q7RFJPUCBU
QUJMRSAmcXVvdDtsb2NrZWQmcXVvdDs7PGJyPgomZ3Q7ICZndDsgJmd0OyZndDsgU1FMRXhjZXB0
aW9uOnNxbC5jYXRhbG9nOkRST1AgVEFCTEU6IG5vIHN1Y2ggdGFibGUgJiMzOTtsb2NrZWQmIzM5
Ozxicj4KJmd0OyAmZ3Q7ICZndDsmZ3Q7PGJyPgomZ3Q7ICZndDsgJmd0OyZndDsgSXQgc2VlbXMg
KGFuZCBpcyBkb2N1bWVudGVkKSB0aGF0IHRoZXJlIGlzIG5vIHN1Y2ggdGhpbmcgbGlrZSAmcXVv
dDtJRjxicj4KJmd0OyAmZ3Q7ICZndDsmZ3Q7IEVYSVNUUyZxdW90OyBpbjxicj4KJmd0OyAmZ3Q7
ICZndDsmZ3Q7IE1vbmV0REIuPGJyPgomZ3Q7ICZndDsgJmd0OyZndDsgSXMgdGhlcmUgYSB3YXkg
dG8gY2lyY3VtdmVudCB0aGUgU1FMRXhjZXB0aW9uPzxicj4KJmd0OyAmZ3Q7ICZndDsmZ3Q7PGJy
PgomZ3Q7ICZndDsgJmd0OyZndDsgTWlrZTxicj4KJmd0OyAmZ3Q7ICZndDs8YnI+CiZndDsgJmd0
OyAmZ3Q7Jmd0OyAtLS08YnI+CiZndDsgJmd0OyAmZ3Q7Jmd0OyAtLS08YnI+CiZndDsgJmd0OyAm
Z3Q7Jmd0OyAtLS08YnI+CiZndDsgJmd0OyAmZ3Q7Jmd0OyAtLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08YnI+CiZndDsg
Jmd0OyAmZ3Q7Jmd0OyBFbmFibGUgeW91ciBzb2Z0d2FyZSBmb3IgSW50ZWwoUikgQWN0aXZlIE1h
bmFnZW1lbnQgVGVjaG5vbG9neSB0bzxicj4KJmd0OyAmZ3Q7ICZndDsmZ3Q7IG1lZXQgdGhlPGJy
PgomZ3Q7ICZndDsgJmd0OyZndDsgZ3Jvd2luZyBtYW5hZ2VhYmlsaXR5IGFuZCBzZWN1cml0eSBk
ZW1hbmRzIG9mIHlvdXIgY3VzdG9tZXJzLjxicj4KJmd0OyAmZ3Q7ICZndDsmZ3Q7IEJ1c2luZXNz
ZXM8YnI+CiZndDsgJmd0OyAmZ3Q7Jmd0OyBhcmUgdGFraW5nIGFkdmFudGFnZSBvZiBJbnRlbChS
KSB2UHJvIChUTSkgdGVjaG5vbG9neSAtIHdpbGwgeW91cjxicj4KJmd0OyAmZ3Q7ICZndDsmZ3Q7
IHNvZnR3YXJlPGJyPgomZ3Q7ICZndDsgJmd0OyZndDsgYmUgYSBwYXJ0IG9mIHRoZSBzb2x1dGlv
bj8gRG93bmxvYWQgdGhlIEludGVsKFIpIE1hbmFnZWFiaWxpdHk8YnI+CiZndDsgJmd0OyAmZ3Q7
Jmd0OyBDaGVja2VyPGJyPgomZ3Q7ICZndDsgJmd0OyZndDsgdG9kYXkhIDxhIGhyZWY9Imh0dHA6
Ly9wLnNmLm5ldC9zZnUvaW50ZWwtZGV2MmRldm1hciIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly9w
LnNmLm5ldC9zZnUvaW50ZWwtZGV2MmRldm1hcjwvYT48YnI+CiZndDsgJmd0OyAmZ3Q7PGJyPgom
Z3Q7ICZndDsgJmd0OyZndDsgX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX188YnI+CiZndDsgJmd0OyAmZ3Q7Jmd0OyBNb25ldERCLXVzZXJzIG1haWxpbmcgbGlz
dDxicj4KJmd0OyAmZ3Q7ICZndDsmZ3Q7IDxhIGhyZWY9Im1haWx0bzpNb25ldERCLXVzZXJzQGxp
c3RzLnNvdXJjZWZvcmdlLm5ldCI+TW9uZXREQi11c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQ8
L2E+PGJyPgomZ3Q7ICZndDsgJmd0OyZndDsgPGEgaHJlZj0iaHR0cHM6Ly9saXN0cy5zb3VyY2Vm
b3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vbW9uZXRkYi11c2VycyIgdGFyZ2V0PSJfYmxhbmsiPmh0
dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xpc3RzL2xpc3RpbmZvL21vbmV0ZGItdXNlcnM8
L2E+PGJyPgomZ3Q7ICZndDsgJmd0Ozxicj4KJmd0OyAmZ3Q7ICZndDs8YnI+CiZndDsgJmd0OyAm
Z3Q7IC0tPGJyPgomZ3Q7ICZndDsgJmd0OyB8IFN0ZWZhbi5NYW5lZ29sZCBAIENXSS5ubCB8IERC
IEFyY2hpdGVjdHVyZXMgKElOUzEpIHw8YnI+CiZndDsgJmd0OyAmZ3Q7IHwgPGEgaHJlZj0iaHR0
cDovL0NXSS5ubC9+bWFuZWdvbGQvIiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL0NXSS5ubC9+bWFu
ZWdvbGQvPC9hPiB8IFNjaWVuY2UgUGFyayAxMjMgKEwzMjEpIHw8YnI+CiZndDsgJmd0OyAmZ3Q7
IHwgVGVsLjogKzMxICgwKTIwIDU5Mi00MjEyIHwgMTA5OCBYRyBBbXN0ZXJkYW0goChOTCkgfDxi
cj4KJmd0OyAmZ3Q7ICZndDs8YnI+CiZndDsgJmd0OyAmZ3Q7IC0tLTxicj4KJmd0OyAmZ3Q7ICZn
dDsgLS0tPGJyPgomZ3Q7ICZndDsgJmd0OyAtLS08YnI+CiZndDsgJmd0OyAmZ3Q7IC0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLTxicj4KJmd0OyAmZ3Q7ICZndDsgRW5hYmxlIHlvdXIgc29mdHdhcmUgZm9yIEludGVsKFIp
IEFjdGl2ZSBNYW5hZ2VtZW50IFRlY2hub2xvZ3kgdG88YnI+CiZndDsgJmd0OyAmZ3Q7IG1lZXQg
dGhlPGJyPgomZ3Q7ICZndDsgJmd0OyBncm93aW5nIG1hbmFnZWFiaWxpdHkgYW5kIHNlY3VyaXR5
IGRlbWFuZHMgb2YgeW91ciBjdXN0b21lcnMuPGJyPgomZ3Q7ICZndDsgJmd0OyBCdXNpbmVzc2Vz
PGJyPgomZ3Q7ICZndDsgJmd0OyBhcmUgdGFraW5nIGFkdmFudGFnZSBvZiBJbnRlbChSKSB2UHJv
IChUTSkgdGVjaG5vbG9neSAtIHdpbGwgeW91cjxicj4KJmd0OyAmZ3Q7ICZndDsgc29mdHdhcmU8
YnI+CiZndDsgJmd0OyAmZ3Q7IGJlIGEgcGFydCBvZiB0aGUgc29sdXRpb24/IERvd25sb2FkIHRo
ZSBJbnRlbChSKSBNYW5hZ2VhYmlsaXR5IENoZWNrZXI8YnI+CiZndDsgJmd0OyAmZ3Q7IHRvZGF5
ISA8YSBocmVmPSJodHRwOi8vcC5zZi5uZXQvc2Z1L2ludGVsLWRldjJkZXZtYXIiIHRhcmdldD0i
X2JsYW5rIj5odHRwOi8vcC5zZi5uZXQvc2Z1L2ludGVsLWRldjJkZXZtYXI8L2E+PGJyPgomZ3Q7
ICZndDsgJmd0OyBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
Xzxicj4KJmd0OyAmZ3Q7ICZndDsgTW9uZXREQi11c2VycyBtYWlsaW5nIGxpc3Q8YnI+CiZndDsg
Jmd0OyAmZ3Q7IDxhIGhyZWY9Im1haWx0bzpNb25ldERCLXVzZXJzQGxpc3RzLnNvdXJjZWZvcmdl
Lm5ldCI+TW9uZXREQi11c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQ8L2E+PGJyPgomZ3Q7ICZn
dDsgJmd0OyA8YSBocmVmPSJodHRwczovL2xpc3RzLnNvdXJjZWZvcmdlLm5ldC9saXN0cy9saXN0
aW5mby9tb25ldGRiLXVzZXJzIiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly9saXN0cy5zb3VyY2Vm
b3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vbW9uZXRkYi11c2VyczwvYT48YnI+CiZndDsgJmd0Ozxi
cj4KJmd0OyAmZ3Q7PGJyPgomZ3Q7ICZndDsgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPGJyPgomZ3Q7
ICZndDsgRW5hYmxlIHlvdXIgc29mdHdhcmUgZm9yIEludGVsKFIpIEFjdGl2ZSBNYW5hZ2VtZW50
IFRlY2hub2xvZ3kgdG8gbWVldCB0aGU8YnI+CiZndDsgJmd0OyBncm93aW5nIG1hbmFnZWFiaWxp
dHkgYW5kIHNlY3VyaXR5IGRlbWFuZHMgb2YgeW91ciBjdXN0b21lcnMuIEJ1c2luZXNzZXM8YnI+
CiZndDsgJmd0OyBhcmUgdGFraW5nIGFkdmFudGFnZSBvZiBJbnRlbChSKSB2UHJvIChUTSkgdGVj
aG5vbG9neSAtIHdpbGwgeW91ciBzb2Z0d2FyZTxicj4KJmd0OyAmZ3Q7IGJlIGEgcGFydCBvZiB0
aGUgc29sdXRpb24/IERvd25sb2FkIHRoZSBJbnRlbChSKSBNYW5hZ2VhYmlsaXR5IENoZWNrZXI8
YnI+CiZndDsgJmd0OyB0b2RheSEgPGEgaHJlZj0iaHR0cDovL3Auc2YubmV0L3NmdS9pbnRlbC1k
ZXYyZGV2bWFyIiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL3Auc2YubmV0L3NmdS9pbnRlbC1kZXYy
ZGV2bWFyPC9hPjxicj4KJmd0OyAmZ3Q7IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fPGJyPgomZ3Q7ICZndDsgTW9uZXREQi11c2VycyBtYWlsaW5nIGxpc3Q8
YnI+CiZndDsgJmd0OyA8YSBocmVmPSJtYWlsdG86TW9uZXREQi11c2Vyc0BsaXN0cy5zb3VyY2Vm
b3JnZS5uZXQiPk1vbmV0REItdXNlcnNAbGlzdHMuc291cmNlZm9yZ2UubmV0PC9hPjxicj4KJmd0
OyAmZ3Q7IDxhIGhyZWY9Imh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xpc3RzL2xpc3Rp
bmZvL21vbmV0ZGItdXNlcnMiIHRhcmdldD0iX2JsYW5rIj5odHRwczovL2xpc3RzLnNvdXJjZWZv
cmdlLm5ldC9saXN0cy9saXN0aW5mby9tb25ldGRiLXVzZXJzPC9hPjxicj4KJmd0OyAmZ3Q7PGJy
Pgo8YnI+CjwvZGl2PjwvZGl2PiZndDsgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPGJyPgomZ3Q7IENy
ZWF0ZSBhbmQgcHVibGlzaCB3ZWJzaXRlcyB3aXRoIFdlYk1hdHJpeDxicj4KJmd0OyBVc2UgdGhl
IG1vc3QgcG9wdWxhciBGUkVFIHdlYiBhcHBzIG9yIHdyaXRlIGNvZGUgeW91cnNlbGY7PGJyPgom
Z3Q7IFdlYk1hdHJpeCBwcm92aWRlcyBhbGwgdGhlIGZlYXR1cmVzIHlvdSBuZWVkIHRvIGRldmVs
b3AgYW5kPGJyPgomZ3Q7IHB1Ymxpc2ggeW91ciB3ZWJzaXRlLiA8YSBocmVmPSJodHRwOi8vcC5z
Zi5uZXQvc2Z1L21zLXdlYm1hdHJpeC1zZiIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly9wLnNmLm5l
dC9zZnUvbXMtd2VibWF0cml4LXNmPC9hPjxicj4KPGRpdiBjbGFzcz0iaW0iPjxicj4KJmd0OyBf
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzxicj4KJmd0OyBN
b25ldERCLXVzZXJzIG1haWxpbmcgbGlzdDxicj4KJmd0OyA8YSBocmVmPSJtYWlsdG86TW9uZXRE
Qi11c2Vyc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQiPk1vbmV0REItdXNlcnNAbGlzdHMuc291cmNl
Zm9yZ2UubmV0PC9hPjxicj4KJmd0OyA8YSBocmVmPSJodHRwczovL2xpc3RzLnNvdXJjZWZvcmdl
Lm5ldC9saXN0cy9saXN0aW5mby9tb25ldGRiLXVzZXJzIiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6
Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vbW9uZXRkYi11c2VyczwvYT48
YnI+Cjxicj4KPGJyPgotLTxicj4KfCBTdGVmYW4uTWFuZWdvbGQgQCBDV0kubmwgfCBEQiBBcmNo
aXRlY3R1cmVzIChJTlMxKSB8PGJyPgp8IDxhIGhyZWY9Imh0dHA6Ly9DV0kubmwvfm1hbmVnb2xk
LyIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly9DV0kubmwvfm1hbmVnb2xkLzwvYT4gfCBTY2llbmNl
IFBhcmsgMTIzIChMMzIxKSB8PGJyPgp8IFRlbC46ICszMSAoMCkyMCA1OTItNDIxMiB8IDEwOTgg
WEcgQW1zdGVyZGFtIKAoTkwpIHw8YnI+Cjxicj4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPGJyPgo8
L2Rpdj5DcmVhdGUgYW5kIHB1Ymxpc2ggd2Vic2l0ZXMgd2l0aCBXZWJNYXRyaXg8YnI+ClVzZSB0
aGUgbW9zdCBwb3B1bGFyIEZSRUUgd2ViIGFwcHMgb3Igd3JpdGUgY29kZSB5b3Vyc2VsZjs8YnI+
CldlYk1hdHJpeCBwcm92aWRlcyBhbGwgdGhlIGZlYXR1cmVzIHlvdSBuZWVkIHRvIGRldmVsb3Ag
YW5kPGJyPgpwdWJsaXNoIHlvdXIgd2Vic2l0ZS4gPGEgaHJlZj0iaHR0cDovL3Auc2YubmV0L3Nm
dS9tcy13ZWJtYXRyaXgtc2YiIHRhcmdldD0iX2JsYW5rIj5odHRwOi8vcC5zZi5uZXQvc2Z1L21z
LXdlYm1hdHJpeC1zZjwvYT48YnI+CjxkaXY+PGRpdj48L2Rpdj48ZGl2IGNsYXNzPSJoNSI+X19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX188YnI+Ck1vbmV0REIt
dXNlcnMgbWFpbGluZyBsaXN0PGJyPgo8YSBocmVmPSJtYWlsdG86TW9uZXREQi11c2Vyc0BsaXN0
cy5zb3VyY2Vmb3JnZS5uZXQiPk1vbmV0REItdXNlcnNAbGlzdHMuc291cmNlZm9yZ2UubmV0PC9h
Pjxicj4KPGEgaHJlZj0iaHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGlu
Zm8vbW9uZXRkYi11c2VycyIgdGFyZ2V0PSJfYmxhbmsiPmh0dHBzOi8vbGlzdHMuc291cmNlZm9y
Z2UubmV0L2xpc3RzL2xpc3RpbmZvL21vbmV0ZGItdXNlcnM8L2E+PGJyPgo8L2Rpdj48L2Rpdj48
L2Jsb2NrcXVvdGU+PC9kaXY+PGJyPjwvZGl2PjwvZGl2PjwvZGl2Pgo=

--===============1804765087794203727==--