XSCH4, Conglomerate could not be created?

2010-12-07 Thread John English
Can anyone explain what this means? It occurs when I issue what should be a straightforward insert: INSERT INTO resource_usage (resid,xmlid,xmltable) (SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?) The select returns 64 results, but the ibsert fails.

Re: XSCH4, Conglomerate could not be created?

2010-12-07 Thread Dag H. Wanvik
John English j...@brighton.ac.uk writes: Can anyone explain what this means? It occurs when I issue what should be a straightforward insert: INSERT INTO resource_usage (resid,xmlid,xmltable) (SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?) I think we had a similar

Re: XSCH4, Conglomerate could not be created?

2010-12-07 Thread Bryan Pendleton
On 12/07/2010 12:15 PM, John English wrote: Can anyone explain what this means? It occurs when I issue what should be a straightforward insert: INSERT INTO resource_usage (resid,xmlid,xmltable) (SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?) The select returns 64 results,