Anyone has an idea? On the subject? ---------- Forwarded message ---------- From: Tom Lane <[EMAIL PROTECTED]> Date: May 12, 2005 5:43 PM Subject: Re: [NOVICE] Autocommit in Postgresql To: Vitaly Belman <[EMAIL PROTECTED]> Cc: Olivier Thauvin <[EMAIL PROTECTED]>, Postgresql Novice <[EMAIL PROTECTED]>
Vitaly Belman <[EMAIL PROTECTED]> writes: > That's the problem... Is there a way to make it implicitly open a > transaction? For example now in pgAdmin when I play with SQLs I have > to do begin and rollback constant because whenever a query fails it > refuses to do anything at all until I "rollback", and then of course I > have to do "begin" again unless I want my queries to be real. pgAdmin really should offer some kind of setting to help you with that. Try asking the pgadmin gurus (I am not sure if any of them read this list). regards, tom lane -- ICQ: 1912453 AIM: VitalyB1984 MSN: [EMAIL PROTECTED] Yahoo!: VitalyBe ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings