Digital Wokan wrote:
>
> I am absolutely floored that this bug still exists. I submitted a fix
> for the apostrophe insertion problem back around Mandrake 8.0 and the
> cooker for 8.1 and I'm still forced to fix this thing myself every time
> I update my PostgreSQL RPMs.
>
> File: /usr/share/pgsql/pgaccess/lib/tables.tcl
> Lines 546-549...
> lappend PgAcVar(mw,$wn,newrec_fields) "\"$fld\""
> regsub -all {'} $fldval '' fldvalfixed
> lappend PgAcVar(mw,$wn,newrec_values) '$fldvalfixed'
> # Remove the untouched tag from the object
>
> Line 547 (regsub...) is inserted in the original program to fix a
> problem with using apostrophes when entering a new record to a table.
> Line 548 is altered to enter this fixed value into the PGSQL server
> without affecting the appearance of the user's entry in the GUI.
Fixed in 7.2-13mdk
Thanks,
Chris