On 25/10/2018 11:06 AM, Simon Slavin wrote:
The second exhortation tells us that that's not enough, and we also have a duty
to maximise pleasure.
lol, good point. Quite the opposite of monkish orders.
___
sqlite-users mailing list
sqlite-users@maili
I found the cause of my issue.
I have two columns as foreign key in child, which reference corresponding pair
in parent. But, I was setting up the references separately, not as a pair. And
it looked like it can not work.
It works because the pair of columns in parent is PRIMARY KEY and thus has
No, it means that you did not specify the whatisness of grandParent, parent, or
child; and/or, you have not enabled foreign_keys.
https://sqlite.org/lang_createtable.html
https://sqlite.org/pragma.html#pragma_foreign_keys
NB: I have compiled the CLI with foreign key enforcement ON be default.
What do your inserts look like? This SQL will function as expected:
CREATE TABLE grandparent (id INTEGER PRIMARY KEY);
CREATE TABLE parent (id INTEGER PRIMARY KEY REFERENCES grandparent(id));
CREATE TABLE child (id INTEGER PRIMARY KEY REFERENCES parent(id));
INSERT INTO grandpare
The statements work. Insertion fails.
Roman
From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
David Yip [dw...@peach-bun.com]
Sent: Thursday, October 25, 2018 12:37 AM
To: SQLite mailing list
Subject: Re: [sqlite] nested forei
Dear SQLIters,
I am trying to set up what I would call "nested foreign keys":
create grandParent( id PRIMARY KEY)
create parent (id PRIMARY KEY REFERENCES grandParent(id))
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailin
These statements worked for me:
CREATE TABLE grandparent (id INTEGER PRIMARY KEY);
CREATE TABLE parent (id INTEGER PRIMARY KEY REFERENCES grandparent(id));
CREATE TABLE child (id INTEGER PRIMARY KEY REFERENCES parent(id));
The foreign key constraints work as you'd expect also.
What are you
Dear SQLiters,
I am trying to set up what I would call "nested foreign keys":
create grandParent (id PRIMARY KEY )
create parent (id PRIMARY KEY REFERENCES grandParent(id))
create child (id PRIMARY KEY REFERENCES parent(id))
SQLite complains. Does it mean that grand children are not allowed?
Th
On 25 Oct 2018, at 12:16am, Philip Warner wrote:
> t leads to the question: have you ever seen one that works better than, say,
> "Don't be an arsehole/dick/evil"? In most jurisdictions sexual harassment,
> murder etc are already illegal...so repeating them in a CoE/C seems redundant.
The ques
On 25/10/2018 2:17 AM, Jens Alfke wrote:
Vague blanket statements like “Don’t be evil” or “Be excellent to each other”
don’t work (here or anywhere else.)
This is a good point. But it leads to the question: have you ever seen one that
works better than, say, "Don't be an arsehole/dick/evil"?
On 25/10/2018 9:11 AM, Richard Hipp wrote:
If you read the original CoC closely, you will find things that
required me to change it. We have:
18. Be a help in times of trouble
19. Console the sorrowing
31. Love your enemies
34. Be not proud
71. Make peace with your adversary befo
See, this is where I miss being able to non-intrusively add a heart emoji
to your post. Here it is anyway: ❤
Wout.
On Thu, Oct 25, 2018, 12:11 AM Richard Hipp wrote:
> On 10/24/18, Michael Falconer wrote:
> >
> > it's all gone...while my devout atheism is generally pleased my
> > somewhat
On 10/24/18, Michael Falconer wrote:
>
> it's all gone...while my devout atheism is generally pleased my
> somewhat annoying 'free will, free speech ' ethic has rust on it! Richard,
> it's your joint and it's such a good place, friendly and mostly respectful.
> My atheism was NOT offended in a
Oh dear,
it's all gone...while my devout atheism is generally pleased my
somewhat annoying 'free will, free speech ' ethic has rust on it! Richard,
it's your joint and it's such a good place, friendly and mostly respectful.
My atheism was NOT offended in any way by all that God speak and I do
The one I usually see as being referred to as being "political" is the
Contributor Covenant -
https://www.contributor-covenant.org/version/1/4/code-of-conduct
From reading it, while it does have some specifics, it has all the
exact same problems you're highlighting "Don't be evil" has. Why?
B
Or a capture card.
On Wed, Oct 24, 2018, 21:28 Brian Chrzanowski Probably a virtual machine.
>
> On Wed, Oct 24, 2018, 2:27 PM R Smith wrote:
>
> >
> > On 2018/10/24 8:19 PM, Stephen Chrzanowski wrote:
> > > ..// without users consent. ... unlike...
> > >
> >
> https://www.extremetech.com/wp-con
Probably a virtual machine.
On Wed, Oct 24, 2018, 2:27 PM R Smith wrote:
>
> On 2018/10/24 8:19 PM, Stephen Chrzanowski wrote:
> > ..// without users consent. ... unlike...
> >
> https://www.extremetech.com/wp-content/uploads/2016/08/Windows10-BSOD-640x353.jpg
>
> How did you take a screenshot w
On 2018/10/24 8:19 PM, Stephen Chrzanowski wrote:
..// without users consent. ... unlike...
https://www.extremetech.com/wp-content/uploads/2016/08/Windows10-BSOD-640x353.jpg
How did you take a screenshot while Windows was hanging/recovering?
I call foul!
(Or is that a new Windows 10 feature?
I like this.
If I were to use this (And I don't expect I'll ever have to since I
typically write just for me) the only addition I'd make to this is about
the reporting.
From a users perspective, if the utility has something to report "home"
with (lets say crash reports), it'd have to be ABUNDANTL
Code Of Conduct, misplaced disposition on the individuals of
an organization rather than the results of their work on
intent.
I have had a simple statement with my open source software
downloads for years.
"Dandy Made Productions would like to assure individuals that
any applications downloaded
Richard,
thank you for your further explanation of your team's Code of Conduct.
After a bit of research on the Internet, everything makes sense.
Well done.
regs,
Kev
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailing
> On Oct 22, 2018, at 10:04 PM, Paul wrote:
>
> If my opinion has any value, even though being atheist, I prefer this CoC 100
> times over
> the CoC that is being currently pushed onto the many open-source communities,
> that was
> created by some purple-headed feminist with political motives
On Wed, Oct 24, 2018 at 1:55 PM Jan Danielsson
wrote:
> > Lets not pretend the rules are from English origin please. --DD
>
>I don't think that was what Wout meant. Read "Ye Olde English" as
> "Aesthetically 'old'", not "use the original". Point was merely to give
> some visual clues to the
On 2018-10-24 13:42, Dominique Devienne wrote:
> On Wed, Oct 24, 2018 at 1:10 PM Wout Mertens wrote:
>> [...] write the rules in Ye Olde English. [..]
>
> He was "Italian", and more likely to write in Latin, not English, old or
> new.
> The SQLite doc is English only because that's DRH native ton
On Wed, Oct 24, 2018 at 1:10 PM Wout Mertens wrote:
> [...] write the rules in Ye Olde English. [..]
>
He was "Italian", and more likely to write in Latin, not English, old or
new.
The SQLite doc is English only because that's DRH native tong (I assume).
Lets not pretend the rules are from Engli
> On the other hand, I am open to suggestions on how to express
> those values in a way that modern twitter-ites can better understand
Probably via selfie, with a duckface, together with your evening meal in
the background.
On Mon, Oct 22, 2018 at 4:30 PM Richard Hipp wrote:
> On 10/22/18, Chr
I think a lot of confusion could have been avoided by putting the text of
the CoC in a separate box, and for extra effect use a parchment paper
background, something like the Papyrus font and write the rules in Ye Olde
English.
Right now it looks as if the rules were written specifically for sqlit
I think the big problem with this CoC is that it triggers Poe's Law -
it's impossible to tell if it's serious or a joke without further
context. I know I spent a good 10 minutes trying to decide either way
when I first saw this thread a few days ago; now I know from the below
post that it's ser
On 10/24/18, Graham Hardman wrote:
>
> With my files built from the command prompt I ran the pragma
> compile_options and see that geopoly is listed as expected.
Are you sure? Can you double-check? Because I just looked at the
source code and it appears I mistakenly omitted ENABLE_GEOPOLY from
29 matches
Mail list logo