Hi,

I'm working on porting my app to turbine/wm, and I'm using PostgreSQL. 
I've been looking at the db creation scripts, and noticed the following:

In the MySQL_users_roles_permissions.sql the ID's on the main tables use
auto_increment, but there is also an entry in the ID table for each of
them.  Which one is really used, because the Postgres script uses a
serial (similar to auto_increment) but there is no file for loading the
id table...should I make one?


The large object field in the Visitor table is a varchar(255).  The
correct way to do large objects in PostgreSQL is datatype oid.  

The primary key in the JobEntry table is called OID.  I think this will
fail in Postgres because it is a reserved word.  Can we change the name
of that column so I can add the JobEntry table into the PostgreSQL
script?

        -Nissim


------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]

Reply via email to