From: Alejandro Brust <alejandrob@pasteleros.org.ar>
To: pgsql-admin@postgresql.org
Subject: Re: postgres 9.2 error whit apostrophes >>> SOLVED
Date: Thu, 13 Jun 2013 18:54:24 -0300
Message-ID: <51BA3F90.8020204@pasteleros.org.ar> (raw)
In-Reply-To: <A737B7A37273E048B164557ADEF4A58B17BB21BE@ntex2010a.host.magwien.gv.at>
References: <51B78F2B.4060107@pasteleros.org.ar>
<A737B7A37273E048B164557ADEF4A58B17BB21BE@ntex2010a.host.magwien.gv.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
ok
developers = bad guys
no way to modify the source code of applications or use the correct
JDBC........ so,
standard_conforming_string = off
backslash_quote = on
client_encoding = "same as DB"
its no the best way but.... it works
thank U all for yours help (this really guide me)
El 12/06/2013 04:03, Albe Laurenz escribió:
> Alejandro Brust wrote:
>> 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)
> This statement didn't work in any version of PostgreSQL.
>
> I'm guessing that the statement really was:
> UPDATE tu02t00 SET tu02pfusua = 'D\'AGOSTINO'
> (notice the backslash).
>
> That would have worked in PostgreSQL 9.0 with default configuration
> (and given you a warning), but won't work with PostgreSQL 9.2.
>
> If that is your problem, you can set standard_confirming_strings = off
> to restore the old behaviour.
>
> It would be much better, though, to adapt your program to use
> standard conforming strings, like this:
> UPDATE tu02t00 SET tu02pfusua = 'D''AGOSTINO'
>
> Yours,
> Laurenz Albe
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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 >>> SOLVED
In-Reply-To: <51BA3F90.8020204@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