RE: BUG #15536: ERROR: column "value " does not exist

Hi David,
I have already quoted the values, this is my query right now:
'INSERT INTO assetmanagement$asset("id","ticker","fullname")
VALUES ('+'12345678910'+','+'test1'+','+'test2'+');
It is an execute statement java action.
Regards,
Hakim

From: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Sent: woensdag 5 december 2018 13:34
To: Togou, Hakim; pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15536: ERROR: column "value " does not exist

On Wednesday, December 5, 2018, PG Bug reporting form <noreply(at)postgresql(dot)org<mailto:noreply(at)postgresql(dot)org>> wrote:
The following bug has been logged on the website:

Bug reference: 15536
Logged by: Hakim Tog
Email address: hakim(dot)togou(at)capgemini(dot)com<mailto:hakim(dot)togou(at)capgemini(dot)com>
PostgreSQL version: 11.0
Operating system: Windows 64
Description:

Hi,

I have tried everything to get the insert a record into an postgres db. This
is my sql query:
'INSERT INTO public."assetmanagement$asset"(ticker, fullname)
VALUES (test1,test2);'

Can you help me with this?

Just how are you executing this, cause test1 is not quoted and doesn’t reference a column name.

David J.
This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.