On Mon, Sep 17, 2007 at 07:05:18PM -0400, Venks wrote:
Two questions.
1. Can I execute a dynamic DDL statement using PSM?
No. The DDL statements are executed directly, ie no intermediate mil/mal.
2. I am trying to create a script where I would like to DROP A TABLE before re-creating it. If I include the DROP TABLE in the script, MonetDB throws an error and STOPs execution if the table is not found. This is rather painful as I would like MonetDB to continue with the next SQL command. For. e.g
DROP TABLE table1 ;
CREATE TABLE table1 ....
If I include the above 2 commands in one script, then the above scripts stops execution if "table1" doesn't exists.
In auto-commit mode this should give an error but continue with the second statement. For performance, its good to wrap your inserts into START TRANSACTION/commit, for DDL statements its usually better to use auto-commit mode. Niels
Thanks,
-Venks
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl