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
>
> 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