On Wed, 18 Apr 2007, Richard Huxton wrote:
And at the end of the day that's the root of the problem. It's easy to be lulled into "well it looks like a primary key" rather than being able to guarantee it.
In some of these cases it is guaranteed to be a primary key given all available information at the time. The funny thing about unexpected changes to a business model is that you never expect them.
-- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
