On Sun, Oct 26, 2008 at 10:44:29AM +0100, Thomas wrote: > 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? use foreign keys. syntax to add them: 1. "references table (field)" in create table/ 2. alter table add foreign key Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@xxxxxxxxxx / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
