[midgard-user] sql question, midgard related

[Tarjei Huse]

Hi, I deleted a user from my midgard person table, and I need to change all
referenses to the person as an author in other tables. I whant to do that
using sql querys. Does anyone know how?

what I need is something like

UPDATE article.author FROM article WHERE article.id =!'person.id' or
something like that.

I'm realy fxxxx someone did this on our production sys. ;(

Tarjei



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]