Re: Duplicate Columns on Insert - Mailing list pgsql-jdbc

From Tom Innes
Subject Re: Duplicate Columns on Insert
Date
Msg-id 000201c2374d$3e211480$6901a8c0@TGIDesktopW20
Whole thread Raw
In response to Re: Duplicate Columns on Insert  (Aaron Mulder <ammulder@alumni.princeton.edu>)
List pgsql-jdbc
Reply Below..



 -----Original Message-----
From:     pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]  On Behalf Of Aaron Mulder
Sent:    July 29, 2002 5:37 PM
To:    pgsql-jdbc@postgresql.org
Subject:    Re: [JDBC] Duplicate Columns on Insert

    Do you know what INSERT statement JBoss is constructing (sounds
like perhaps it is including the same column twice in the insert)?

    Exactly,
 Is the
column in question both a CMP field and a CMR field?

    Yes
  If so, and you
remove the CMP entries for it so it's just a CMR field, does it work?
    Yes it does,


But this has several negative implications.
    1,  A CMR field cannot particpate as the primary key in table B

What is perplexing here is that Hypersonic works fine?

Tom

Aaron

On Mon, 29 Jul 2002, Tom Innes wrote:
> Hi,
>
> I am using Postgres V7.21 along with Jboss V3.01.. I have established a 1
to
> many relationship between table A ( 1)  and Table B (n).  When I attempt
to
> insert into table B, I get a duplicate column exception.  The duplicated
> column is the related column.
>
> When I try this same project on hypersonic, it works fine.
>
> Is this a known problem on the PostgreSQL JDBC driver?


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


pgsql-jdbc by date:

Previous
From: Aaron Mulder
Date:
Subject: Re: Duplicate Columns on Insert
Next
From: "Raymund"
Date:
Subject: pgjdbc7.2