On Sat, Apr 6, 2013 at 10:18 AM, Margie Roswell <[email protected]> wrote: > > The query I used to create the table: > CREATE TABLE smaller_leg_final AS > SELECT ST_Buffer(geom,-500) AS geom, legislative_final.district > FROM legislative_final > WHERE area > 30; > > I then discovered that I needed a unique ID, and did the following: > ALTER TABLE smaller_leg_final ADD COLUMN id serial not null; > > This successfully populated the ID field with unique integers. > > However when I go into QGIS, the Primary Key column offers no options. when > I click into it, it just asks me to choose an SRID, which I believe I've > already done. The table loads, but nothing displays. >
Which version of PostGIS are you using? Could you send the DDL CREATE TABLE syntax? You can get it like this: pg_dump -t tablename --schema-only or copy and paste it from the pgAdmin SQL table pane I have the suspect, thought, that you are using PostGIS < 2.0: in that case you explicitely need to record the metadata in geometry_columns using AddGeometryColumn regards p -- Paolo Corti Geospatial software developer web: http://www.paolocorti.net twitter: @capooti skype: capooti _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
