[PLUG-TALK] Finding PHP Expert

Aaron Burt aaron at bavariati.org
Thu Apr 7 18:19:31 UTC 2011


On Thu, Apr 07, 2011 at 08:54:57AM -0700, Rich Shepard wrote:
>    My travels to get CMS Made Simple working again with postgres-9.x keep
> running into dead ends. The CMSMS folks showed me it's not an issue with
> their application, and the postgres folks showed me it's not an issue with
> the back end. That brought me to the ADOdb layer which, according to its Web
> site, does not explicitly have support for 9.x. <snip>

1. There is a difference between "local" and network connections with
Postgres.  When you tested the connection with psql, did you specify the
exact same hostname (with -h) as your PHP code uses?  If you didn't, you
made a "local" connection.

2. Google tells me there's a protocol change for Postgres 9 regarding the
default encoding of bytearrays.  See:
http://stackoverflow.com/questions/4828266/what-has-changed-between-postgres-jdbc-8-4-and-9-regarding-bytearrays
and:
http://www.postgresql.org/docs/9.0/static/runtime-config-client.html#GUC-BYTEA-OUTPUT
If you can set the encoding to "escape" on the client or server, you might
be OK.

3. Can you use Postgres 8.4 instead?




More information about the PLUG-talk mailing list