Re: 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: Re: Can't update rows in tables qualified with schema names
Date: 2003-03-01 00:27:50
Message-ID: 003a01c2df89$6440ff10$c48b0fcb@home.classware.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tarjei Skorgenes 2003-03-02 12:24:06 Patch for possible PSQLException bug
Previous Message Carlos 2003-02-28 22:54:32 Spanish translation file