Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-07 Thread Nicolas Williams
On Tue, Jul 07, 2009 at 12:17:36AM +0100, Simon Slavin wrote: He didn't make up the rule. Nor did I. It's part of the standard for mailing lists and usenet: http://www.faqs.org/rfcs/rfc1855.html This is way off-topic now, but, to be fair, RFC1855 is not a standard, it is an Informational

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-07 Thread Jean-Denis Muys
On 7/7/09 8:47 , Nicolas Williams nicolas.willi...@sun.com wrote: On Tue, Jul 07, 2009 at 12:17:36AM +0100, Simon Slavin wrote: [...] This is way off-topic now, but, to be fair, RFC1855 is not a standard, it is an Informational status RFC -- it provides information. It possibly is never

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-06 Thread Simon Slavin
On 6 Jul 2009, at 6:34am, James Gregurich wrote: The inability of INSERT OR REPLACE to maintain referential integrity leaves me with no mechanism to implement a feature in my project that I was intending to provide. Are there any plans to add in the functionality for INSERT OR REPLACE to

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-06 Thread Simon Slavin
(Sorry, hit 'Send' before I meant to.) On 6 Jul 2009, at 6:34am, James Gregurich wrote: a question for the sqlite developers. The inability of INSERT OR REPLACE to maintain referential integrity leaves me with no mechanism to implement a feature in my project that I was intending to

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-06 Thread James Gregurich
so you are suggesting that I put an INSERT in a C loop checking for a constraint violation failure. if I get one, I use errmsg to get the column is not unique message and extract . Then, I issue a DELETE to clear out rows that match the value of . is that correct? On Jul

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-06 Thread Simon Slavin
Please quote previous text above your response to it. We read English top to bottom. On 6 Jul 2009, at 8:22pm, James Gregurich wrote: On Jul 6, 2009, at 3:53 AM, Simon Slavin wrote: It should not call DELETE triggers since it never deletes. It should call either INSERT triggers or UPDATE

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-06 Thread James Gregurich
1) Why on earth would you want to scroll all the way to the bottom of a long email to get the response simply for the sake of We read English top to bottom. 2) This is going to be a challenge for me because I'm not writing a fixed DB with a known schema. I'm writing a higher-level data

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-06 Thread Nicolas Williams
On Mon, Jul 06, 2009 at 02:49:07PM -0700, James Gregurich wrote: 1) Why on earth would you want to scroll all the way to the bottom of a long email to get the response simply for the sake of We read English top to bottom. Any quoted context must be read before the reply or else is not

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-06 Thread James Gregurich
On Jul 6, 2009, at 3:14 PM, Nicolas Williams wrote: On Mon, Jul 06, 2009 at 02:49:07PM -0700, James Gregurich wrote: 1) Why on earth would you want to scroll all the way to the bottom of a long email to get the response simply for the sake of We read English top to bottom. Any quoted

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-06 Thread Simon Slavin
On 6 Jul 2009, at 11:59pm, James Gregurich wrote: How's this... you have a pretty low threshold for obnoxious. Frankly, I lack the desire and energy needed to keep up with the list of rules people make up. read the email or don't. He didn't make up the rule. Nor did I. It's part of the

[sqlite] plans for completion of INSERT OR REPLACE INTO?

2009-07-05 Thread James Gregurich
a question for the sqlite developers. The inability of INSERT OR REPLACE to maintain referential integrity leaves me with no mechanism to implement a feature in my project that I was intending to provide. Are there any plans to add in the functionality for INSERT OR REPLACE to call delete