Re: [SQL] COPY fails but INSERT works

2002-12-28 Thread Gary Stainburn
On Saturday 28 December 2002 3:48 pm, Stephan Szabo wrote: > On Sat, 28 Dec 2002, Gary Stainburn wrote: > > When I create the database, I use the COPY command. The ranks and > > jobtypes are populated okay but the abilities table is empty. However, > > if I then INSERT the data the inserts work f

Re: [SQL] COPY fails but INSERT works

2002-12-28 Thread Stephan Szabo
On Sat, 28 Dec 2002, Gary Stainburn wrote: > When I create the database, I use the COPY command. The ranks and jobtypes > are populated okay but the abilities table is empty. However, if I then > INSERT the data the inserts work fine. Do *all* of the inserts work? If any one of the rows fails

[SQL] COPY fails but INSERT works

2002-12-28 Thread Gary Stainburn
Hi folks, I've got three tables (amongst others). The ranks table holds the various ranks that people can hold within each department. The jobtypes table holds the various jobs that need doing. The abilities holds the relationship defining which ranks carry out which jobs. When I create the dat