Postgres Pro
Downloads
Home   >   mailing lists

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

From Willy-Bas Loos
Subject [postgis-users] pg_dump -s should use add_geometrycolumn(...)
Date
Msg-id CAHnozTinp8USvfmwA4GMVrbCToxmpTvOR10DJzxLxfWfPy+m2Q@mail.gmail.com
Whole thread Raw
Responses Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...)  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Sébastien Lorion
Date:
Subject: Problem with initdb and ephemeral drives when rebooting
Next
From: Chris Angelico
Date:
Subject: Re: Understanding autocommit