BUG #8157: pg_dump and pg_dumpall fail when extension postgis_tiger_geocoder is installed - Mailing list pgsql-bugs

From leif@lako.no
Subject BUG #8157: pg_dump and pg_dumpall fail when extension postgis_tiger_geocoder is installed
Date
Msg-id E1UcASd-0005m4-SQ@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8157
Logged by:          Leif Gunnar Erlandsen
Email address:      leif@lako.no
PostgreSQL version: Unsupported/Unknown
Operating system:   Linux Fedora 18
Description:        =




-bash-4.2$ psql
psql (9.3beta1)
Type "help" for help.

postgres=3D# select extname,extowner,extnamespace,extrelocatable,extversion
from pg_extension ;
        extname         | extowner | extnamespace | extrelocatable |
extversion =

------------------------+----------+--------------+----------------+-------=
-----
 plpgsql                |       10 |           11 | f              | 1.0
 postgis                |       10 |         2200 | t              |
2.1.0beta2
 postgis_topology       |       10 |        17668 | f              |
2.1.0beta2
 fuzzystrmatch          |       10 |         2200 | t              | 1.0
 postgis_tiger_geocoder |       10 |        17831 | f              |
2.1.0beta2
(5 rows)

postgres=3D# \q
-bash-4.2$ pg_dump
pg_dump     pg_dumpall  =

-bash-4.2$ pg_dumpall > /dev/null
pg_dump: [archiver (db)] query failed: ERROR:  syntax error at or near "=3D"
LINE 1: ...rd, token, is_custom FROM tiger.pagc_gaz is_custom=3Dtrue) TO ...
                                                             ^
pg_dump: [archiver (db)] query was: COPY (SELECT id, seq, word, stdword,
token, is_custom FROM tiger.pagc_gaz is_custom=3Dtrue) TO stdout;
pg_dumpall: pg_dump failed on database "postgres", exiting
-bash-4.2$ which pg_dumpall
/usr/pgsql-9.3/bin/pg_dumpall

pgsql-bugs by date:

Previous
From: "Hugo J. Curti"
Date:
Subject: Re: BUG #8152: strange behavior regarding after triggers and inheritance
Next
From: bnicholson@hp.com
Date:
Subject: BUG #8160: 9.3 Beta 1 Initdb doesn't work