Well they don't necessarily have the same value!
It's a dictionary with cross-referenced words, e.g. 'bring' and
'brought' are both headwords in the dictionary, but 'brought' is
cross-referenced to 'bring'. So, the table stores the information (using
integer id's rather than words) that
bring: bring
brought: see bring
sing: sing
sang: see sing
etc.
Sue
Chris wrote:
Sue Fitt wrote:
Thanks Chris and Chris, you've solved it.
I had a gui open that connects to the database. It was doing nothing
(and not preventing me adding to or altering headwords_core via
psql), but having closed it the table is instantly created. Weird.
BTW, referencing the same column twice is deliberate, it's a
cross-reference.
The same column and the same table?
Same column different table I could understand but not the same column
& table ;)
I'm sure there's a reason for it though :)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
