Bruce Momjian <pgman@candle.pha.pa.us> writes: > Abhijit Menon-Sen wrote: >> By the way, what would lastval() do if an insert trigger inserts a row >> into a table with another serial column?
> It fails, just like it would fail now if the trigger inserted into the > same table that used the trigger, or a rule. If it actually *failed* that would be one thing, but the proposed patch does not do that. It looks more like the philosophy we usually denigrate MySQL for, viz never fail even if you are staring a certain application bug in the face. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly