On 8/10/06, Chris <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
