Postgres Pro
Downloads
Home   >   mailing lists

Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...) - Mailing list pgsql-general

From Andres Freund
Subject Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)
Date
Msg-id 201208291746.04016.andres@2ndquadrant.com
Whole thread Raw
In response to Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
Tree view 
On Wednesday, August 29, 2012 05:41:07 PM Willy-Bas Loos wrote:
> On Wed, Aug 29, 2012 at 5:23 PM, Andres Freund
<andres@2ndquadrant.com>wrote:
> > That shouldn't be a problem with postgres 2 anymore as far as I
> > understand things?
Argh, postgis 2.

Two things:
* the geometry_columns table is not a table anymore but a view of the postgres
catalogs
* extensions (9.1+, used by postgis 2 onwards) can declare configuration
tables now, so even if you would still need a configuration table it would get
dumped in a schema only dump

Also, adding postgis support into pg_dump would have been problematic given
that pg_dump is part of core postgres and postgis isnt...

Andres


--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)
Next
From: Nicola Cisternino
Date:
Subject: Re: String comparision in PostgreSQL