From: "Dado Feigenblatt" <dado(at)wildbrain(dot)com>
> I'm trying to create some tables with foreign keys.
> When I try to create a foreign key ...
>
> foreign key(seq_code) references sequences(seq_code) on update
> CASCADE on delete CASCADE,
>
> I get this message:
>
> ERROR: UNIQUE constraint matching given keys for referenced table
> "sequences" not found
>
> The problem is that the referenced field and table exist.
> Any hint?
Do you have a unique index on sequences.seq_code?
- Richard Huxton