Re: ALTER TYPE ... ADD VALUE issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Victor Yegorov <vyegorov(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ALTER TYPE ... ADD VALUE issue
Date: 2014-10-20 19:03:24
Message-ID: 16634.1413831804@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Victor Yegorov <vyegorov(at)gmail(dot)com> writes:
> 2014-10-20 21:43 GMT+03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
>> 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.

psql knows not to issue BEGIN before a VACUUM command. It doesn't
know that about ALTER TYPE ... ADD VALUE.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-10-20 19:18:13 Re: ALTER TYPE ... ADD VALUE issue
Previous Message Victor Yegorov 2014-10-20 18:50:08 Re: ALTER TYPE ... ADD VALUE issue