Skip site navigation (1) Skip section navigation (2) oddity with apostrophes

From: Charles Curley <ccurley(at)trib(dot)com>
To: pgsql-novice(at)postgreSQL(dot)org
Subject: oddity with apostrophes
Date: 2000-08-26 16:42:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I am using with perl to interface between a web server,
Apache, and postgres. is as follows:

# $Id:,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 problem.


		-- C^2

No windows were crashed in the making of this email.

Looking for fine software and/or web pages?


pgsql-novice by date

Next:From: Webb SpragueDate: 2000-08-26 17:33:19
Subject: Re: oddity with apostrophes
Previous:From: Tom LaneDate: 2000-08-26 16:42:06
Subject: Re: Failure to COMMIT -- Timeout?

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