<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.3790.4795" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=343574309-20012011>Dear
friends</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=343574309-20012011></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=343574309-20012011>I have more details
to better explain my problem (composed key):</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=343574309-20012011><SPAN
lang=EN></SPAN></SPAN></FONT> </DIV>
<DIV><FONT><SPAN class=343574309-20012011><SPAN lang=EN><FONT face=Arial
size=2>A composed Primary Key is a key composed by two (or more)
columns.</FONT></DIV>
<DIV>
<P><FONT face=Arial size=2>I'll try to explain with an exanple:</FONT></P>
<P><FONT face=Arial size=2>I have a country with different regions and
sub-regions. Sometimes, these regions are changed. The geometry is different
everytime I have a new version.</FONT></P>
<P><FONT face=Arial size=2>The PK for one region is the column with the RegionID
and the version ID.</FONT></P>
<P><FONT face=Arial size=2>Region (PK) (not unique)</FONT></P>
<P><FONT face=Arial size=2>Version (PK) (not unique)</FONT></P>
<P><FONT face=Arial size=2>Description</FONT></P>
<P><FONT face=Arial size=2>...</FONT></P>
<P><FONT face=Arial size=2>...</FONT></P>
<P><FONT face=Arial size=2>the_geom</FONT></P>
<P><FONT face=Arial size=2>Any subregion must connect to the region, considering
both columns as PK, the region and the version. Somewhere in time that subregion
was linked to one region and then moved to another region and I must keep track
of those changes.</FONT></P>
<P><FONT face=Arial size=2>With this scenario, I can't connect this table to
QGIS.</FONT></P>
<P><SPAN class=343574309-20012011><FONT face=Arial size=2>Best
Regards</FONT></SPAN></P>
<P><SPAN class=343574309-20012011><FONT face=Arial
size=2>Joaquim</FONT></SPAN></P></SPAN></SPAN></FONT></DIV></BODY></HTML>