| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | <A(dot)Bhattacharya(at)sungard(dot)com> <A(dot)Bhattacharya(at)sungard(dot)com> |
| Cc: | <magnus(at)hagander(dot)net>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Performance issue |
| Date: | 2010-04-27 13:21:43 |
| Message-ID: | DEDD3849-68B1-4D7E-A413-36E4A3F595F7@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 27 Apr 2010, at 11:15, <A(dot)Bhattacharya(at)sungard(dot)com> <A(dot)Bhattacharya(at)sungard(dot)com> wrote:
> 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
--
Screwing up is an excellent way to attach something to the ceiling.
!DSPAM:737,4bd6e4f110411684215286!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Rembiałkowski | 2010-04-27 13:30:11 | lc_ctype does not work on windows ? |
| Previous Message | Chris Barnes | 2010-04-27 13:12:19 | Re: pg_hba.conf |