[GENERAL] Multiple foreign keys with the same name and information_schema

2009-08-10 Thread Jonathan Tapicer
Hello everyone, I have a question regarding foreign keys and information_schema. Given the following valid schema: CREATE TABLE "Cat" ( "IdCat" serial NOT NULL, CONSTRAINT "PK_Cat" PRIMARY KEY ("IdCat") ); CREATE TABLE "Art" ( "IdArt" serial NOT NULL, "IdCat" integer NOT NULL, CONSTRAIN

Re: [GENERAL] Multiple foreign keys with the same name and information_schema

2009-08-10 Thread Jonathan Tapicer
> > Actually, the information_schema supposes that constraint names are > unique within a *schema*, not within a *catalog* (a/k/a database). > Don't know if that distinction can help you or not.  You are correct > that Postgres is less rigid.  We do not consider that to be a deficiency > on the Pos