Using DataObject with Posgres

From: Date: Fri, 31 Oct 2003 13:33:45 +0000
Subject: Using DataObject with Posgres
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-8701@lists.php.net to get a copy of this message
Hi I've been porting mysql code to posgres and it's worked without any hitches as far as DataObject is concerned. Just two questions: 1. using the latest DO, when I generate the entity classes from MySQL I get the following:
    var $id;                              // int(5)  not_null primary_key
    var $date_created;                    // datetime(19)  not_null
    var $last_updated;                    // datetime(19)  not_null
    var $gid;                             // int(5)  not_null
    var $username;                        // string(64)  not_null
    var $password;                        // string(16)  not_null
however the same schema on postgres gives:
    var $id;                              // int4(4)  not_null unique primary
    var $date_created;                    // timestamp(8)
    var $last_updated;                    // timestamp(8)
    var $gid;                             // int4(4)
    var $username;                        // varchar(-1)
    var $password;                        // varchar(-1)
The problem is the varchars, every single one of them comes out as -1. Is this a user error or perhaps a DO bug? 2. I've also ran my postgres app on DO entities generated from mysql and it worked fine, is this expected? PHP 4.3.2 MySQL 4.0.12 Postgres 7.2.1 Platform windows cheers Demian

« previous php.pear.general (#8701) next »