G'day Brent,
I'm forever creating tables as subsets of existing tables so it is a truly
useful function, however, I've suffered the same concerns - perhaps it is worth
pursuing the name being changed?
I've also never really understood the distinction between the populate_ and the
probe_ functi
I foubd this an unfortunately ambiguous name.
it doesn't populate geometry columns so much as update the geometry_columns
table.
But irrespective of the name, it is nice to have :-)
Cheers
Brent Wood
--- On Thu, 5/19/11, Ben Madin wrote:
From: Ben Madin
Subject: Re: [postgis-users] how
Ge,
Try
SELECT Populate_Geometry_Columns();
http://postgis.refractions.net/docs/Populate_Geometry_Columns.html
which promises to truncate the geometry columns table first, then rebuild it.
cheers
Ben
On 18/05/2011, at 8:05 PM, G. van Es wrote:
> Hi Edward,
>
> This will not work bec
The case was the problem.
Thanks Mark
Bob
From: MarkW
Sent: Wednesday, May 18, 2011 12:05 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Invisible Table
Do you mean that the SQL Pane shows this:
CREATE TABLE public."MyTestTable"
( etc... )
Case-sensitivity may be the issue -
Do you mean that the SQL Pane shows this:
CREATE TABLE public."MyTestTable"
( etc... )
Case-sensitivity may be the issue - does your simple sql query include
quotes around the table name?
If it is a case-sensitivity issue and you want to avoid it, the Shapefile
and Dbf gui loader plugin for PGAd
Hi
I imported a shape file using the QGis shapefile to PostgreSQL tool.
The resulting table appears as normal on the PGAdmin Object Browser and in QGis
as spatial geometry.
However the table is not existing according to a simple sql query. Other tables
are seen with no problem.
The only diffe
Hi Edward,
This will not work because this function doesn't do anything with views. Also
stale records aren't removed.
Ge
--- On Wed, 5/18/11, Edward Mac Gillavry wrote:
From: Edward Mac Gillavry
Subject: Re: [postgis-users] how to keep geometry_columns in sync with tables
and views
To: pos
Hi Ge,
You may want to check Probe_Geometry_Columns
(http://postgis.refractions.net/docs/Probe_Geometry_Columns.html).
Kind regards,
Edward
Date: Wed, 18 May 2011 04:38:51 -0700
From: gves2...@yahoo.com
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] how to keep geometry_
Hi All,
We have a lot of tables and views updated, or better said, replaced on a daily
basis. We have seen that under certain conditions (which are unclear) entries
of the geometry_columns table are removed. So a mismatch occurs so now and then
resulting in showing either no data or being very