From: Bernard Henry Voynet <bhv@quebecemail.com>
To: pgsql-sql@postgresql.org
Subject: Unwanted nested dollar-quoted constants
Date: Sat, 20 Aug 2005 12:27:15 -0700 (PDT)
Message-ID: <20050820122715.D2B562D6@dm22.mta.everyone.net> (raw)
Hello,
I recurrently need to migrate a big amount of data from one database type to PostgreSQL 8.0.3.
For this, I use INSERT scripts that I run from the pgAdmin III.
All the text fields are specified using the dollar-quoted string constant form that.
However, sometime, there are records that include some text that look like a nested tagged dollar-quoted constant start (eg. $EN$) without its ending conterpart.
In such situation, the whole set of records is refused (without any error telling where and what).
I have tried to insert a '\' char in front of each '$' which, of course, did ot work since they are not treated as is.
So, what can I do to say that it is not a start of a new nested tagged dollar-quoted constant ?
Or is there any way to disable nested tagged dollar-quoted constant ?
Best regards
_____________________________________________________________
Obtenez aussi votre adresse electronique gratuite de
Quebecemail.com http://www.quebecemail.com, un service gratuit et permanent.
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-sql@postgresql.org
Cc: bhv@quebecemail.com
Subject: Re: Unwanted nested dollar-quoted constants
In-Reply-To: <20050820122715.D2B562D6@dm22.mta.everyone.net>
* 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