Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!pt.cs.cmu.edu!andrew.cmu.edu!bg0l+
From: bg0l+@andrew.cmu.edu (Bruce E. Golightly)
Newsgroups: comp.databases
Subject: Re: question about ingres star
Message-ID: <EYkVVby00WB288Fdks@andrew.cmu.edu>
Date: 17 Jul 89 17:33:27 GMT
Organization: Carnegie Mellon, Pittsburgh, PA
Lines: 13

Did you try including the LOCATION=location_name clause in the create?
It wasn't clear from your message. According to the manual I have, the
syntax is:

CREATE TABLE [locations:]linkname
    (columnname format [,columnname format...])
  [ WITH
      [NODE=nodename, DATABASE=dbname,]
      [TABLE=tablename,]
      [LOCATION=locationname,]
      [JOURNALING]
  ]
Bruce