| From: | "Bayless Kirtley" <bkirt(at)cox(dot)net> |
|---|---|
| To: | "Alban Hertroys" <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, <A(dot)Bhattacharya(at)sungard(dot)com> |
| Cc: | <magnus(at)hagander(dot)net>, "List, Postgres" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Performance issue |
| Date: | 2010-04-27 14:31:56 |
| Message-ID: | 3CE2928AB9F8455DBB91DA4B537D2BB4@dell2400 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Thanks a lot for your help. However I am new to Postgres database
> therefore it would be nice if you can let me know how to set autocommit
> off.
> I know from psql client issuing “\set Autocommit Off” would set it off but
> unfortunately it doesn’t set it off.
It's a client-side setting, not a server-side one. Hence you need to turn it
off in your java program, probably in the database connection settings.
P.S. Your message was so mangled that I couldn't find which part of the
original message you were referring to, so I deleted the remainder.
Top-posting is considered bad form in mailing-lists.
Alban Hertroys
--------------------------------------------------------------------------------------------------------
Actually, top posting is considered bad form in THIS mailing list. All the
others I participate in top post regularly. That said though, it is
considered good form to post in the manner expected by the list that one is
posting to. ;-)
Bayless
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-04-27 15:02:16 | Re: invalid abstime to timestamp error only on specific date range |
| Previous Message | Merlin Moncure | 2010-04-27 14:31:13 | Re: PostgreSQL Performance issue |