El 11/06/2013 18:42, Scott Marlowe escribió: > On Tue, Jun 11, 2013 at 2:57 PM, Alejandro Brust > <alejandrob@xxxxxxxxxxxxxxxxx> wrote: >> 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) > That shouldn't work in any version of postgresql. > > Two ways to insert that. > > 1: escape it: > update tu02t00 set tu02pfusua = 'D''AGOSTINO' ... > > 2: Use $$ quotes: > > update tu02t00 set tu02pfusua = $$D'AGOSTINO$$ ... > YES, from psql that work great I will explain more, we were using a jdbc7 from genexus(developers IDE), with PG9.0 and it works now we upgrade to pg9.2 without migrate the jdbc7 from genexus because it seem donsnt work on genexus(developers problem, i know), but this is the actual scenario so, is any clue? Server encoding? client encoding? thank in advance!! -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
