Tag: TimescaleDB

SOLVE ALL THE ERRORS!

How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

Have you run into this puzzling error? It comes in a couple of flavors, but it boils down to you failing miserably when you run the create_hypertable() function on your PostgreSQL TimescaleDB database server! Annoyingly, it might mean that the whole function is missing (extension is not installed or loaded) or that your parameters are not properly parsed (an issue with your command). I know, that it sucks. I have been there. That’s why I wrote this article! Problem You’re trying to transform your PostgreSQL…Continue reading How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

PostgreSQL everywhere

How to run SQL commands in a Postgre SQL Docker container?

This article will explain how to run your arbitrary SQL commands against a Postgre SQL database running in a Docker container in Windows. That should be super simple, but since I never remember anything like this by heart, I had to google it – and turns out, either I didn’t know how to google this properly or people haven’t bothered to document this. So, let’s fix that. But first, why did I need to do this, again? Problem So – I meant to run some…Continue reading How to run SQL commands in a Postgre SQL Docker container?