On 9/23/2004 7:36 AM, Niels Breet wrote:

>> Character 2106 in my query is '-' in slony's column name:
>>
>> update cm set id=57139,...,_slony-i_test_rowid=null where  auto_id =
>> 57691;
>>                                   ^
>>                                   ^
>>                              This is character 2106 in my query.]
>>
> 
> It seems that '-' is an illegal char, try renaming your column.

He can't, it's the slony rowID that was added by the "add key". I wonder 
why the whole thing works at all, since 'cm' is not a fully qualified 
table name (that would be public.cm) and column names should get quoted 
in the replication queries. Have to check a couple of things there ...


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #