Re: Inserting into a uuid column - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Re: Inserting into a uuid column
Date
Msg-id golbl5$aj4$1@ger.gmane.org
Whole thread Raw
In response to Re: Inserting into a uuid column  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Hi Kris,

thanks for your answers.

I can change the import to use setObject(int, Object, int) which works fine.

> The reason the driver doesn't do this is twofold.
>
> 1) The driver doesn't know the target server type.  Retrieving that
> would induce an extra network roundtrip for execution.
>
> 2) Sometimes the server doesn't know the the target type and it's better
> for the driver/user to provide it.  Consider the call of an overloaded
> function: SELECT myfunc(?), if it has an implementation for both float
> and int, you want the user/driver to indicate which one should be called
> because the server doesn't know.

I can see the problems there ;)

Regards
Thomas

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Inserting into a uuid column
Next
From: Anthony Presley
Date:
Subject: canceling query due to user request