Um, I just realised that:
1) The Java and SQL I was using was generated by the 1.2M6 release, while
the JAR was 1.2M7.
2) I was using the Click example's init filter to generate the DB.
I've regenerated the DB, manually using the 1.2M7 SQL, and Java Code and
now the DB is using boolean in stead of BIT(1), but I still have a problem.
I'm getting an exception:
org.postgresql.util.PSQLException: ERROR: relation "auto_pk_support" does
not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1501)
The exception is correct there is not auto_pk_support table, but it appears
that the SQL generated by the modeler is generating sequences for PK's.
Is there anything I can do to fix this?
On 4:31:09 2005-11-10 Andrus Adamchik <andru..bjectstyle.org> wrote:
>
> On Nov 9, 2005, at 4:25 PM, Gentry, Michael ((Contractor)) wrote:
>
> > Did you test in PostgreSQL 8.1 (which was only released yesterday,
> > I think). I'm wondering if it is an 8.1 issue and/or the JDBC
> > driver (not
> > sure if it has been updated for 8.1 -- perhaps there is a newer JAR
> > available).
>
> I can reproduce it with 8.0, so this looks like an old Postgres issue.
<snip>
-- Doychi spdoychia..oychi-dina.ath.cx
This archive was generated by hypermail 2.0.0 : Wed Nov 09 2005 - 23:38:00 EST