Preston de Guise wrote: > I don't yet properly understand the conforming strings implementation > that came in 8.3 The manual (to me at least) has been a little > imprecise in describing the implications for correctly inserting data > with this enabled without getting back a plethora of warnings, or > having the inserts fail completely. > > Is anyone aware of a good "how to" document on conforming strings > covering such topics as: > > - Valid quoting methods and when the various ones should be used > - Criteria for warnings (in some instances it seems you can get > warnings about them no matter how 'safely' you insert? I.e., I know > I'm likely to still be doing things wrong...) > (- Any coverage of DBD::Pg's capabilities would be a great bonus) I'll try to describe it in a few simple lines: - with standard_conforming_strings=off, backslashes in string constants are always interpreted as escape characters. - with standard_conforming_strings=on, backslashes in string constants are interpreted as escape characters *only* if the string constant is preceeded by an E. - The warnings are only about the first case; they warn you that your backslash characters are interpreted as escape characters even though the string is not preceeded by E. I don't think there's anything special to consider for DBD::Pg. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
