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

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

From
PG Bug reporting form
Date:
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


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

From
"David G. Johnston"
Date:
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.

David J. 

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

From
"Togou, Hakim"
Date:

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.

 

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.

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

From
Alvaro Herrera
Date:
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


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

From
"Togou, Hakim"
Date:
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. 



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

From
"David G. Johnston"
Date:
On Wednesday, December 5, 2018, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
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);'


Beyond that use prepared statements in Java for this kind of query.

And as written the java stuff does not have any quoting of values which is a problem for text data.

David J.

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

From
Alvaro Herrera
Date:
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