.
Brent Wood
--- On Sat, 5/9/09, Andreas Neumann a.neum...@carto.net wrote:
From: Andreas Neumann a.neum...@carto.net
Subject: Re: [postgis-users] OIDS, PostGIS and Quantum GIS
To: jp.alcant...@geo-st.com, PostGIS Users Discussion
postgis-users@postgis.refractions.net
Cc: pcr...@pcreso.com
can, of course, use your own names for the table, column amp; index
HTH,
Brent Wood
--- On Sat, 5/9/09, Ben Madinwrote:
From: Ben Madin
Subject: Re: [postgis-users] OIDS, PostGIS and Quantum GIS
To: PostGIS Users Discussion
Date: Saturday, May 9, 2009, 12:23 AM
Juan
--- On Sat, 5/9/09, Ben Madin b...@remoteinformation.com.au wrote:
From: Ben Madin b...@remoteinformation.com.au
Subject: Re: [postgis-users] OIDS, PostGIS and Quantum GIS
To: PostGIS Users Discussion postgis-users@postgis.refractions.net
Date: Saturday, May 9, 2009, 12:23 AM
Juan,
Agreed
are not, but when appropriate convenient, a PK can also be a
QGIS unique identifier.
Brent Wood
--- On Sat, 5/9/09, Andreas Neumann a.neum...@carto.net wrote:
From: Andreas Neumann a.neum...@carto.net
Subject: Re: [postgis-users] OIDS, PostGIS and Quantum GIS
To: jp.alcant...@geo-st.com
HTH,
Brent Wood
--- On Sat, 5/9/09, Ben Madin b...@remoteinformation.com.au
wrote:
From: Ben Madin b...@remoteinformation.com.au
Subject: Re: [postgis-users] OIDS, PostGIS and
Quantum GIS
To: PostGIS Users Discussion postgis-users@postgis.refractions.net
Date: Saturday
Hello,
perhaps this is a silly one, but I'm having a hard time dealing with
primary keys restrictions in Quantum GIS. Not always is possible or
desirable to put a, sometimes, artificial int4 PK in some tables only to
be able to load them in QGIS. Those restrictions are very frustrating.
I have
hm - what's wrong with having a primary key in every table? Good DB-Design
requires primary keys. Other tools will refuse to work with your data if
you don't use primary keys as well. As an example, pgadmin3 requires a
primary key if you want to edit the data in the grid view.
If you use the
as said earlier it's really not that hard to add a colunm with the datatype
serial wich means it will get a unique new value as default.
And if you have a textbased primary key or any other reason for not wanting to
cunstruct a new primary key qgis will be satisfied with a unique value. So just
(qkey);
You can, of course, use your own names for the table, column index
HTH,
Brent Wood
--- On Sat, 5/9/09, Ben Madin b...@remoteinformation.com.au wrote:
From: Ben Madin b...@remoteinformation.com.au
Subject: Re: [postgis-users] OIDS, PostGIS and Quantum GIS
To: PostGIS Users