From: Don Drake <dondrake@gmail.com>
To: pgsql-sql@postgresql.org
Subject: AutoCommit and DDL
Date: Sat, 26 Feb 2005 14:56:52 -0600
Message-ID: <6c21003b050226125634e9964@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dondrake@gmail.com
Subject: Re: AutoCommit and DDL
In-Reply-To: <6c21003b050226125634e9964@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox