Login | Register
My pages Projects Community openCollabNet

Discussions > users > [Fwd: SQL issue for 1.5.5]

Project highlights: Stable Version: 1.6.1, Development Version: 1.7.6

current
Discussion topic

Back to topic list

[Fwd: SQL issue for 1.5.5]

Reply

Author hunterm
Full name Hunter Matthews
Date 2003-06-10 08:47:13 PDT
Message -----Forwarded Message-----

From: John Berninger <JohnW@berningero​nline.net>
To: dev at current dot tigris dot org
Subject: SQL issue for 1.5.5
Date: 07 Jun 2003 20:34:09 -0400

Folks -

        One of our testers has found a fairly serious bug in 1.5.5rc1
which actually appears to be a problem with the PyPgsql DB-API module;
it doesn't appear to quote strings correctly. The behavior is noticed
when an RPM contains a file with either a single quote ("'") or a
backslash ("\") in it's name, both of which are valid filename
characters according to POSIX.

        I've added a patch to CVS HEAD to fix this problem by doing the
necessary quoting myself using the string.replace() function. As was
pointed out, this is more of a workaround than an actual solution.

        I'd like some feedback from this list on whether we should
continue to use PyPgsql and accept the "workaround" as a "solution", or
whether the project should switch to Psycopg which according to Hunter's
tests seems to do the necessary string quoting correctly.

        The details of the problem, as I see it, are in an ambiguity in
the Python DB-API, which I won't go into here, but I can in another
email if anyone's interested.

        So, what say you?

--
John Berninger

GPG Key ID: A8C1D45C
        Fingerprint: B1BB 90CB 5314 3113 CF22 66AE 822D 42A8 A8C1 D45C

Sit vis nobiscum.
--

--------------------​--------------------​--------------------​---------
To unsubscribe, e-mail: dev-unsubscribe@curr​ent.tigris.org
For additional commands, e-mail: dev-help at current dot tigris dot org
--
Hunter Matthews Unix / Network Administrator
Office: BioScience 145/244 Duke Univ. Biology Department
Key: F0F88438 / FFB5 34C0 B350 99A4 BB02 9779 A5DB 8B09 F0F8 8438
Never take candy from strangers. Especially on the internet.


--------------------​--------------------​--------------------​---------
To unsubscribe, e-mail: users-unsubscribe@cu​rrent.tigris.org
For additional commands, e-mail: users-help at current dot tigris dot org

« Previous message in topic | 1 of 1 | Next message in topic »

Messages

Show all messages in topic

[Fwd: SQL issue for 1.5.5] hunterm Hunter Matthews 2003-06-10 08:47:13 PDT
Messages per page: