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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "hakim(dot)togou(at)capgemini(dot)com" <hakim(dot)togou(at)capgemini(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15536: ERROR: column "value " does not exist
Date: 2018-12-05 12:33:53
Message-ID: CAKFQuwbztarPx+1eNfQhsea-Xw+6+=ntqMNf=NgKo=ue=S5KfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wednesday, December 5, 2018, PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 15536
> Logged by: Hakim Tog
> Email address: hakim(dot)togou(at)capgemini(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Togou, Hakim 2018-12-05 13:36:58 RE: BUG #15536: ERROR: column "value " does not exist
Previous Message David G. Johnston 2018-12-05 12:30:45 Re: BUG #15535: psql: \copy: parse error at...