Re: Does converting an indexed varchar to text rewrite its index?Docs say so, tests say no. - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Does converting an indexed varchar to text rewrite its index?Docs say so, tests say no.
Date
Msg-id 930f256d79d92d07db9dd9f7415f688c35631025.camel@cybertec.at
Whole thread Raw
In response to Does converting an indexed varchar to text rewrite its index? Docssay so, tests say no.  (Mike Lissner <mlissner@michaeljaylissner.com>)
List pgsql-general
On Thu, 2020-01-23 at 08:55 -0800, Mike Lissner wrote:
> I think the docs say that if you convert a varchar to text, it'll rewrite the index,
> but my test doesn't seem to indicate that. Is the test or the documentation wrong?
> 
> If the docs, I'll be happy to make a fix my first contribution to postgresql. :)
> 
> Here are the docs:
> 
> (https://www.postgresql.org/docs/10/sql-altertable.html)

We'd be happy about a documentation patch.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-general by date:

Previous
From: Tanja Savic
Date:
Subject: RE: PostgresSQL 10 on remote server - Socket is not connected(0x00002749/10057)
Next
From: Phil Fisher
Date:
Subject: Re: Clarification of documentation detail for upgrading minor version