DB_DataObject with PostgreSQL Schemas
| From: | Mark Mitchenall | Date: | Thu, 05 Feb 2004 02:42:15 +0000 |
| Subject: | DB_DataObject with PostgreSQL Schemas | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-10514@lists.php.net to get a copy of this message | ||
Hi,
I'm having a great time using DB_DataObject, but I have one question with regard to PostgreSQL schemas. I've been using the createTables.php script to auto-build the dataobject subclasses I need, but this function doesn't take the schemas into account, so with a database which has the following tables...
public.table1
public.table2
nonpublic.table3
... I get three subclasses which just have the table name and don't include the schema name, both in the filename and the $__table property.
This doesn't seem to be a huge problem on the whole, but it would be nice if it was included and I wondered if anyone else had views on this. For example, should I be worried about this, or am I just being silly? And if I should be worried about it, should I just modify the autobuild code by hand to include the schema name.
It's late and I've been coding too long today so I'm worried I'm not thinking far enough ahead.
TIA for any consideration...
Best,
Mark
--
Mark Mitchenall, Standingwave Ltd
(Complete Hosting and Development Services)
Tel := +44 (0)20 8452 3031
Email := mark@standingwave.co.uk mark@mitchenall.com
Home := http://www.standingwave.co.uk http://www.mitchenall.com