This should be fixed now in CVS. It was a bug in the monet5 backend of SQL (i.e. update sql and recompile that). On 2006-10-25 11:37, Romulo Goncalves wrote:
Dear developers,
I start a mserver5, I load the sql module, and I start a sql client with sql.start() in the mserver prompt.
In a new shell I start an mclient and I load a sql file to create a user and a schema within one transaction:
mclient < create_user.sql
After to run this command line the client never closes its session. I check the mserver system tables and the user and the schema were created.
This is the file loaded in mclient:
START TRANSACTION;
CREATE USER "skyserver" WITH PASSWORD 'skyserver' NAME 'SkyServer' SCHEMA "sys";CREATE SCHEMA "skyserver" AUTHORIZATION "skyserver"; ALTER USER "skyserver" SET SCHEMA "skyserver";
COMMIT;
Any idea?
Regards, Romulo
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Sjoerd Mullender