Fw: Can't update rows in tables qualified with schema names

From: "Paul Sorenson" <pauls(at)classware(dot)com(dot)au>
To: "postgresql jdbc" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Fw: Can't update rows in tables qualified with schema names
Date: 2003-03-03 07:10:22
Message-ID: 001d01c2e153$f50250a0$c48b0fcb@home.classware.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I sent this to the list a few days ago and it hasn't popped up yet - if you
get it twice please accept my apologies.

----- Original Message -----
From: "Paul Sorenson" <pauls(at)classware(dot)com(dot)au>
To: "postgresql jdbc" <pgsql-jdbc(at)postgresql(dot)org>
Sent: Saturday, March 01, 2003 11:27 AM
Subject: Re: [JDBC] Can't update rows in tables qualified with schema names

> Try #2 (and 20 pushups)...
>
> I collapsed my spaces to tabs too - hope you guys have yours set to 4.
>
> ----- Original Message -----
> From: "Barry Lind" <blind(at)xythos(dot)com>
> To: "Paul Sorenson" <pauls(at)classware(dot)com(dot)au>
> Sent: Saturday, March 01, 2003 3:57 AM
> Subject: Re: [JDBC] Can't update rows in tables qualified with schema
names
>
>
> > Paul,
> >
> > Thanks for the patch. There are a couple of issues with it that I would
> > like to mention:
> >
> > 1) It doesn't correctly handle this case: schema."Dot.Table" you
> > return: Table"
> >
> > 2) It doesn't completely fix the original bug report. The proper fix
> > would be to get both the schema and tablename from the input and pass
> > both to the getPrimaryKeys() method. Your patch just ignores the schema
> > which is incorrect if you happen to have multiple tables with the same
> > name in different schemas.
> >
> > thanks,
> > --Barry
>

Attachment Content-Type Size
AbstractJdbc2ResultSet.patch application/octet-stream 3.5 KB

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Carl Olivier 2003-03-03 09:35:51 SEQUENCES
Previous Message Dirk Bromberg 2003-03-03 06:45:42 Re: Connection Pool