On Wed, Feb 3, 2016 at 4:09 PM, drum.lu...@gmail.com <drum.lu...@gmail.com> wrote:
> > > On 4 February 2016 at 12:03, David G. Johnston <david.g.johns...@gmail.com > > wrote: > >> On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com < >> drum.lu...@gmail.com> wrote: >> >>> Hi all, >>> >>> Below is an example of the auto-generated update query, with >>> client-supplied keys (_iid). There's a fatal error when _iid is not >>> numeric. However; this should accept any value. >>> >> The supplied query is not an update query and as far as I can tell nothing in it compels the system to try and convert your text _iid from the CTE to an integer. So, you are still not showing us the whole picture. But, if whatever target relation you are trying to insert/update this record against defines _iid as integer then you need to change it to be defined as text. David J.
