Sean Davis wrote:
> I recently created the 111th table and I cannot create foreign key
> 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
> alter table public.table1 add foreign key(table2_id) references
> public.table2.id ;
> This should be:
> Does that fix the problem?
This was exactly the problem: a stupid syntax error.
I've literally created hundreds of foreign keys in pgsql, but did not
see the problem with this one.
Much thanks, Sean.
In response to
pgsql-novice by date
|Next:||From: Mija Lee||Date: 2007-12-11 16:34:05|
|Subject: Re: failure with pg_dump|
|Previous:||From: Sean Davis||Date: 2007-12-11 16:01:36|
|Subject: Re: schema question|