Hi,
I have jumped from MySQL to PostgreSQL, and I wanted to know how we
declare that a table depends on another one.
Currently I have 3 tables:
Product(id, title, price)
Item(id, product_id, order_id, quantity)
Order(id, amount, paid)
In pgAdmin I have removed a few order entries, but the items
associated to them are still here, now I have zombie items floating
around that don't belong to any order. So how do I tell PgSQL that
when I remove a given order, it should remove all associated items
also?
Best regards,