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.g.johnston@gmail.com>
Sent: woensdag 5 december 2018 13:34
To: Togou, Hakim; pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15536: ERROR: column "value " does not exist
On Wednesday, December 5, 2018, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 15536
Logged by: Hakim Tog
Email address: hakim.togou@capgemini.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.