On 8/10/06, Chris <dmagick@xxxxxxxxx> 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 ;)
create table color(color text); create table person(eye_color text references color(color), hair_color text references color(color)); ;) merlin
