Tom Lane wrote: > Actually, no, I'd prefer not to make such a distinction; I'd be happy > with SQL-level PREPARE being nontransactional. I'd be willing to put > up with that distinction if someone shows it's needed, but so far > there's not been a really good argument advanced for it, has there?
Has anyone reviewed the standard with regards to embedded SQL PREPARE? It would be pretty weird if that behaved differently from the direct SQL PREPARE. (The brief summary is that is does not roll back, but there may be subtleties if have not found.) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]