Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives 0votes
0answers
58views
How to use index in simple select
Table has index on name column: CREATE TABLE firma2.klient ( kood character(12) primary key, nimi character(100), ... ); CREATE INDEX IF NOT EXISTS ...
- 28.2k
-1votes
1answer
59views
How to call Postgres function from .NET?
I tried this code:CREATE OR REPLACE FUNCTION public.t4(in iid int, OUT n1 text, OUT n2 text) LANGUAGE plpgsqlAS $function$ BEGIN SELECT DISTINCT n1=l.name, n2=l.comment from ...
- 27
Tooling
0votes
1replies
19views
How to write test code for Prisma version 7
For testing Prisma, I used prismock or prisma-mock . But those packages are compatible with Prisma version 6 or earlier. I visit the Prisma Official website, and they are suggesting using jest-mock-...
0votes
0answers
27views
Connection to remote PostgreSQL server with hashtag in password with node-postgres
I have a password for a remote PostgreSQL server that I cannot change. This password contains hashtags (#). From searching, I know that this can be a problem.I can connect to the server from the ...
- 147
Advice
1vote
3replies
39views
Determine Connectedness Components for a Graph with a RECURSIVE Cte
I have a graph given by 2-element sets of points, say in a tableCREATE TABLE edge_set ( INTEGER edge_set_id, INTEGER point_id ) I want to determine the graphs connectedness components. These ...
0votes
1answer
36views
What is the practical difference between static and dynamic background workers in PostgreSQL?
I’m trying to understand when to use a static background worker vs a dynamic one in PostgreSQL.From what I know so far:Static workers are registered during postmaster startupDynamic workers can be ...
Advice
0votes
3replies
56views
PostgreSQL: primary key based on timestamp
I am working on a highload system, which needs to process quite a lot of events, but not an insanely huge amount. The data ingested has to be editable during a short period of time, and then the need ...
- 9,790
1vote
0answers
37views
Error when mapping a list of enums in EF Core to PostgeSQL array
I have a class with a collection of enums mapped into PostgreSQL native enum:internal class EventStackFilter { // other properties omitted public List<EventStackEventStatus> Statuses { ...
- 673
2votes
2answers
104views
Find maximal subsets
I have sets identified by a set_id, say:CREATE TABLE sets ( INTEGER set_id, INTEGER element_id ); I need a SELECT statement that finds the sets that are maximal with respect to the subset ...
Best practices
0votes
1replies
33views
How to run Production PostgreSQL on a VPS (Hetzner/Digital Ocean,etc) - best practices etc?
I am getting into the world of self-hosted applications and I am trying to run a Production PostgreSQL on a VPS - Hetzner.So far I have been using AWS RDS and everything has been working great - ...
- 842
0votes
0answers
25views
cloudsql gcp PGAUDIT
I activated pgaudit on my Cloud SQL instance by adding the two flags enable and pgaudit.log, and I immediately saw audit logs in Cloud Logging without having to create the extension. When I connect to ...
-2votes
0answers
36views
Supabase realtime postgres changes with RLS policy [closed]
Im having an issue with supabase postgres changes. I have a subscription on frontend to watch for changes on a table using RLS policy to only see the changes of the current user.The problem that im ...
-1votes
0answers
32views
PostgreSQL installation error: "The database cluster initialization failed" [closed]
enter image description hereI’m trying to install PostgreSQL on Windows, but the installation fails during the post-installation step. During setup, I get this error message:A problem occurred ...
Advice
0votes
0replies
49views
How apply airflow db migration and save them into postgress docker image?
I use docker-compose to run airflow. Postgres section ispostgres: image: postgres:12.16 environment: - POSTGRES_USER - POSTGRES_PASSWORD - POSTGRES_DB healthcheck: test: [ "...
- 34k
0votes
1answer
49views
insert sample data into a postgresql in docker container not working [closed]
I am running a postgresql in docker container and trying to insert some sample data into this database.prepare_source_data.sql exists in the host environment.here I trieddocker exec -it postgres ...
- 8,168
- The Overflow Blog
- Featured on Meta
Hot Network Questions
- What are the correct lyrics to the song "Lola", by The Kinks?
- Was the spittle and mud in John 9:6-7, symbolic, a catalyst to faith, or a required act of obedience?
- Is there an asymmetric standard applied to zero probability events?
- Testing binary data for statistical independence
- A subset of a rectangle that 'blocks' every curve that goes from right to left must connect upper and lower sides
- When was the symbol "U" first used to denote voltage or electric potential difference?
- Why optional studs on MTB shoes?
- Not Benny but close
- Difference between VOR approach (with DME required) and VOR DME approach?
- Eel-wielding man drowns and his enemy leaves town
- How to use an iPad as an external monitor with Mac mini 6.1 (Late 2012) for installing Ubuntu?
- Murphy's Theorem 3.3.2 on positive linear functionals
- Can missed approach procedures be used for a PT?
- Does the intersection of a variety with rational singularities with a smooth variety have rational singularities?
- Proverb for when one is already in a hurry but the condition wastes even more time
- MinMaxStack - tracks minimum and maximum values
- Simple current source with bjt
- Movie about two immortals: a young girl and an older guy. The guy would collect and kill people for the girl to feed on
- Number of subgroups in a semidirect product
- Fool a program it has a pty of specific size
- Exercise in Mathematical Logic by Ebbinghaus
- When exactly does the game clock start during an American football kickoff?
- Undecidable Checkmate
- Any concerns using blown-in cellulose without blower in a small cavity between cathedral ceiling and roof?