Gunnlaugur Thor Briem writes:
> SET search_path = "$user"; SELECT public.unaccent('foo');
> SET
> ERROR: text search dictionary "unaccent" does not exist
Meh. I think we need the attached, or something just about like it.
It's barely possible that there's somebody out there who's relying on
se
Yep, a neater workaround for sure!
Cheers,
Gulli
On Wed, Sep 5, 2018 at 2:00 PM Adrian Klaver
wrote:
> On 09/05/2018 01:49 AM, Gunnlaugur Thor Briem wrote:
> > OK, I found the cause of the unaccent dictionary problem, and a
> workaround.
> >
> > It's not the vacuumdb version, not the unaccent v
On 09/05/2018 01:49 AM, Gunnlaugur Thor Briem wrote:
OK, I found the cause of the unaccent dictionary problem, and a workaround.
It's not the vacuumdb version, not the unaccent version, and it's not
even a pg_upgrade problem: I get this error also with PG 9.4.18 running
on the old cluster, wit
OK, I found the cause of the unaccent dictionary problem, and a workaround.
It's not the vacuumdb version, not the unaccent version, and it's not even
a pg_upgrade problem: I get this error also with PG 9.4.18 running on the
old cluster, with both the 10.5 vacuumdb and the 9.4.18 vacuumdb, and I g
On 08/30/2018 09:03 AM, Gunnlaugur Thor Briem wrote:
\dFd unaccent
List of text search dictionaries
Schema | Name | Description
+--+-
public | unaccent |
(1 row)
\dFd+ unaccent
List of text search dictionaries
Schema | Name | Temp
On 08/30/2018 09:03 AM, Gunnlaugur Thor Briem wrote:
\dFd unaccent
List of text search dictionaries
Schema | Name | Description
+--+-
public | unaccent |
(1 row)
\dFd+ unaccent
List of text search dictionaries
Schema | Name | Temp
\dFd unaccent
List of text search dictionaries
Schema | Name | Description
+--+-
public | unaccent |
(1 row)
\dFd+ unaccent
List of text search dictionaries
Schema | Name |Template |Init options| Description
+--
On 08/30/2018 02:24 AM, Gunnlaugur Thor Briem wrote:
Thank you! That got the pg_upgrade to completion. But then during
./analyze_new_cluster.sh vacuum fails thus:
vacuumdb: processing database "dm_test": Generating minimal optimizer
statistics (1 target)
vacuumdb: vacuuming of database "dm_tes
Thank you! That got the pg_upgrade to completion. But then during
./analyze_new_cluster.sh vacuum fails thus:
vacuumdb: processing database "dm_test": Generating minimal optimizer
statistics (1 target)
vacuumdb: vacuuming of database "dm_test" failed: ERROR: text search
dictionary "unaccent" does
On Wed, Aug 29, 2018 at 06:09:53PM +, Gunnlaugur Thor Briem wrote:
> Hi,
>
> I'm trying to upgrade an old PG 9.4 cluster to PG 10, and it's failing on
> creating an index that uses the unaccent(text) function.
>
> That function is part of the unaccent extension, which is installed in the old
Hi,
I'm trying to upgrade an old PG 9.4 cluster to PG 10, and it's failing on
creating an index that uses the unaccent(text) function.
That function is part of the unaccent extension, which is installed in the
old DB cluster. I expect pg_upgrade to create that extension as part of the
upgrade. It
11 matches
Mail list logo
