Re: ERROR: Cannot determine geometry type (empty table). - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: ERROR: Cannot determine geometry type (empty table).
Date
Msg-id 20060223220759.GA54436@winnie.fuhr.org
Whole thread Raw
In response to Re: ERROR: Cannot determine geometry type (empty table).  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
On Thu, Feb 23, 2006 at 02:54:48PM -0700, Michael Fuhr wrote:
> I'd guess you're trying to dump an empty table.

Or maybe you're issuing a query that returns no rows.

% psql -d postgis -c 'select max(gid) from feb3'
 max
-----
   2
(1 row)

% pgsql2shp postgis 'select * from feb3 where gid > 2'
Preparing table for user query... Done.
Initializing... ERROR: Cannot determine geometry type (empty table).

--
Michael Fuhr

pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: ERROR: Cannot determine geometry type (empty table).
Next
From: Andy Shellam
Date:
Subject: Re: PGPASSWORD