PostgreSQL >= 8.3 seems to have renamed the charsetencoding UNICODE to UTF8. This is not reflected by the actual port of libdbi-drivers, but there are actually patches made by M. Hoenicka residing at sourceforge. Using PostgreSQL >= 8.3 in combination with ports/textproc/refdb (which has libdbi-drivers as dependency) results in a non-operating refdb-system since the refdbd doens't know how to handle 'UTF-8', which needs to be mapped as 'UTF8' by the libdbi-driver/pgsql. The patch is simple, I added a line in drivers/pgsql/dbd_pgsql.c. Maybe the maintainer would please have a look on the several fixes that already have been made by the development crew including this one I mention made by M. Hoenicka (he solved this issue while we have had personal communication). Fix: Apply appended patch. Patch attached with submission follows: How-To-Repeat: Build textproc/refdb with databases.postgresql8[34]-server|client with actual databases/libdbi-drivers. Then fill up the refdb-tables in PostgrSQL with the testdata and try to retrieve references with 'getref'. This will never succeed until you patch libdbi-drivers as mentioned.
Responsible Changed From-To: freebsd-ports-bugs->delphij Over to maintainer (via the GNATS Auto Assign Tool)
State Changed From-To: open->closed Committed, thanks!
delphij 2009-07-20 08:35:01 UTC FreeBSD ports repository Modified files: databases/libdbi-drivers Makefile Added files: databases/libdbi-drivers/files patch-drivers__pgsql__dbd_pgsql.c Log: Use "UTF-8" when "UTF8" is being used. Submitted by: "O. Hartmann" <ohartman zedat fu-berlin de> PR: ports/136856 Revision Changes Path 1.18 +1 -1 ports/databases/libdbi-drivers/Makefile 1.1 +10 -0 ports/databases/libdbi-drivers/files/patch-drivers__pgsql__dbd_pgsql.c (new) _______________________________________________ cvs-all@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/cvs-all To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"