AutoCommit and DDL
От | Don Drake |
---|---|
Тема | AutoCommit and DDL |
Дата | |
Msg-id | 6c21003b050226125634e9964@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: AutoCommit and DDL
|
Список | 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
В списке pgsql-sql по дате отправления: