Re: pgdump (9.2.4) not dumping all tables

to answer to Adrian


1) i am using the old version to dump (i will try with the latest)

2) no the postgis version is different. pg9.2.4->  postgis-2.0.3  and
pg9.3.5->   postgis-2.1.3


3) the schema is public

\d+ al_shared_place

                                                       Table
"public.al_shared_place"
   Column   |         Type          |                           Modifiers
| Storage  | Stats target | Description

------------+-----------------------+---------------------------------------------------------------+----------+--------------+-------------
 id         | integer               | not null default
nextval(('al_landmark_seq'::text)::regclass) | plain    |              |
 x          | character varying(15) |
| extended |              |
 y          | character varying(15) |
| extended |              |
 name       | character varying(50) |
| extended |              |
 placetype  | integer               |
| plain    |              |
 point_geom | geometry              |
| main     |              |
Indexes:
    "al_shared_place_pkey" PRIMARY KEY, btree (id)
    "al_sharedplace_geom_idx" gist (point_geom)
Check constraints:
    "$1" CHECK (srid(point_geom) = 4326)
    "$2" CHECK (geometrytype(point_geom) = 'POINT'::text OR point_geom IS
NULL)
Has OIDs: no







--
View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827747.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.