From: | Isaac Vetter <ivetter(at)math(dot)purdue(dot)edu> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | schema question |
Date: | 2007-12-11 15:57:13 |
Message-ID: | 475EB359.8090307@math.purdue.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi All;
I'm much more of a web developer than dba, that's why I'm asking this of
the novice list.
I've got a database in postgresql 7.4 with 111 tables.
I recently created the 111th table and I cannot create foreign key
constraints.
Postgresql acts like the new table is in a different schema that the
referenced table. Additionally, if I go back to a previously created
table and try to rename a foreign key column (by dropping and adding) I
cannot recreate the foreign key. The error that I get is that the
referenced schema does not exist:
ERROR: schema "table2" does not exist
If I specify the schema name on both tablenames, when adding the constraint:
alter table public.table1 add foreign key(table2_id) references
public.table2.id;
I get this error:
ERROR: cross-database references are not implemented
I know very little about postgresql's schema's. Am I doing things
correctly? I've never had this kind of a problem before. Postgresql has
treated me very well. Has anyone else experienced similar problems?
Isaac Vetter
p.s. I know that I need to upgrade to v8. That's not possible right now.
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2007-12-11 16:01:36 | Re: schema question |
Previous Message | Tom Lane | 2007-12-10 22:49:32 | Re: failure with pg_dump |