RE: [PEAR] DB_DataObject 1.8.4 class generator don't get the primary keys from PostgreSQL

Bryn, I figure out a solution to this problem, once I'm using schemas on PostgreSQL the solution had to be with the strip schema option disabled. So after some hacking in the pgsql.php I discover that the select used did not lead in consideration the tables namespace (schema). Then I introduced the join with the namespace schema that solved the problem. Now I have my primary keys generated on the too cases, with and withou the strip eschema. If you want, I can give to you my pgsql.php version. So I dont know how to publish the solution. Thanks, Edvan Cunha On Thu, 2006-05-04 at 18:18 -0400, Bryn Forbes wrote: > I had this problem and I think I fixed it by using the strip schema > option in the db_dataobject.ini file > Because it was having trouble with getting the keys for public.tablename > > Sorry I don't have a more definitive answer for you this was a while ago > that I had this issue. > > Bryn > > -----Original Message----- > From: Edvan [mailto:edvan@interativainternet.com.br] > Sent: Wednesday, May 03, 2006 12:03 PM > To: pear-general@lists.php.net > Subject: [PEAR] DB_DataObject 1.8.4 class generator don't get the > primary keys from PostgreSQL > > I'm trying to generate the DataObject classes with the new 1.8.4 version > of > BD_DataObject and the primary keys of my tables aren't generated. I've > tried > to set generator_no_ini parameter to false and the myDbName.ini file was > without the primary keys set for any table. I'm using PHP 5 + PostgreSQL > 7.4.1 (I've tryed the 8.1 but migrated to 7.4.1 to test). Can anyone > help-me? > Thanks, > > Edvan Cunha