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

Re: Pg.pm oddity with apostrophes

From: Charles Curley <ccurley(at)trib(dot)com>
To: Webb Sprague <wsprague100(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgreSQL(dot)org
Subject: Re: Pg.pm oddity with apostrophes
Date: 2000-08-27 01:25:45
Message-ID: 20000826192545.A28579@trib.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Sat, Aug 26, 2000 at 10:33:19AM -0700, Webb Sprague wrote:
> I haven't messed to much with it, but I think that if
> you use two apostrophes like '', that may work to
> escape it.

Thanks. That did not solve the problem.


> 
> --- Charles Curley <ccurley(at)trib(dot)com> 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
> 
> > ATTACHMENT part 2 application/pgp-signature 
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/

-- 

		-- 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: Charles CurleyDate: 2000-08-27 01:28:53
Subject: Re: Pg.pm oddity with apostrophes
Previous:From: Anthony E . GreeneDate: 2000-08-27 00:33:53
Subject: Re: Pg.pm oddity with apostrophes

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