[Modeling-users] mdl_generate_DB_schema: table creation problem

[Mario R. <ma...@ru...>]

Hi,

I am feeding a simple (and with only one table) model to  
mdl_generate_DB_schema,
that validates and generates python code OK. It fails with the log  
below.
This is running on OSX, with postgres 7.3, pypgsql 2.3, osx 10.2.4 (new  
update,
that has broken some other things...), and modeling 0.9-pre-2.
Any ideas?

Cheers, mario


% mdl_generate_DB_schema.py -T cwText.xml
Couldn't evaluate expression CREATE TABLE Text (
   fr VARCHAR(400) ,
   en VARCHAR(400) ,
   nl VARCHAR(400) ,
   name VARCHAR(40) NOT NULL,
   pt VARCHAR(400) ,
   de VARCHAR(400) ,
   id INTEGER(20) NOT NULL,
   es VARCHAR(400) ,
   it VARCHAR(400) ). Reason: libpq.OperationalError:ERROR:  parser:  
parse error at or near "(" at character 168

FAILED to execute: CREATE TABLE Text (
   fr VARCHAR(400) ,
   en VARCHAR(400) ,
   nl VARCHAR(400) ,
   name VARCHAR(40) NOT NULL,
   pt VARCHAR(400) ,
   de VARCHAR(400) ,
   id INTEGER(20) NOT NULL,
   es VARCHAR(400) ,
   it VARCHAR(400) )
Reason:
Modeling.Adaptor.GeneralAdaptorException
Couldn't evaluate expression CREATE TABLE Text (
   fr VARCHAR(400) ,
   en VARCHAR(400) ,
   nl VARCHAR(400) ,
   name VARCHAR(40) NOT NULL,
   pt VARCHAR(400) ,
   de VARCHAR(400) ,
   id INTEGER(20) NOT NULL,
   es VARCHAR(400) ,
   it VARCHAR(400) ). Reason: libpq.OperationalError:ERROR:  parser:  
parse error at or near "(" at character 168

   File "/usr/bin/mdl_generate_DB_schema.py", line 105, in  
databaseSchemaWithOptions
     channel.evaluateExpression(sqlExpr)
   File  
"/usr/lib/python2.2/site-packages/Modeling/DatabaseAdaptors/ 
AbstractDBAPI2AdaptorLayer/AbstractDBAPI2AdaptorChannel.py", line 164,  
in evaluateExpression
     raise GeneralAdaptorException, msg