"David Boesch" <[EMAIL PROTECTED]> writes:
> I add data to reference > > select * from reference shows as > > id | name | description > ----+----------------+-------------------------------- > 11 | rd | road > 12 | st | street > 13 | way | way > 14 | close | close > 15 | bend | bend > 3 | vic | victoria > 4 | nsw | new south wales > 5 | qld | queensland > 6 | nt | northern territory > 7 | sa | south australia How did you add this data? Given that the ids are out of order I assume you've updated or deleted and re-inserted records a few times? That shouldn't break anything but it's possible the insert on table a doesn't see the same version of this table that you're looking at with the select. Also, just to check that there's nothing wrong with the inex, what do you get if you do: enable_seqscan = off; select * from reference where id = 7; -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
