Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: "Willy-Bas Loos" <willybas(at)gmail(dot)com>, PostGIS Users Discussion <postgis-users(at)postgis(dot)refractions(dot)net>
Subject: Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)
Date: 2012-08-29 15:23:47
Message-ID: 201208291723.47700.andres@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2012-08-29 15:34:33 Re: Views versus user-defined functions: formatting, comments, performance, etc.
Previous Message Tom Lane 2012-08-29 15:18:06 Re: using vars in ddl in procedure call