Re: BUG #15536: ERROR: column "value " does not exist - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #15536: ERROR: column "value " does not exist
Date
Msg-id CAKFQuwbztarPx+1eNfQhsea-Xw+6+=ntqMNf=NgKo=ue=S5KfQ@mail.gmail.com
Whole thread Raw
In response to BUG #15536: ERROR: column "value " does not exist  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #15536: ERROR: column "value " does not exist
List pgsql-bugs
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. 

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #15535: psql: \copy: parse error at...
Next
From: "Togou, Hakim"
Date:
Subject: RE: BUG #15536: ERROR: column "value " does not exist