| From: | Don Drake <dondrake(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | AutoCommit and DDL |
| Date: | 2005-02-26 20:56:52 |
| Message-ID: | 6c21003b050226125634e9964@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I have a generic function that creates partition tables and their
corresponding indexes and constraints.
I've tested the function using a GUI and it works great. We
implemented in our data loaders (written in perl) and the DB
connections have AutoCommit turned off. When we run it in the perl
script, I see the code being execute to create the tables, etc. but
they are never created, even with a commit at the end. It appears
something is causing the table creation to get rolled back.
I turned AutoCommit on and re-ran the perl script and the tables get
created. Why won't these table's get created when AutoCommit is off?
Why do I have to commit DDL?
I'm running 7.4.3.
Thanks.
-Don
--
Donald Drake
President
Drake Consulting
http://www.drakeconsult.com/
http://www.MailLaunder.com/
312-560-1574
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2005-02-26 21:16:10 | Re: diference in dates in minutes |
| Previous Message | Joel Fradkin | 2005-02-26 20:14:02 | Re: diference in dates in minutes |