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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Bricklen Anderson wrote:
> 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)
>
>

Thanks a lot. I missed that option in the man page - but now I see it.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match