Re: ECPG bug: "unterminated quoted identifier"
| От | Tom Lane |
|---|---|
| Тема | Re: ECPG bug: "unterminated quoted identifier" |
| Дата | |
| Msg-id | 674892.1603224610@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: ECPG bug: "unterminated quoted identifier" (1250kv <1250kv@gmail.com>) |
| Ответы |
Re: ECPG bug: "unterminated quoted identifier"
|
| Список | pgsql-bugs |
1250kv <1250kv@gmail.com> writes:
> EXEC SQL char *bar = foo;
I think it's pure luck that that doesn't throw an error.
You should not be using the EXEC SQL prefix for something
that isn't a SQL command.
Anyway, the problem you're hitting here is that as soon as you
say EXEC SQL, the syntax rules for quoted strings change.
This is not well documented, and I think it's got some bugs
in itself [1], but "EXEC SQL char *bar = "aaa\"bbb";" is just
wrong. You can't use C literal syntax inside a SQL code
segment, whether or not the command would work otherwise.
regards, tom lane
[1] https://www.postgresql.org/message-id/673825.1603223178%40sss.pgh.pa.us
В списке pgsql-bugs по дате отправления: