Thomas Kempf schrieb: >> Thomas Kempf wrote: >>> Bruno Friedmann schrieb: >>>> Hi Thomas, I remember discussion on the ML about trouble with postgresql & >>>> bacula. >>>> Bacula mens insist to have SQL_ASCII for postgres & bacula. >>>> Your bacula's db is SQL_ASCII, but I suppose as template0 and template1 >>>> are UTF-8 the batch temporary table >>>> are created based on one of the two which conduct to the errors you >>>> encounter. >>>> >>>> I think you have to give this information if you are reporting this bug. >>>> (Perharps give a try to the wiki, searching about postgresql & the docs ) >>>> before you transmit a bug. >>>> >>>> Anyway if bacula need a sql_ascii table, it should be "smart" enough to >>>> create it with this requirement. >>>> >>> Hi Bruno, >>> first of all thank you for your explanation. It seems reasonable for me, >>> that this is the root of the problem with postgresql and bacula. I 've >>> really searched the docs, the mailinglist and the web, but have not >>> found any place where the template DB encoding is mentioned as the >>> problem source. I'll check this though. The problem is solved in SVN now. Eric submitted a patch, which checks for the return value of the SQL-Transaction. But far better than that, the underlying problem with Postgresql rejecting the transaction is solved too by setting the client_encoding explicitely to SQL_ASCII just before the transaction begins! Thank you Eric!
Tom ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
