I upgraded the server to 7.0 but I'm still using the 6.5.3 JDBC driver.
-Nissim
christopher baus wrote:
>
> 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]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
