[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-users
Subject:    [MonetDB-users]  Problem with Create Tables
From:       Lowterm <portal () gmx ! de>
Date:       2011-06-02 13:02:54
Message-ID: 31757411.post () talk ! nabble ! com
[Download RAW message or body]


Hi,

what's the meaning of this syntax error?

Syntax error, unexpected CREATE, expecting SCOLON in: "create ..."

I get this message with the "create table" if I load a Files with "sql>\<
filename", which contains this statement. The create-statement works, if I
insert it directly.

The second error message ist:

syntax error, unexpected ON, expecting ')' or ',' in: "create ..." in the
following create statement:

CREATE TABLE dim_warehouse (
  is_current smallint NOT NULL,
  last_modified timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP
)

but I can not see wath is wrong.

Thanks


-- 
View this message in context: http://old.nabble.com/Problem-with-Create-Tables-tp31757411p31757411.html
Sent from the monetdb-users mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger. 
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Data protection magic?
Nope - It's vRanger. Get your free trial download today. 
http://p.sf.net/sfu/quest-sfdev2dev
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users
[prev in list] [next in list] [prev in thread] [next in thread]