The Heap™ – Consultancy ©®

5:35 AM

Morning

5:49 AM

Morning

After all those years that still makes me smile

Well it's just 5:50pm in the morning

Peter Vandivier

@PaulWhite any chance you're near portobello?

geodatos.net/en/antipodes/united-kingdom/england/london

also, morning

@PeterVandivier No that's way too far south. Mine is Spain geodatos.net/en/antipodes/new-zealand/wellington/paraparaumu

6:04 AM

@PaulWhite I expected mine to be water and apparently it is in a way geodatos.net/en/antipodes/search?q=Kortrijk

Waitangi, Northland

Waitangi ( or , Māori: [ˈwaitaŋi]) is a locality in the Bay of Islands on the North Island of New Zealand. It is close to the town of Paihia (of which it is considered a part), 60 kilometres north of Whangarei. "Waitangi" is a Māori-language name meaning "weeping waters". Waitangi is best known for being the location where the Treaty of Waitangi was first signed on February 6, 1840. It is also the place where the Declaration of Independence of New Zealand was signed five years earlier, on October 28, 1835. This document was ratified by the British Crown the following year (1836). == History... ==

> "Waitangi" is a Māori-language name meaning "weeping waters".

@TomV Well that's a great shot to hit the Chathams

Different Waitangi btw

It's Morocco for the Wikipedia Waitangi geodatos.net/en/antipodes/new-zealand/northland/paihia

6:23 AM

The Bay of Islands is one of my favourite places in summer

1 hour later…

7:36 AM

Morning

Same city to me https://www.geodatos.net/en/antipodes/spain/catalonia/berga
Curiously I live far away from Belgium

@McNets Yeah it's the "nearest city", the exact opposite of the globe is probably somewhere in the ocean

Q: SQL Query: How to get data from four different tables

yep, I don't know why your name is not visible in my reply.

I am using mysql and here is the schema that I have. First table: Keywords +------------+-------------+ | keyword_id | keyword_tag | +------------+-------------+ | 2 | marketing | | 58 | sales | | 59 | scraping | | 1 | seo | | 3 | te...

Answer in comments ^^

1 hour later…

8:55 AM

morning

Q: Deleted the constraint from the table and unable to add it back

9:16 AM

When i was deleting some records from the table, i got an error foreign key constraint violated. So, i removed the constraint from the table and then deleted the records. But again after i am adding that constraint, I am getting an error:- 14:33:32: Error: ERROR: insert or update on table "v...

postgresql

What did OP expect? ^^^

@McNets I lakh that question

@hot2use ;) There is a pending edit

Is there any change in the chat?

I cannot see user names when I ping or reply to other users

tapermonkey add-on?

@McNets test

@hot2use I think I removed it

hey, only when reply

@hot2use test

sh*t

@McNets An additional line between response?

nope

interesting

You broke-fixed it

9:27 AM

Morning

ConcernedOfTunbridgeWells

@hot2use nevermind, I suppose you get pinged

Fun fact: Māori is the only language that uses the a-macron character (ā), making New Zealand a unicode-only locale (it's not in any of the ANSI or ISO-8859 character sets). In 1990 the Deptartment of Maori Affairs had to buy a bunch of Sun workstations to run Framemaker in order to produce bilingual documentation, as this was the only platform capable of making this as a composite character.

Postscript allowed you to make a composite character of this sort - a lot of accented characters were done in this way.

Not a lot of people know that.

JEAGL: 'Not a lot of people know that.' was a line in an ad that was world famous in New Zealand about 20 or 30 years ago. It was a paraphrasing of a quote attributed to Michael Caine but apparently originated by Peter Sellers.

Peter Sellers doing Michael Caine 'not alot of people know that' Parkinson 70s

►

9:46 AM

@McNets and a cross-posted question

@McNets rejected as too minor and wrong translation.

10:10 AM

Hey is it a minimal reproducible example or an minimal reproducible example

an mcve; a minimal reproducible example

the problem is typing an [mcve] in a comment expands it to the form that would make "a" correct

Ah yeah that explains why I was confused for a moment there

It's the difference between emcve and minimal

yes

Philᵀᴹ

10:34 AM

dezso

@McNets the editor took lakh as a grammar mistake, apparently. Now the question makes even less sense.

@dezso yep, BTW do you have a (single) word for lakh?

@dezso I rejected the edit

dezso

@McNets 1e5 maybe

@McNets I lakh that information

10:42 AM

Lakh

A lakh (; abbreviated L; sometimes written Lac or Lacs; Devanāgarī: लाख) is a unit in the Indian numbering system equal to one hundred thousand (100,000; scientific notation: 105). In the Indian convention of digit grouping, it is written as 1,00,000. For example, in India 150,000 rupees becomes 1.5 lakh rupees, written as ₹1,50,000 or INR 1,50,000. It is widely used both in official and other contexts in Bangladesh, Bhutan, India, Myanmar, Nepal, Pakistan, and Sri Lanka. It is often used in Indian, Pakistani, and Sri Lankan English. In Pakistan, the word lakh is used mostly in local languages...

I lakh'ed the appropriate JEAGL for that joke

deci-million

milli-billion

Oh wait no :(

George

That's what they call me

10:45 AM

@PaulWhite me too

Milli Vanilli

@PaulWhite +1

MYGz

Hello! Greetings!
What event to select in Extended events to be able to see the 'SQL Statement' fired by the application? The application appends some additional info to the query, so I want to trace it in SQL engine.

Vérace

11:08 AM

@McNets had an argument over this in Scrabble recently. I was told to "use English words". I won" t repeat the language I used to stress that it was a Hindi word borrowed into English!!! Triple word score to boot! No internet (the joys!!). The satisfaction of being later able to show that it's been in the OED since 1901 was,...

Colin 't Hart

11:21 AM

Morning

ROLLBACK;

Afternoon

Peter Vandivier

sadly transaction id wraparound has occurred and the heap cannot be rolled back to the Afternoon state

12:18 PM

@PeterVandivier Too right

dezso

@PaulWhite hectothousand

that works

1:05 PM

Nice, my verbal disputes in this kind of games usually ends not really good...
😉

2 hours later…