Re: [GENERAL] Rollback on Error

2004-10-08 Thread Michael Paesold
is not the right time now (8.0 beta). Best Regards, Michael Paesold ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] psql + autocommit

2004-09-21 Thread Michael Paesold
Greg Sabino Mullane wrote: > real_psql --set AUTOCOMMIT=OFF $@ I have stumbled over this myself: psql is case-sensitive here at the moment, so it must be --set AUTOCOMMIT=off. Best Regards, Michael ---(end of broadcast)--- TIP 8: explain analyze i

Re: [GENERAL] Rollback on Error

2004-09-19 Thread Michael Paesold
Tom Lane wrote: > "Michael Paesold" <[EMAIL PROTECTED]> writes: > > On the other hand, the scenario of a psql option (read: I have > > given up the idea of a backend implementation) to rollback only > > last statement on error is quite different. > > S

Re: [GENERAL] pg_restore peculiarities

2004-09-18 Thread Michael Paesold
he dlls etc. and not throw everything into template1... perhaps add a feature request at pgFoundry? Best Regards, Michael Paesold ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] psql + autocommit

2004-09-17 Thread Michael Paesold
urse the installation prefix set during configure) I am not at work, so I can have a look at the code or test it myself right now. Best Regards, Michael Paesold -- Supergünstige DSL-Tarife + WLAN-Router für 0,- EUR* Jetzt zu GMX wechseln und sparen http://www.gmx.net/de/go/d

Re: [GENERAL] Join efficiency

2004-09-01 Thread Michael Paesold
e same optimized query plan and are therefore equal performance wise. You can just use the one you prefer. Best Regards, Michael Paesold ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "un