[postgis-users] pgsql2shp buffer

[Purvis, Charlton]

A little more info . . .

 

I did the same type of query to see if it would run to completion.

 

psql -U xxx-d xxx -c 'select * from wind_prod_to_be_purged;' >
wind_prod_to_be_purged.txt

 

It ran to completion in only about 3 minutes.

 

wind_prod_to_be_purged is a view w/ 580093 rows.  So why would pgsql2shp be
hanging on this?

 

Thanks.

 

  _____  

From: Purvis, Charlton [mailto:cpurvis at asg.sc.edu] 
Sent: Friday, March 25, 2005 2:26 PM
To: 'PostGIS Users Discussion'
Subject: [postgis-users] pgsql2shp buffer

 

Hi, folks: 

I'm curious if pgsql2shp writes to a buffer of some sort before it actually
starts writing to a .dbf.  I'm trying to dump about 0.5 million rows which
shouldn't be too bad and shouldn't take too long.  However, pgsql2shp seems
to sit there w/ only a 1 byte (or KB?) .dbf.  Should I turn on debugging?
I'd hate to recompile PostGIS.

If I type a select * from table_name (the one I'm trying to create the shp
from), it returns w/i a minute or two.  But I'm sure psql is doing buffering
of its own.

postgresql-7.4.1/contrib/postgis-0.8.1 

Thanks, 

Charlton 

  
  
  
Charlton Purvis 
(803) 777-8858 : voice 
(803) 777-3935 : fax 
cpurvis at sc.edu 
  
Baruch Institute 
University of South Carolina 
Columbia, SC 29208 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050325/d1b6209e/attachment.html>