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

Hi,

Yes that is true, I work with Mendix so I needed the + to make it quoted string. So for your understanding
this is the statement without Mendix related stuff.

Statement:
INSERT INTO assetmanagement$asset ("id","ticker","fullname")
VALUES ('12345678910','test1','test2');

Regards,
Hakim

-----Original Message-----
From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Sent: woensdag 5 december 2018 15:02
To: Togou, Hakim
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15536: ERROR: column "value " does not exist

On 2018-Dec-05, Togou, Hakim wrote:

> 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.

This is a completely different statement than you first showed -- completely different quoting in column names and values, etc. You need to be very exact and strict about what you post, because one of those quoting things is likely the cause of your problem. Don't try to transcribe things manually ... you need to copy & paste instead.

You also need to show exactly what is the error message you're obtaining. The server log might be useful too.

> 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);'

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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.