Search Postgresql Archives

Re: ALTER TYPE ... ADD VALUE issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: ALTER TYPE ... ADD VALUE issue
From: Victor Yegorov <vyegorov@xxxxxxxxx>
Date: Mon, 20 Oct 2014 21:50:08 +0300
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <544557E9.4090201@aklaver.com>

2014-10-20 21:43 GMT+03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:

With \set AUTOCOMMIT off the COMMIT ended one transaction block and started another.

I don't think `COMMIT` starts a new transaction block here,

as I can run `VACUUM` after it, and vacuum also cannot be run inside transaction block.

--
Victor Y. Yegorov

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: ALTER TYPE ... ADD VALUE issue
  - From: Tom Lane

References:
- ALTER TYPE ... ADD VALUE issue
  - From: Victor Yegorov
- Re: ALTER TYPE ... ADD VALUE issue
  - From: Adrian Klaver

Prev by Date: Re: ALTER TYPE ... ADD VALUE issue
Next by Date: Re: ALTER TYPE ... ADD VALUE issue
Previous by thread: Re: ALTER TYPE ... ADD VALUE issue
Next by thread: Re: ALTER TYPE ... ADD VALUE issue
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux