Sergey Konoplev <gray...@gmail.com> writes:
> On Tue, Oct 7, 2014 at 10:16 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
>> Sergey Konoplev <gray...@gmail.com> writes:
>>> BTW, where can I find a list of type1->type2 pairs that doesn't
>>> require full table lock for conversion?
>> There aren't any. Sometimes you can skip a table rewrite, but that
>> doesn't mean that a lesser lock is possible.
> Oh, sorry, it was a typo, I meant "that doesn't require a full table rewrite".
Roughly speaking it's the pairs that have a binary (WITHOUT FUNCTION)
coercion according to pg_cast, although we have special logic for a few
cases such as varchar(M) -> varchar(N).
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
