postgres 9.2 error whit apostrophes

Поиск
Список
Период
Сортировка
От Alejandro Brust
Тема postgres 9.2 error whit apostrophes
Дата
Msg-id 51B78F2B.4060107@pasteleros.org.ar
обсуждение исходный текст
Ответы Re: postgres 9.2 error whit apostrophes  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: postgres 9.2 error whit apostrophes  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-admin
Hello, excuse my English first

we recently move from pg9.0 to pg 9.2 whit this method:

from a new server PG9.2 we did:
pg_dump -h server -p 5432 -U user -Fc -i -b base-name > bk.backup

after that in the new server
createdb -T template0 -E LATIN1 basename
pg_restore -h server -p 5432 -U user -d basename bk.backup

now we are having problems with updates on tables  whit apostrophes like  >> o'higgins << on any character fields
First question:
            is there  any configurable parameter for PG9.2 that make 
            update tu02t00 set tu02pfusua = 'D'AGOSTINO'  work...
            the server error said   
ERROR: syntax error at or near "AGOSTINO" at character 187

Second question:
If there is no way to configure PG9.2 to accept this Cain of update
which is the best method to do a downgrade from 9.2 to 9.0 (we are not using any new function)


thanks in advance is ok?



В списке pgsql-admin по дате отправления:

Предыдущее
От: dx k9
Дата:
Сообщение: rpm centos 9.1.9 upgrade
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: postgres 9.2 error whit apostrophes