Re: [SQL] delete on cascade

2006-10-23 Thread Richard Broersma Jr
i guess my first attempt to send a reply failed. --- Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > > Hi all, > > I guess this is an already asked question, but I didn't found an answer, so > > apologize me. Imagine I've got two tables: > > skill(id,description) // primary key =>

Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-23 Thread Andrew Sullivan
On Fri, Oct 20, 2006 at 09:01:15PM -0700, Richard Broersma Jr wrote: > actually I am get duplicate emails like this one across the various PG lists. > Perhaps someone > else is resending these email? More likely, this happened: 1. person sent mail to list, got bounced because not subscribed. 2

Re: [SQL] delete on cascade

2006-10-23 Thread Stephan Szabo
On Mon, 23 Oct 2006, Luca Ferrari wrote: > Hi all, > I guess this is an already asked question, but I didn't found an answer, so > apologize me. Imagine I've got two tables: > skill(id,description) // primary key => id > family(id,description)// primary key => id > and I want to a

Re: [SQL] delete on cascade

2006-10-23 Thread Richard Broersma Jr
> Hi all, > I guess this is an already asked question, but I didn't found an answer, so > apologize me. Imagine I've got two tables: > skill(id,description) // primary key => id > family(id,description)// primary key => id > and I want to associate skills to families: > ass_sf(id_s

Re: [SQL] delete on cascade

2006-10-23 Thread chester c young
--- Luca Ferrari <[EMAIL PROTECTED]> wrote: > Hi all, > I guess this is an already asked question, but I didn't found an > answer, so > apologize me. Imagine I've got two tables: > skill(id,description) // primary key => id > family(id,description)// primary key => id > and I want

Re: [SQL] delete on cascade

2006-10-23 Thread Achilleas Mantzios
Στις Δευτέρα 23 Οκτώβριος 2006 12:50, ο/η Luca Ferrari έγραψε: > On Monday 23 October 2006 11:00 Achilleas Mantzios's cat, walking on the > > keyboard, wrote: > > not right!!! > > ON DELETE CASCADE is specified in FOREIGN KEY contsraints. > > So that would be in ass_sf table. > > If you find ALTER

Re: [SQL] delete on cascade

2006-10-23 Thread Luca Ferrari
On Monday 23 October 2006 11:00 Achilleas Mantzios's cat, walking on the keyboard, wrote: > not right!!! > ON DELETE CASCADE is specified in FOREIGN KEY contsraints. > So that would be in ass_sf table. > If you find ALTER TABLE ass_sf command hard to run, then drob your > ass_sf table and define i

Re: [SQL] delete on cascade

2006-10-23 Thread Achilleas Mantzios
Στις Δευτέρα 23 Οκτώβριος 2006 11:49, ο/η Luca Ferrari έγραψε: > Hi all, > I guess this is an already asked question, but I didn't found an answer, so > apologize me. Imagine I've got two tables: > skill(id,description) // primary key => id > family(id,description)// primary key =>

[SQL] delete on cascade

2006-10-23 Thread Luca Ferrari
Hi all, I guess this is an already asked question, but I didn't found an answer, so apologize me. Imagine I've got two tables: skill(id,description) // primary key => id family(id,description) // primary key => id and I want to associate skills to families: ass_sf(id_skill,id_family)