Re: [Modeling-users] Installation tests failure (datetime) - osx, pypgsql

[Sebastien B. <sbi...@us...>]

> [...] Now first error is 'Type "datetime" does not exist', and I woul=
d not
> say it is coming from mx.DateTime which seems properly installed (from
> interactive python command, can import mx and DateTime ...). is it so=
mething
> to do with pypgsql?

  Not at all, I identified the problem: the postgresql server that comes
  w/ MacOS X must be a brand new postgres v7.3 ; and pg has stopped
  supporting the datetime SQL data type since v2.3.

    Quoted from documentation v7.2:
    http://www.postgresql.org/docs/view.php?version=3D7.2&idoc=3D1&file=
=3Ddatatype-datetime.html:

  << To ensure an upgrade path from versions of PostgreSQL earlier than
     7.0, we recognize datetime (equivalent to timestamp) and timespan
     (equivalent to interval). These types are now restricted to having
     an implicit translation to timestamp and interval, and support for
     these will be removed in the next release of PostgreSQL (likely
     named 7.3). >>

  (I couldn't find any other hints in the postgresql official
   documentation or in the changelogs, but there's quite a lot of
   messages about that on various mailing-lists and newsgroups)

> I am including all the output this time...
    Sure, that was helpful.

  All errors consecutive to:
> error: Couldn't evaluate expression CREATE TABLE WRITER ( [...]
  are due to the fact that this table cannot be created.

  I need to examine the status of postgresql vs. mysql before making any
  changes ; in the meantime, I suggest that you edit
  tests/testPackages/AuthorBooks/model_AuthorBooks.xml and change that
  line:

    <attribute isClassProperty=3D'1' columnName=3D'BIRTHDAY' name=3D'bi=
rthday'
     isRequired=3D'0' precision=3D'0' defaultValue=3D'None'
     externalType=3D'DATETIME' width=3D'0' scale=3D'0' type=3D'DateTime'
     displayLabel=3D'birthday'/>

  so that it says (change externalType DATETIME to TIMESTAMP):

    <attribute isClassProperty=3D'1' columnName=3D'BIRTHDAY' name=3D'bi=
rthday'
     isRequired=3D'0' precision=3D'0' defaultValue=3D'None'
     externalType=3D'TIMESTAMP' width=3D'0' scale=3D'0' type=3D'DateTim=
e'
     displayLabel=3D'birthday'/>

  I've no postgres v7.3 at hand but a v7.2.1, but it should be ok.

  I'll send more when I have details.

-- S=E9bastien.