On Sep 7, 2009, at 6:29 PM, Alvar Freude wrote:
I tried to set an "PG_ANYARRAY" or "PG_TEXTARRAY" type manually with
->bind_col(), but this does not help.
Any ideas how I can get an array for this?
Or is there a PostgreSQL Array parser? ;-)
I believe that this is a deficiency in DBD::Pg. Another deficiency is
in its inability to determine that a user-defined type should be
converted to utf8 when pg_enable_utf8 is set, such as for the CITEXT
contrib type (discussion here: http://markmail.org/message/mqqz76vdlxibyoyw#query
:DBD%3A%3APg%20citext+page:1+mid:mqqz76vdlxibyoyw+state:results).
The issue is that DBD::Pg needs to be smarter about identifying data
types and data type categories (citext is of category "S", for string
in 8.4 and later). At least, that's my best guess.
Best,
David
