Skip site navigation (1) Skip section navigation (2)

Re: Pg.pm oddity with apostrophes

From: Jesus Aneiros <aneiros(at)jagua(dot)cfg(dot)sld(dot)cu>
To: Charles Curley <ccurley(at)trib(dot)com>
Cc: pgsql-novice(at)postgreSQL(dot)org
Subject: Re: Pg.pm oddity with apostrophes
Date: 2000-08-26 17:40:21
Message-ID: Pine.LNX.4.10.10008261339590.12114-100000@jagua.cfg.sld.cu (view raw or flat)
Thread:
Lists: pgsql-novice
Try '' instead of a single '.

--
Jesus Aneiros Sosa
mailto:aneiros(at)jagua(dot)cfg(dot)sld(dot)cu
http://jagua.cfg.sld.cu/~aneiros

On Sat, 26 Aug 2000, Charles Curley wrote:

> 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


In response to

pgsql-novice by date

Next:From: Jesus AneirosDate: 2000-08-26 17:49:11
Subject: Re: Simple question
Previous:From: Webb SpragueDate: 2000-08-26 17:33:19
Subject: Re: Pg.pm oddity with apostrophes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group