X-Original-To: pgsql-php-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BD8F19FA491 for ; Wed, 2 Aug 2006 13:29:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 68521-03 for ; Wed, 2 Aug 2006 13:29:05 -0300 (ADT) X-Greylist: delayed 00:22:40.194087 by SQLgrey- Received: from smtp.electronicbox.net (smtp.electronicbox.net [69.28.239.23]) by postgresql.org (Postfix) with ESMTP id DA73D9F9B01 for ; Wed, 2 Aug 2006 13:29:05 -0300 (ADT) Received: from [192.168.0.171] (219.49-ppp.3menatwork.com [64.235.219.49]) by smtp.electronicbox.net (Postfix) with ESMTP id 4A02425ED04 for ; Wed, 2 Aug 2006 12:58:01 -0300 (SRT) Message-ID: <44D0CD59.8090008@gmail.com> Date: Wed, 02 Aug 2006 12:05:45 -0400 From: hunkybill@gmail.com Reply-To: hunkybill@gmail.com User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Problem with columns of type Text and Drupal/Prado/PHP5 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.23 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, NO_REAL_NAME, SPF_NEUTRAL X-Spam-Level: ** X-Archive-Number: 200608/4 X-Sequence-Number: 3575 Hi, My software for context: CentOS 4.3 Linux PHP 5.1 Prado 2.1 Drupal 4.72 PostgreSQL 8.1.4 I use Prado, an advanced PHP5 framework which maintains a viewstate (session data) which is essentially a lot of text (possibly containing some binary data). I also use Drupal for my content management system, which has support for PostgreSQL, but mainly mysql. Examining the database storage for PHP sessions, it uses a column marked as TEXT to store session data. In my case of integrating not only Drupal, but Prado, I have extra data from Prado being saved into the session table. With mysql, columns of type TEXT are actually BLOBS. When running Drupal and Prado with mysql, session management works fine. With Drupal, Prado and pgsql however, I have a serious problem. It appears that in the Prado viewstate are some characters (binary??) that offend the pgsql TEXT column and write errors occur whereby not all the text is written to the session table, resulting in instability. There is a point in the text stream where some binary data probably causes an EOF or something? Since mysql TEXT columns are really just BLOBS, and they work fine with the viewstate data, is there a way to just change the column type from TEXT to something akin to a BLOB column in pgsql so that I can use pgsql instead of mysql? I examined the docs and it seems there is no easy way to just define a column as holding binary data for simple read/write operations. I am hoping there is a simple solution to swapping a column of type TEXT so that I can continue to integrate Drupal with Prado. I use Creole and Propel as my ORM system and have verified that PHP is not the problem, but it is the actual attempt to write to the pgsql column of type TEXT. I hope that is clear enough to garner some useful suggestions!! Thanks Dave