Thanks. I went ahead and created the primary key as directed. Still no luck. I created this mini-screencast so you can see what I'm talking about<br><a href="http://screencast.com/t/9WMkHN56e">http://screencast.com/t/9WMkHN56e</a><br>

<br>and adding on a few more seconds, here:<br><a href="http://screencast.com/t/DCjs2OXsew">http://screencast.com/t/DCjs2OXsew</a><br><br>and a quick screenshot here, showing the data<br><a href="http://screencast.com/t/fImccBVh">http://screencast.com/t/fImccBVh</a><br>

<br>(sorry, I didn't get all that in one pass.)<br><br>I should add that the original Maryland Legislative district is here:<br><a href="http://planning.maryland.gov/PDF/Redistricting/2010zip/Legislative_shape.zip">http://planning.maryland.gov/PDF/Redistricting/2010zip/Legislative_shape.zip</a><br>

<br>The PRJ file reads as follows<br>GEOGCS["GCS_GRS_1980",DATUM["D_GRS_1980",SPHEROID["GRS_1980",6378137,298.2572221]],PRIMEM["Greenwich",0],UNIT["Degree",0.0174532925199433]]<br>

<br><br>Oddly enough, also, the legislature_final file ALSO doesn't list primary key, but it displays anyhow. In this case, I've selected the ones with area > 25, because I thought they'd be more likely to buffer successfully...<br>

<br>Anyhow, maybe with the mini-video screencast, it'll be easier to see what I'm talking about.<br><br>Margie<br><br><br><br>Margie<br><br clear="all"><div><div>--</div><div><a href="http://FarmBillPrimer.org" target="_blank">http://FarmBillPrimer.org</a></div>

<a href="http://www.BaltimoreUrbanAg.org" target="_blank">http://www.BaltimoreUrbanAg.org</a> (Please send events; This site is hungry.)<br><a href="http://www.ExcellentNutrition.org" target="_blank">http://www.ExcellentNutrition.org</a><br>

<a href="http://www.packtpub.com/drupal-5-views-recipes/book" target="_blank">http://www.packtpub.com/drupal-5-views-recipes/book</a><br></div>
<br><br><div class="gmail_quote">On Sat, Apr 6, 2013 at 9:28 AM, Richard Greenwood <span dir="ltr"><<a href="mailto:richard.greenwood@gmail.com" target="_blank">richard.greenwood@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote"><div class="im">On Sat, Apr 6, 2013 at 2:18 AM, Margie Roswell <span dir="ltr"><<a href="mailto:mroswell@gmail.com" target="_blank">mroswell@gmail.com</a>></span> wrote:<br>


<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">I've been googling up a storm, now that I've got a local postgis database with QGIS. But still haven't figured out how to display a newly created table. <br>


<br>The query I used to create the table:<br><div style="margin-left:40px">

CREATE TABLE smaller_leg_final AS<br>SELECT ST_Buffer(geom,-500)  AS geom, legislative_final.district<br>FROM legislative_final<br>WHERE area > 30;<br></div><br>I then discovered that I needed a unique ID, and did the following:<br>




<div style="margin-left:40px">ALTER TABLE smaller_leg_final ADD COLUMN id serial not null;<br></div></blockquote><div><br><br></div></div><div>Why don't you try making you unique column a primary key?<br><br>ALTER TABLE smaller_leg_final<br>


  ADD CONSTRAINT smaller_leg_final_pk PRIMARY KEY(id); <br><br></div><div>Rich<br></div></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>