From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Vitalii Tymchyshyn <tivv00(at)gmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Problem with executeBatch and "A result was returned when none was expected" |
Date: | 2011-03-16 10:57:58 |
Message-ID: | AANLkTinF5dMpYaeGz4EVJvMWdE4tCJo6FacbDBHaF6aK@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Wed, Mar 16, 2011 at 6:43 AM, Vitalii Tymchyshyn <tivv00(at)gmail(dot)com> wrote:
> 16.03.11 12:40, Dave Cramer написав(ла):
>
> So looking at the code if you add RETURN_GENERATED_KEYS to the
> statement it returns all of the columns. That's rather ugly. Is there
> a way to determine just the generated keys ?
>
> AFAIR it was a long discussion on what is "generated". E.g. is calculated
> default value (CURRENT TIMESTAMP) generated? Constant default value? So, the
> driver now either returns all or you can pass columns you require by
> yourself with "boolean execute(String sql, String[] columnNames)".
>
So ideally we need some backend support here. The backend can
certainly figure out what was the result of a default column.
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Vitalii Tymchyshyn | 2011-03-16 11:04:28 | Re: Problem with executeBatch and "A result was returned when none was expected" |
Previous Message | Vitalii Tymchyshyn | 2011-03-16 10:43:58 | Re: Problem with executeBatch and "A result was returned when none was expected" |