Postgres Pro
Downloads
Home   >   mailing lists

Re: Converting char to varchar automatically - Mailing list pgsql-general

From Tom Lane
Subject Re: Converting char to varchar automatically
Date
Msg-id 27094.1412702198@sss.pgh.pa.us
Whole thread Raw
In response to Re: Converting char to varchar automatically  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: Converting char to varchar automatically  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-general
Tree view 
Sergey Konoplev <gray.ru@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.

            regards, tom lane

pgsql-general by date:

Previous
From: Jonathan Vanasco
Date:
Subject: Re: faster way to calculate top "tags" for a "resource" based on a column
Next
From: Sergey Konoplev
Date:
Subject: Re: Converting char to varchar automatically