<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>pgsql2shp error(double)</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi, folks:</FONT>
</P>
<P><FONT SIZE=2>I'm trying to do a handy dandy pgsql2shp, and it looks like I've got non-unique rows in my source view. But that's probably using the OID and not the column called 'seq' that I'd prefer pgsql2shp to use as the unique identifier. I have tried making seq part of the view, but I still get</FONT></P>
<P><FONT SIZE=2>error(double) - Record could not be created</FONT>
</P>
<P><FONT SIZE=2>and I believe it comes from the DBFWriteIntegerAttribute check inside of pgsql2shp.c.</FONT>
</P>
<P><FONT SIZE=2>So is there any way to force pgsql2shp to use a column other than OID as the unique identifier? pg_class perhaps?</FONT>
</P>
<P><FONT SIZE=2>Thanks,</FONT>
</P>
<P><FONT SIZE=2>Charlton</FONT>
</P>
<P><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Charlton Purvis</FONT>
<BR><FONT SIZE=2>(803) 777-8858 : voice</FONT>
<BR><FONT SIZE=2>(803) 777-3935 : fax</FONT>
<BR><FONT SIZE=2>cpurvis@sc.edu</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Baruch Institute</FONT>
<BR><FONT SIZE=2>University of South Carolina</FONT>
<BR><FONT SIZE=2>Columbia, SC 29208</FONT>
</P>
</BODY>
</HTML>