Re: Inserting into a uuid column

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Inserting into a uuid column
Date: 2009-03-04 07:46:40
Message-ID: golbl5$aj4$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Anthony Presley 2009-03-04 23:11:10 canceling query due to user request
Previous Message Oliver Jowett 2009-03-03 22:53:23 Re: Inserting into a uuid column