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 201208291723.47700.andres@2ndquadrant.com
Whole thread Raw
In response to [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>)
Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Wednesday, August 29, 2012 04:44:14 PM Willy-Bas Loos wrote:
> Hi,
>
> pg_dump -s should use add_geometrycolumn(...) instead of creating a
> column+constraints with normal DDL
> Because, when you don't dump the data, then the record in geometry_columns
> is lost.
That shouldn't be a problem with postgres 2 anymore as far as I understand
things?

Greetings,

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: using vars in ddl in procedure call
Next
From: Dmitriy Igrishin
Date:
Subject: Re: Views versus user-defined functions: formatting, comments, performance, etc.