Re: MDB - Delete LOB
| From: | Manuel Lemos | Date: | Mon, 09 Jun 2003 13:12:30 +0000 |
| Subject: | Re: MDB - Delete LOB | ||
| References: | 1 2 3 4 5 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-17198@lists.php.net to get a copy of this message | ||
Hello,
On 06/09/2003 07:33 AM, Davide Pj Caironi wrote:
For this reason, the ultimate solution to this problem seems to me involving a trigger.Yes, I have been thinking about a trigger solution too for a while. Although I have not tried it, I think it may be the only viable solution. I am not sure of PostgreSQL procedure language has all that is necessary but it may also solve not only the delete rows with lobs problem but also the update rows with lobs. I just think it is much more complicated than you think because tables may have more than one lob column and each of these columns may have nulls. -- Regards, Manuel Lemos Free ready to use OOP components written in PHP http://www.phpclasses.org/