Re: [sqlite] Should .dump preserve foreign_keys pragma?

On Fri, Jan 9, 2015 at 11:57 AM, Dominique Devienne wrote: > On Fri, Jan 9, 2015 at 11:35 AM, Niall O'Reilly > wrote: > >> At Thu, 08 Jan 2015 15:55:00 -0700, >> Keith Medcalf wrote: >> > >> > when you load a dump file you need to have that foreign >>

Re: [sqlite] Should .dump preserve foreign_keys pragma?

On Fri, Jan 9, 2015 at 11:35 AM, Niall O'Reilly wrote: > At Thu, 08 Jan 2015 15:55:00 -0700, > Keith Medcalf wrote: > > > > when you load a dump file you need to have that foreign > > key enforcement off in order to be able to load the database. This > > is because the

Re: [sqlite] Should .dump preserve foreign_keys pragma?

At Thu, 08 Jan 2015 15:55:00 -0700, Keith Medcalf wrote: > > when you load a dump file you need to have that foreign > key enforcement off in order to be able to load the database. This > is because the tables and data are dumped in random order, not in > hierarchical order (parents of parents

Re: [sqlite] Should .dump preserve foreign_keys pragma?

mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Niall O'Reilly >Sent: Thursday, 8 January, 2015 06:39 >To: General Discussion of SQLite Database >Subject: [sqlite] Should .dump preserve foreign_keys pragma? > > > Hello. > > What follows puzzles me. Either there's something

Re: [sqlite] Should .dump preserve foreign_keys pragma?

On Thu, Jan 8, 2015 at 9:05 AM, Niall O'Reilly wrote: > At Thu, 8 Jan 2015 13:46:37 +, > Simon Slavin wrote: > > > > > > On 8 Jan 2015, at 1:38pm, Niall O'Reilly wrote: > > > > > I'ld have expected the foreign_keys pragma setting to have been > >

Re: [sqlite] Should .dump preserve foreign_keys pragma?

At Thu, 8 Jan 2015 13:46:37 +, Simon Slavin wrote: > > > On 8 Jan 2015, at 1:38pm, Niall O'Reilly wrote: > > > I'ld have expected the foreign_keys pragma setting to have been > > preserved. > > That makes sense in terms of how a sensible user would expect SQLite >

Re: [sqlite] Should .dump preserve foreign_keys pragma?

On 8 Jan 2015, at 1:38pm, Niall O'Reilly wrote: > I'ld have expected the foreign_keys pragma setting to have been > preserved. That makes sense in terms of how a sensible user would expect SQLite to behave. But unfortunately it's not what SQLite does. See section 2

[sqlite] Should .dump preserve foreign_keys pragma?

Hello. What follows puzzles me. Either there's something I don't understand, or something is wrong. dhcp-179(niall)7: sqlite3 SQLite version 3.8.5 2014-08-15 22:37:57 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a