RE: BUG #15536: ERROR: column "value " does not exist
От | Togou, Hakim |
---|---|
Тема | RE: BUG #15536: ERROR: column "value " does not exist |
Дата | |
Msg-id | DB7PR02MB48406AF845D9ABF1F9AF7C1FE8A80@DB7PR02MB4840.eurprd02.prod.outlook.com обсуждение исходный текст |
Ответ на | Re: BUG #15536: ERROR: column "value " does not exist ("David G. Johnston" <david.g.johnston@gmail.com>) |
Ответы |
Re: BUG #15536: ERROR: column "value " does not exist
|
Список | pgsql-bugs |
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.
В списке pgsql-bugs по дате отправления: