ERROR: unterminated dollar-quoted string at or near "$$"

Поиск
Список
Период
Сортировка
От Ravulapati, Gautham
Тема ERROR: unterminated dollar-quoted string at or near "$$"
Дата
Msg-id SA1PR15MB49044C3ACFB839FF90E09EA9969F9@SA1PR15MB4904.namprd15.prod.outlook.com
обсуждение исходный текст
Ответы Re: ERROR: unterminated dollar-quoted string at or near "$$"  (Francisco Olarte <folarte@peoplecall.com>)
Re: ERROR: unterminated dollar-quoted string at or near "$$"  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения

Hello Team,

 

I am trying to create functions and triggers from PSQLl on windows. Same SQL scripts work from Linux PSQL but fail with following error

 

ERROR:  unterminated dollar-quoted string at or near "$$"

 

One of the workaround I found was to substitute $$ with single quote and all single quote with double quotes, in my case I cannot do this for two reasons.

  1. Same scripts need to execute on linux and windows
  2. These SQl files are generated one and would completely new implementation for replacing the $$.

 

I see that PSQL version 7 .6 is same across all the postgres version on windows. Is there no latest version of PSQL .

 

Kindly let me know if there  are any options at PSQL level or any recommendations.

 

Regards,

Gautham.R

 

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Richard Guo
Дата:
Сообщение: Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Excessive number of replication slots for 12->14 logical replication