Peter,
It also does it from Borland Delphi and I tightly control the EOL markers.
I use a Advanced Syntax Highlighting memo component/widget from TMS
software.
Delphi has a function called adjustlinebreaks, where I can convert the
text going to the server to have either LF or CRLF and Postgres 8.0
strips them out regardless of what they are.
Like I said before If I reopen the the same function and then manually
replace all the line breaks it works fine with the dollar quoting. It
also works fine if the function is new, i.e. not restored from a 7.x backup.
It also works fine if I don't use the dollar qouting and do find/replace
to convert all the single qoutes in the body, then single quote the
whole thing, then add the header and the footer, which is how I did it
for 7.x.
With 8.0 and dollar quoting it appeared I would not have to do all that,
but as of right now it does not seem to work exactly as expected, at
least with freshly restored functions from 7.x
I can run a SQL monitor that shows the exact SQL that is being sent to
the server, so I will do that and then
let you know.
Thanks for the response,
Tony Caduto
Peter Eisentraut wrote:
>Tony Caduto wrote:
>
>
>>There appears to be a problem with functions that have been restored
>>from 7.4.x and dollar quoting, after it has been saved once, then the
>>EOL markers replaced the problem goes away.
>>
>>
>
>No, it's a problem with notepad randomly reformatting your files. Use a
>different editor.
>
>
>