Bug 74149

Summary: Error adding record containing ' character in pgaccess
Product: [Retired] Red Hat Linux Reporter: James Turner <jamesfturner>
Component: postgresqlAssignee: Trond Eivind Glomsrxd <teg>
Status: CLOSED RAWHIDE QA Contact: David Lawrence <dkl>
Severity: medium Docs Contact:
Priority: medium    
Version: 7.3   
Target Milestone: ---   
Target Release: ---   
Hardware: i386   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2002-09-16 23:45:40 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description James Turner 2002-09-16 23:45:29 UTC
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (compatible; Konqueror/3; Linux)

Description of problem:
In pgaccess (postgres-tk package), a "Parse error" message is displayed if you try to add a new record to a table where one of the fields contains a ' (apostrophe) character.

Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
1. Run pgaccess
2. Try to add a new record to a table containing a ' character in one of the text-format fields.
	

Actual Results:  "Parse error" message

Expected Results:  Record added to database table.

Additional info:

The program needs to check for ' characters when constructing the SQL insert statement.

Workaround: Create the record without the ' character, then go back and change it.

Comment 1 Trond Eivind Glomsrxd 2002-09-17 19:45:55 UTC
The newest betas (e.g. Null) no longer contain this package.