From: | Charles Curley <ccurley(at)trib(dot)com> |
---|---|
To: | pgsql-novice(at)postgreSQL(dot)org |
Subject: | Pg.pm oddity with apostrophes |
Date: | 2000-08-26 16:42:11 |
Message-ID: | 20000826104211.K31166@trib.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am using pg.pm with perl to interface between a web server,
Apache, and postgres. Pg.pm is as follows:
#-------------------------------------------------------
#
# $Id: Pg.pm,v 1.8 1998/09/27 19:12:22 mergl Exp $
#
# Copyright (c) 1997, 1998 Edmund Mergl
#
#-------------------------------------------------------
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc pgcc-2.91.66]
The oddity I have hit is that if I try to inset a name with an apostrophe
in it (e.g. O'Neil), pgsql belly-aches and returns an error of 7. The
record is not inserted. If I remove the apostrophe, the otherwise identical
record goes in just fine. I am escaping the apostrophe correctly, as far
as I know. The insert query is as follows:
Insert into contacts VALUES ( 'Mr.', 'Patrick', 'O\'Neil', blah, blah... 'http://URL' ); "
I can insert the name from psql with no problems, which makes me think it
is a Pg.pm problem.
--
-- C^2
No windows were crashed in the making of this email.
Looking for fine software and/or web pages?
http://w3.trib.com/~ccurley
From | Date | Subject | |
---|---|---|---|
Next Message | Webb Sprague | 2000-08-26 17:33:19 | Re: Pg.pm oddity with apostrophes |
Previous Message | Tom Lane | 2000-08-26 16:42:06 | Re: Failure to COMMIT -- Timeout? |