[sqlite] Can DBI supply a more specific foreign key mismatch error?

2011-10-13 Thread felix
I'm working on a project which generates tables from a config file, and it seems to be happy on a Mac OSX running 3.4.0, but Linux running 3.7.8 complains about an insert with the unhelpful message (foreign key mismatch) I've checked all the data and don't see what it is complaining about, an

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error?

2011-10-13 Thread Dan Kennedy
On 10/14/2011 01:29 AM, fe...@crowfix.com wrote: I'm working on a project which generates tables from a config file, and it seems to be happy on a Mac OSX running 3.4.0, but Linux running 3.7.8 complains about an insert with the unhelpful message (foreign key mismatch) It means there is a

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error?

2011-10-13 Thread Petite Abeille
On Oct 13, 2011, at 9:17 PM, Dan Kennedy wrote: > It means there is a problem with a foreign key definition in the > database schema. Either an FK specifies parent columns that do not > exist, or parent columns that are not a PRIMARY KEY or UNIQUE. It also mean there is a problem in how SQLite r

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error?

2011-10-13 Thread felix
On Fri, Oct 14, 2011 at 02:17:20AM +0700, Dan Kennedy wrote: > On 10/14/2011 01:29 AM, fe...@crowfix.com wrote: > > I'm working on a project which generates tables from a config file, > > and it seems to be happy on a Mac OSX running 3.4.0, but Linux running > > 3.7.8 complains about an insert with

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error?

2011-10-13 Thread Simon Slavin
On 14 Oct 2011, at 3:52am, fe...@crowfix.com wrote: > What I want to know is if there is any way to get more better > reporting, such as the column or constraint it is upset about. The > message is not helpful. Sorry, you can't get a better one. > I have checked all the columns, all the > valu

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error?

2011-10-13 Thread Pavel Ivanov
>> >      (foreign key mismatch) >> >> It means there is a problem with a foreign key definition in the >> database schema. Either an FK specifies parent columns that do not >> exist, or parent columns that are not a PRIMARY KEY or UNIQUE. > > It works on MacOSX with sqlite 3.4.0, and the exact sam

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error?

2011-10-13 Thread Jay A. Kreibich
On Thu, Oct 13, 2011 at 07:52:59PM -0700, fe...@crowfix.com scratched on the wall: > On Fri, Oct 14, 2011 at 02:17:20AM +0700, Dan Kennedy wrote: > > On 10/14/2011 01:29 AM, fe...@crowfix.com wrote: > > > I'm working on a project which generates tables from a config file, > > > and it seems to be

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error?

2011-10-14 Thread Petite Abeille
On Oct 14, 2011, at 6:28 AM, Jay A. Kreibich wrote: >> What I want to know is if there is any way to get more better >> reporting, such as the column or constraint it is upset about. > > No. As several have said. Well, as this very topic of meaningless error message comes back with a very pr

Re: [sqlite] Can DBI supply a more specific foreign key mismatch error? -- Mea culpa

2011-10-13 Thread felix
Alright, I screwed up and shot off my big mouth. I guess getting older hasn't taught me every lesson under the sun yet. I had read so much documentation that I thought it was version 3, not 3.6.19, that introduced foreign keys. Add no complaints about either REFERENCES as a column constraint or