Oliver Elphick wrote:
>>Foreign Key constraints: $1 FOREIGN KEY (pid) REFERENCES products(id) ON
>>UPDATE NO ACTION ON DELETE NO ACTION
>
> Drop the constraint; then add an amended one.
Ok, how do I drop the constraint, it has no name.
The documentation is rather poor on how to get the name of unamed
constraints:
"To remove a constraint you need to know its name. If you gave it a name
then that's easy. Otherwise the system assigned a generated name, which
you need to find out. The psql command \d tablename can be helpful here"
Secondly what is the correct syntax for adding a new constraint with ON
DELETE CASCADE?
Thanks,
Jean-Christian Imbeault
