I created a table in PGSQL (version 13) using the following command: db1=# create table temp2( foo int PRIMARY KEY, bar varchar(20) UNIQUE NOT NULL ); CREATE TABLE The d or d+ command does not list the associated indexes for…
I am creating a sports database and am trying to add a trigger to my DDL. The aim of the trigger is to insert values into a table (commitment) whenever another table (player) has a college commitment (col_commit) change from…
I am trying to create a group that has the right to create databases and roles. And then inherit these privileges with the next role. But the error constantly pops up that I don't have rights Edited: (mistake between 'gg'…
Looked at some of the other posts asking about the error 'column "column_name" referenced in foreign key constraint does not exist' but none of the answers/situations seem to match exactly: Currently have two migration files: 20210123122225_createReservationsTable.js exports.up = function (knex)…
Using docker-compose, I am running a postgres container (db). The data itself is persistently stored on my Windows machine. And this works. I am unable to get another container running a python application to access the database. My docker-compose file…
I want to create a procedure that receives two ids, makes two selects in a table and returns the data, after that I want to perform an update in another table using the result that was returned to me earlier,…
How can I make an SQL query to select records that do not have at least one child element? I have 3 tables: article (~40K rows), calendar (~450K rows) and calendar_cost (~500K rows). It is necessary to select such entries…
I have a table with 5 columns. id bday update restartDate startDate I need to update each rows update column with the most recent date between restartDate and startDate I've tried: update mytable set update = (select MAX(v)from (values (restartDate),(startDate))…
My table has 650M rows (according to a fast but decently precise estimate from a query I found here). It has a text column called receiver_account_id, and I need to be able to search those records like: r.receiver_account_id LIKE '%otherWordsHere'.…
I am running tests using rails test:models and got this error (though the tests still run) ActiveRecord::NoDatabaseError: We could not find your database: postgres. Which can be found in the database configuration file located at config/database.yml. A database called postgres…