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
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
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
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
