Re: 7.4.6 to 8.2.5 - ' changes to $_$

Steve Clark wrote:
>
> function from 7.4.x postgres
>
> CREATE FUNCTION update_dns(text, text) RETURNS integer
>      AS 'UPDATE domain_details SET domain = $2 WHERE domain = $1;
>      DELETE from domains where domain = $1;
>      SELECT 1 AS ignore;'
>      LANGUAGE sql;
>
> I load it into 8.2.5 - then dump it out and it is changed to
>
>
> CREATE FUNCTION update_dns(text, text) RETURNS integer
>      AS $_$UPDATE domain_details SET domain = $2 WHERE domain = $1;
>      DELETE from domains where domain = $1;
>      SELECT 1 AS ignore;$_$
>      LANGUAGE sql;
>
> notice $_$ where the single ' use to be.
>
> Is there some way to keep this from happening?
>
> The reason is we have systems in the field that have configuration
> information stored in 7.4.x.
> We want to upload that db info load it into an 8.2.5 db massage it then
> send it back to the unit
> in the field. I realize there are things I am going to have to fix up in
> the 8.2.5 dump to be able to load
> it back into the 7.4.x db but I want to minimize that as much as possible.
>
> We have some units in the field running 8.1.3 and it does not change the
> ' to $_$.
>
>
> Thanks,
> Steve

I think "--disable-dollar-quoting" will work. (pg_dump --help)