Обсуждение: BUG #15536: ERROR: column "value " does not exist

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?

Thank you very much.

Regards,
Hakim

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?

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

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@2ndquadrant.com>
Sent: woensdag 5 december 2018 15:02
To: Togou, Hakim
Cc: pgsql-bugs@lists.postgresql.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
thecause 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
isintended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized
toread, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this
messagein error, please notify the sender immediately and delete all copies of this message. 

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

Hi Hakim

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

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

Don't worry, I can read programming languages.

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

Yeah, this statement works fine.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services