x27;t I'd deal with that differently.
Thanks.
- Justin
- --
Justin Hawkins Email: [EMAIL PROTECTED] (W)
Systems Programmer/DBA Email: [EMAIL PROTECTED](H)
Internode Systems Pty Ltd Phone: +61-8-82282999
"Sometimes I can hardly s
doing something to the rows, even
before the trigger returns for that iteration causing subsequent
UPDATE's to break in some subtle way.
Any ideas (or workarounds) most appreciated :-)
Pg version is 8.1.0, tried also on 8.0.3 with no difference.
- Justin
--
Justin Hawkins | [EMAIL PROTECTED]
| http://hawkins.id.au
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
y means that if I delete a row in 'the middle'
I need to delete the children myself first. If I let a cascade deal
with that then I don't get the opportunity to update rows further up
the tree to reflect the fact there are now less replies.
I can't see any particular flaw in my
ave to cogitate on it for a while :-)
On the face of it it seems I will have to implement the cascading DELETE
myself, and keep track of how many DELETE's I am doing.
- Justin
--
Justin Hawkins | [EMAIL PROTECTED]
| http://hawkins.id.au
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
