Postgres Pro
Downloads
Home   >   mailing lists

ERROR: unterminated dollar-quoted string at or near "$$" - Mailing list pgsql-bugs

From Ravulapati, Gautham
Subject ERROR: unterminated dollar-quoted string at or near "$$"
Date
Msg-id SA1PR15MB49044C3ACFB839FF90E09EA9969F9@SA1PR15MB4904.namprd15.prod.outlook.com
Whole thread Raw
Responses Re: ERROR: unterminated dollar-quoted string at or near "$$"
Re: ERROR: unterminated dollar-quoted string at or near "$$"
List pgsql-bugs
Tree view

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 by date:

Previous
From: Richard Guo
Date:
Subject: Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY
Next
From: Masahiko Sawada
Date:
Subject: Re: Excessive number of replication slots for 12->14 logical replication