Re: FAQ or so?

From: Ken Johanson <pg-user(at)kensystem(dot)com>
To: elein <elein(at)varlena(dot)com>
Cc: Jean-Christophe Arnu <jx(at)tuxfarm(dot)org>, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: FAQ or so?
Date: 2005-02-23 18:43:03
Message-ID: 421CCEB7.8040101@kensystem.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Along the lines of advocacy, I just posted the below paragraph to the
General mailing list - in my opinion this bug is in the list of
hinderences to adoption of postgres (I know from experience) - it
pertains to a standards compliance issue that's definitely used as an
excuse to not use pg vs the commercial dbs... it would help if someone
could make fixing this be a higher priority by raising awareness, or
something.

#####

"More specifically, I'd like to disable the non-standard backslash
escaping behavior of the server, so that backslashes aren't discarded,
like:

insert into table values ('This won''t work when inserting a \
character'); -> 'This won't work when inserting a character'

Instead I'd like for only single quotes (apostrophes) to server as the
escape character (for themselves), as in the iso/ansi recommendations
-so that the server behaves the same as Oracle, ms, and most other
databases in this regard.

I am living testament to all the users who switched from the 'big'
databases to pg and had the unpleasant surprise of having lost all the
backslashes chars -as well as having to tweak apps to get them to work.

If nothing else, a VERY prominently placed warning on the docs front
page should warn new users of the nonstandard behavior, imo. This can be
a life saver. "

ken

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Jean-Christophe Arnu 2005-02-23 19:35:33 Re: FAQ or so?
Previous Message elein 2005-02-23 18:19:25 Re: FAQ or so?