On Wed, 6 Oct 2004, Devrim GUNDUZ wrote:
> [I say COMMIT on a failed transaction and it looks successful, but isn't.] This is a long standing behavior. Internally a ROLLBACK happens, but commit is reported back to the client. This has only changed in 8.0 to reflect what actually happened. Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match