"Mathew Frank" <[EMAIL PROTECTED]> writes:
> UNIQUE constraint matching given keys for referenced table "price_lists" not
> found
As of CVS tip your example gives
ERROR: ALTER TABLE: column "s_price_list_id" referenced in foreign key constraint
does not exist
which appears correct (you misspelled the column name).
7.2 does foreign key validity checking in a funny order that causes it
to produce the other error message first. While not incorrect, it's
sure misleading :-(
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
