I have a code which does unit testing, where I prepare a database for the tests (I do not use sql-go-mock), so I want to insert returning id with a simple sql INSERT INTO, but for some reason pgx errors…
Can't figure out what is the correct postgres url when hosting with Coolify. Everything is up and running. I have only changed the service name to db and kong domain to https://mywebsite.com:8000 Coolify is hosted on ubuntu vps_1 and through…
I have set up three containers that are networked because I would like to use Hadoop and Hive with PostgreSQL. You can access Docker set up via https://github.com/jcool12/hadoop-docker/tree/main/hivepost so you can download the folders/ files to run it. The Hadoop…
I have a large (~65,000 lines) JSON file which is being used as data for a prisma postgres database in a Next.js project I'm working on. The file contains entries like so: [ { "NativeClass": "class-name", "Classes": [ // data…
I'm new to Postgres, and I want to delete a role named rp_ts04, but it complains about dependencies. I don't know how to check for these dependencies. I've checked information_schema but it doesn't show any relation to rp_ts04. Can anyone…
I'm getting an array of values as part of a query: SELECT class_id, count(*) as num_in_class, ARRAY_AGG(DISTINCT major_id) major_ids FROM students GROUP BY class_id; This gives me the number of distinct majors in each class. The id of the major…
I am beginning to understand how transaction and locks work in databases. So in a very higher-level understanding: BEGIN -- txID: 1234 UPDATE tbl_1 SET field = value WHERE id IN (1); -- for simplicity -- Locks acquired on rows…
I'm trying to attach a db to my python API. I use Windows 11, docker-compose, fastAPI. Not sure what is missing. In the logs I see the following: docker-compose logs -f time="2024-05-17T16:01:30+04:00" level=warning msg="\code\docker-compose.yml: `version` is obsolete" postgres-1 | postgres-1…
I have Table T T(A , B , C , D) With this query: Select A from T Where B = C Does having an index on D make a difference in the performance of the given query? Does having…
I tried to install postgresql 16 in Oracle Linux 7.9 environment but its failed, due to no package available. but postgresql 15, 12 able to install in oracle linux 7.9 somehow. i have been searching over the website but i…