Issue #13286 has been updated by Chris Price. Description updated
---------------------------------------- Bug #13286: [Stored Configurations] Invalid unicode escaping with PostgreSQL 9.x https://projects.puppetlabs.com/issues/13286#change-58731 Author: Dennis Hoppe Status: Unreviewed Priority: High Assignee: Category: Target version: Affected Puppet version: 2.7.6 Keywords: Branch: Hello, beginning with PostgreSQL 9.1 the parameter "standard_conforming_strings" will have the value "on" as default. standard_conforming_strings (boolean) This controls whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL standard. Beginning in PostgreSQL 9.1, the default is on (prior releases defaulted to off). Applications can check this parameter to determine how string literals will be processed. The presence of this parameter can also be taken as an indication that the escape string syntax (E'...') is supported. Escape string syntax (Section 4.1.2.2) should be used if an application desires backslashes to be treated as escape characters. This will throw the following error message: 2012-03-15 11:15:01 CET FEHLER: ungültiges Unicode-Escape bei Zeichen 184 2012-03-15 11:15:01 CET TIPP: Unicode-Escapes müssen \uXXXX oder \UXXXXXXXX sein. 2012-03-15 11:15:01 CET ANWEISUNG: INSERT INTO "param_values" ("created_at", "line", "resource_id", "updated_at", "value", "param_name_id") VALUES('2012-03-15 11:15:01.040833', NULL, 154, '2012-03-15 11:15:01.040833', E' The following three lines from my .bashrc are responsible for that, because of the \u PostgreSQL expects a unicode string. PS1='${debian_chroot:+($debian_chroot)}\[<%= t_color -%>\]\u@\h\[\033[00m\]:\ [\033[01;34m\]\w\[\033[00m\]\$ ' PS1='${debian_chroot:+($debian_chroot)}\u@\h:\w\$ ' PS1="\[\e]0;${debian_chroot:+($debian_chroot)}\u@\h: \w\a\]$PS1" Regards, Dennis -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://projects.puppetlabs.com/my/account -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
