Re: DB_DataObject and PostgreSQL
| From: | Alan Knowles | Date: | Wed, 22 Oct 2003 04:35:46 +0000 |
| Subject: | Re: DB_DataObject and PostgreSQL | ||
| References: | 1 | Groups: | php.pear.general php.pear.general |
| Request: | Send a blank email to pear-general+get-8532@lists.php.net to get a copy of this message | ||
I know the transactions stuff with mssql works reasonably ok..
eg.
$do->query('BEGIN');
$do->insert();
$do->query('COMMIT');
stored procs should work the same way..
triggers may cause issues if you use staticGet with it's caching feature.
foreign keys are not checked in anyway at present.. - so you may just have to check that $do->insert()/update() return true, if you havent sanitized the data you are updating..
Regards
Alan
Demian Turner wrote:
Hi Just wondering the feasability of using DO with non-mysql features like transactions, stored procs, triggers, foreign keys - has anyone done this? How did it work out? cheers Demian-- Can you help out? Need Consulting Services or Know of a Job? http://www.akbkhome.com