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

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, PostGIS Users Discussion <postgis-users(at)postgis(dot)refractions(dot)net>
Subject: [postgis-users] pg_dump -s should use add_geometrycolumn(...)
Date: 2012-08-29 14:44:14
Message-ID: CAHnozTinp8USvfmwA4GMVrbCToxmpTvOR10DJzxLxfWfPy+m2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Cheers,

WBL

--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Angelico 2012-08-29 14:51:46 Re: Understanding autocommit
Previous Message Sébastien Lorion 2012-08-29 14:38:32 Problem with initdb and ephemeral drives when rebooting