Can I enable AUTO-COMMIT mode by default? If not, how can I enable "auto-commit" from the command line.

 

I can use the \A option after I connect using "mclient". But I would like to do so from the command line. In short, the following doesn't work if I include all the commands in one script.

 

\A

drop table table1;

drop table table2;

 

I can't execute the above script using "mclient".

 

-Venks

 

On 9/18/07, Niels Nes <Niels.Nes@cwi.nl> wrote:

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
>