[EMAIL PROTECTED] writes: > Our friendly psql complains that pg_shadow is a view: > psql:<filename>:11: ERROR: cannot delete from a view > HINT: You need an unconditional ON DELETE DO INSTEAD rule.
Yeah, this is on the open-items list; the DELETE FROM is broken (and was always a pretty bogus approach anyway), but it's not very clear what to do instead. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match