[MonetDB-users] Persistent Stored Modules and a SQL issue

17 Sep 2007

      Two questions.

1. Can I execute a dynamic DDL statement using PSM?

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.

Thanks,

-Venks