On 11/29/2018 07:10 PM, szmate1618 wrote:
I'm afraid I still didn't make any progress on this.
It looks to me that PRAGMA foreign_key_check; and the deferred foreign key
mechanism sometimes contradict each other,
consequently at least one of these features must have a bug, but I don't
know for
I'm afraid I still didn't make any progress on this.
It looks to me that PRAGMA foreign_key_check; and the deferred foreign key
mechanism sometimes contradict each other,
consequently at least one of these features must have a bug, but I don't
know for sure which one,
so I can't risk using any of
>"PRAGMA foreign_keys = ?" is a property of the connection only, not the
>database file. So what advantage would there be in including the PRAGMA
>statements in the body of a transaction?
Not much, if I do everything right, I guess. But what if I break the
foreign key integrity?
If it's inside a
, 16:30:12
Subject: [sqlite] Bug?: unexpected behaviour - alter parent table in a deferred
foreign key relationship
On 11/23/2018 09:54 PM, szmate1618 wrote:
Dear list members,
I have the following problem, with which I'd like to request your aid:
Currently, at version 3.25.2, SQLit
an Kennedy
To: sqlite-users@mailinglists.sqlite.org
Sent: Friday, November 23, 2018, 16:30:12
Subject: [sqlite] Bug?: unexpected behaviour - alter parent table in a deferred
foreign key relationship
On 11/23/2018 09:54 PM, szmate1618 wrote:
> Dear list members,
> I have the following problem, wit
On 11/23/2018 09:54 PM, szmate1618 wrote:
Dear list members,
I have the following problem, with which I'd like to request your aid:
Currently, at version 3.25.2, SQLite only has a limited support for alter
table. E.g. you cannot change the datatype (type affinity) of a column, or
drop a
Dear list members,
I have the following problem, with which I'd like to request your aid:
Currently, at version 3.25.2, SQLite only has a limited support for alter
table. E.g. you cannot change the datatype (type affinity) of a column, or
drop a column.
The usual workaround is to create a new
7 matches
Mail list logo