From: | leif(at)lako(dot)no |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #8157: pg_dump and pg_dumpall fail when extension postgis_tiger_geocoder is installed |
Date: | 2013-05-14 08:19:51 |
Message-ID: | E1UcASd-0005m4-SQ@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 8157
Logged by: Leif Gunnar Erlandsen
Email address: leif(at)lako(dot)no
PostgreSQL version: Unsupported/Unknown
Operating system: Linux Fedora 18
Description:
-bash-4.2$ psql
psql (9.3beta1)
Type "help" for help.
postgres=# 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=# \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 "="
LINE 1: ...rd, token, is_custom FROM tiger.pagc_gaz is_custom=true) TO ...
^
pg_dump: [archiver (db)] query was: COPY (SELECT id, seq, word, stdword,
token, is_custom FROM tiger.pagc_gaz is_custom=true) TO stdout;
pg_dumpall: pg_dump failed on database "postgres", exiting
-bash-4.2$ which pg_dumpall
/usr/pgsql-9.3/bin/pg_dumpall
From | Date | Subject | |
---|---|---|---|
Next Message | csibe1985.12 | 2013-05-14 11:38:12 | BUG #8159: PostgreSQlk is not working |
Previous Message | Amit Kapila | 2013-05-14 05:58:47 | Re: Odd Behavior After Multiple Deletes |