| From: | "Ravulapati, Gautham" <Gautham(dot)Ravulapati(at)ncr(dot)com> |
|---|---|
| To: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | ERROR: unterminated dollar-quoted string at or near "$$" |
| Date: | 2022-08-04 03:58:02 |
| Message-ID: | SA1PR15MB49044C3ACFB839FF90E09EA9969F9@SA1PR15MB4904.namprd15.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2022-08-04 07:41:29 | Re: Excessive number of replication slots for 12->14 logical replication |
| Previous Message | Richard Guo | 2022-08-04 03:16:42 | Re: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY |