Might I ask what version of postgres you are using? I've been having
problem after problem with 7.0, primarily with the JDBC drivers (date
formatting, dropping connection, etc.), and I am about to give it up.
----- Original Message -----
From: Nissim <[EMAIL PROTECTED]>
To: Turbine <[EMAIL PROTECTED]>
Sent: Tuesday, May 23, 2000 7:33 PM
Subject: PostgreSQL OID and sequence/id table
> 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]
>
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
