Having id as the primary key for a user when they sign up with an email, the id field is set to auto increment. It seems that when a user is trying to sign up with an email that already…
I use Prisma and Postgresql for a project to store and manage recipes. I am struggling to implement a Many to Many relationship where I can constrain one side to require at least one value for the relation field. Recipes…
I'm facing an issue where my Django application, running on Windows Subsystem for Linux (WSL), can't connect to a PostgreSQL database running in a Docker container. The error I'm getting in Django is: django.db.utils.OperationalError: could not translate host name "postgres"…
I would like to be able to return all canadian postalcode which can be find in using the following regex(migth have a space like: A0A 0A0 or A0A0A0) regex [A-Z]d[A-Z]s*d[A-Z]d The problem is when there is more than 1 match…
Assume I have two tables a and b, each containing a series of dates: Table a: day_date 2020-1-1 2020-1-2 2020-1-3 2020-1-4 2020-1-5 2020-1-6 2020-1-7 2020-1-8 2020-1-9 2020-1-10 and table b: id some_date 0 2020-1-3 0 2020-1-6 0 2020-1-8 1 2020-1-2…
I'm encountering an issue while working with PostgreSQL and TimescaleDB. I'm attempting to create a continuous aggregate view, but I keep receiving the following error message: ERROR: continuous aggregate view must include a valid time bucket function CREATE MATERIALIZED VIEW…
I made a mistake when defining a unique key in one of my SQL tables, and this has resulted in duplicate rows of data being entered into the table. The rows of data look like this: A, B, C, D,…
I have a table: CREATE TABLE notes ( id INT NOT NULL, user_id int NOT NULL, text varchar NOT NULL, primary key(id, user_id) ); so I need postgres to create ids of records unique by user, but not by whole…
I have a table that has daily data and thousands of rows per day: create table my_table(visitors_count int, dt date); select setseed(.42); insert into my_table select (random()*100)::int, current_date+(-random()*14)::int from generate_series(1,42000); However, some days are not present due to holidays: delete…
In our DB we have tables, that have 6-8 M records, this data is static and in order of performance optimization we decided to store some data from this tables in separate table, and for predefined filters use the values…