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
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
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
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
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
>> > (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
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
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
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
9 matches
Mail list logo