frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Unique index failure on Postgres – my bad

1•robshep•1h ago
I recently had a unique index failure on PostgreSQL. To be clear it wasn't Postgres' fault - it was mine.

Thankfully it reared it's head on Staging not Live, but here's something other PostgreSQL users might find interesting.

In between writing one set of data, and the next which relies on ON CONFLICT to update/insert rows, thus fully relying on the unique index holding the integrity, I switched docker image, to get some tooling built in.

The original was alpine/musl based. The subsequent was Debian/Glib based.

As far as I can tell the byte collation is different and the index operations just didn't find one set of bytes where it ought to be.

If I had dumped/restored - it wouldn't have been a problem, but I just flipped the image on the existing storage volume. oops.

On the surface, the index was active, and in an enforcing state.

a REINDEX failed however, there were dupes!

For me, I fixed the dupes, REINDEXed, then dump-restored.

But worth bearing in mind given how many backup mechanisms rely on storage volume snapshots, and a global reindex after restore will catch these types of issues if that's a potential for anyone.

I hereby invite the forthcoming tsunami of criticism, that I will ignore, purely so i can post this for others to find interest, and who might have done the same thing as me.

Learning to Code, 1990s vs. 2026

https://ayende.com/blog/203975-a/learning-to-code-1990s-vs-2026/
1•GordonS•2m ago•0 comments

Deltδx Free – Scientific Reasoning GPT

https://chatgpt.com/g/g-69f11b6a1bdc8191ab1100acf60f40cc-deltdx-free
1•DELTAX-Editions•4m ago•0 comments

Jjj – Jujutsu Jump

https://oppi.li/posts/jjj/
1•nerdypepper•6m ago•0 comments

Why is Silicon Valley suddenly obsessed with being tasteful?

https://www.theguardian.com/fashion/2026/may/08/why-is-silicon-valley-suddenly-obsessed-with-bein...
1•giuliomagnifico•6m ago•0 comments

Technology Transformed Babymaking

https://www.technologyreview.com/2026/05/08/1136974/heres-how-technology-transformed-babymaking-ivf/
1•joozio•9m ago•0 comments

Checking Multiplication Overflow

https://lemire.me/blog/2026/05/06/checking-multiplication-overflow/
1•signa11•11m ago•0 comments

Playing freely – and not limiting innovation to what is already best practice

https://livingsystems.substack.com/p/playing-freely
1•samuell•12m ago•0 comments

Dad Was at the Hard Hat Riot

https://medium.com/@solidi/dad-was-at-the-hard-hat-riot-f84339b08fb2
1•biscuits1•12m ago•0 comments

Notes from Code with Claude 2026

https://chrisebert.net/notes-from-code-with-claude-2026/
1•cebert•12m ago•0 comments

How to build a lunar mass driver – Casey Handmer's blog

https://caseyhandmer.wordpress.com/2026/05/08/how-to-build-a-lunar-mass-driver/
1•bilsbie•13m ago•0 comments

Show HN: Rore GUI – An Open Qt Alternative in Rust (WGPU, Zero-VDOM)

https://github.com/davlatov-tech/Rore
1•umid_davlatov•14m ago•1 comments

Jj v0.41.0 Is Out

https://github.com/jj-vcs/jj/releases/tag/v0.41.0
1•birdculture•15m ago•0 comments

12K+ JPEGs from NASA's Artemis II Mission

https://tech.marksblogg.com/nasa-artemis-2-jpegs.html
1•marklit•16m ago•0 comments

Mozilla's buzz around Mythos is disingenuous at best, and malicious at worst

https://ghidravevo.substack.com/p/mozillas-buzz-around-mythos-is-disingenuous
2•ghidravevo•19m ago•0 comments

AirPods Pro with AI Cameras Reach 'Advanced' Testing Stage

https://www.macrumors.com/2026/05/07/airpods-pro-built-in-cameras-advanced-testing/
3•doener•24m ago•0 comments

3D Gaussian Splatting Ply to 3D Tiles Converter

https://github.com/WilliamLiu-1997/3DGS-PLY-3DTiles-Converter
1•WilliamLiu1997•25m ago•0 comments

Vimes Boots and why the right AI evals could save your project

https://www.investigatingsoftware.co.uk/2026/05/vimes-boots-why-right-ai-evals-could.html
1•phoughton•27m ago•0 comments

Evolving from VM to CTEM

https://threatcrush.com/get-whitepaper
1•buffer_overlord•29m ago•0 comments

China unveils first dual core atomic quantum computer Hanyuan-2

https://www.globaltimes.cn/page/202605/1360525.shtml
1•HardwareLust•31m ago•0 comments

The Margin Sandwich: Where the AI Services Dollar Lands

https://deepviews.xyz/blog/margin-sandwich-ii-en
2•rswcf•33m ago•1 comments

Keep Android Open

https://keepandroidopen.com/
3•tagfowufe•36m ago•2 comments

There Are Three Programming Paradigms (2013)

http://wiki.c2.com/?ThereAreExactlyThreeParadigms
2•downbad_•37m ago•1 comments

Copy fail 2: electric boogaloo [with actual timeline Dirtyfrag embargo break]

https://afflicted.sh/blog/posts/copy-fail-2.html
1•alecco•37m ago•0 comments

Show HN: DashResume, a resume builder with ATS scoring, and AI job desc matching

https://dashresume.com/
2•nicereads•37m ago•0 comments

Show HN: Claude Control – macOS dashboard for managing Claude Code sessions

https://github.com/sverrirsig/claude-control
2•svessi•39m ago•0 comments

The mathematician who doesn't exist

https://www.newscientist.com/article/2525614-the-mathematician-who-doesnt-exist/
2•baruchel•41m ago•0 comments

The Curse of Smart People (2014)

https://apenwarr.ca/log/20140701
1•downbad_•41m ago•1 comments

AI Assistance Reduces Persistence and Hurts Independent Performance

https://ai-project-website.github.io/AI-assistance-reduces-persistence/
2•fredley•44m ago•0 comments

Show HN: AI Real Estate Video from Listing Photos

https://maggi.homes/explore
2•maggihomes•47m ago•0 comments

Show HN: Postlet – Tiny static blog generator with plugins and themes support

1•freakynit•48m ago•0 comments