Re: BUG #1375: Problem with Dollar qouting functions
От | Tony Caduto |
---|---|
Тема | Re: BUG #1375: Problem with Dollar qouting functions |
Дата | |
Msg-id | 41E166CC.30503@amsoftwaredesign.com обсуждение исходный текст |
Ответ на | Re: BUG #1375: Problem with Dollar qouting functions (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-bugs |
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. > > >
В списке pgsql-bugs по дате отправления: