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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users