From: Alejandro Brust <alejandrob@pasteleros.org.ar>
To: posgres support <pgsql-admin@postgresql.org>
Subject: postgres 9.2 error whit apostrophes
Date: Tue, 11 Jun 2013 17:57:15 -0300
Message-ID: <51B78F2B.4060107@pasteleros.org.ar> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alejandrob@pasteleros.org.ar
Subject: Re: postgres 9.2 error whit apostrophes
In-Reply-To: <51B78F2B.4060107@pasteleros.org.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox