Re: pg_migrator and an 8.3-compatible tsvector data type

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: pg_migrator and an 8.3-compatible tsvector data type
Дата
в 19:26:56
Msg-id
200905282226.n4SMQq528296@momjian.us
Ответ на
Список
Дерево обсуждения
pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Josh Berkus <josh@agliodbs.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Zdenek Kotala <Zdenek.Kotala@Sun.COM>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Zdenek Kotala <Zdenek.Kotala@Sun.COM>
Re: pg_migrator and an 8.3-compatible tsvector data type Josh Berkus <josh@agliodbs.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Josh Berkus <josh@agliodbs.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Greg Stark <stark@enterprisedb.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Dimitri Fontaine <dfontaine@hi-media.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Greg Stark <stark@enterprisedb.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Greg Stark <stark@enterprisedb.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Greg Stark <stark@enterprisedb.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Robert Haas <robertmhaas@gmail.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Josh Berkus <josh@agliodbs.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Greg Stark <stark@enterprisedb.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Alvaro Herrera <alvherre@commandprompt.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Alvaro Herrera <alvherre@commandprompt.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Bruce Momjian <bruce@momjian.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Alvaro Herrera <alvherre@commandprompt.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_migrator and an 8.3-compatible tsvector data type Andrew Dunstan <andrew@dunslane.net>
Re: pg_migrator and an 8.3-compatible tsvector data type Josh Berkus <josh@agliodbs.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: pg_migrator and an 8.3-compatible tsvector data type Greg Stark <stark@enterprisedb.com>
Re: pg_migrator and an 8.3-compatible tsvector data type Greg Smith <gsmith@gregsmith.com>
Tom Lane wrote:
> Bruce Momjian  writes:
> > Josh Berkus wrote:
> >> Given that it's going to prevent users of Tsearch from 
> >> upgrading-in-place, the format change ought to be giving us some serious 
> >> gains.  Otherwise we should put it off until we need to make other 
> >> datatype changes.
> 
> > No idea but now that we are in beta we would then be invalidating beta
> > tester data.  The area I got stuck on is that there is no CAST behavior
> > when creating an index.  We are already invalidating GIN indexes, but I
> > can't even create an index to support the old data type.
> 
> It's certainly doable.  Bruce is just applying the strategy he mentioned
> in our talk ;-)

Kind of --- I am stuck because we don't auto-cast for index usage like
we do for function calls and operators, so I will just keep going and
disable tsvector.

--  Bruce Momjian          http://momjian.us EnterpriseDB                             http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +

В списке pgsql-hackers по дате отправления
От: Josh Berkus
Дата:
От: Tom Lane
Дата:
FAQ