I am trying to generate random serial numbers in PostgreSQL with some conditions. The numbers need to start with the same 3 letters, YAK. After YAK, there needs to be 8 random digits. I only need to do 10 iterations…
I'm getting below error and couldn't figure it what causes the issue. 2024-10-19T11:26:28.546+05:30 WARN 9455 --- [rentsysapi] [nio-8080-exec-2] .m.m.a.ExceptionHandlerExceptionResolver : Resolved [org.springframework.data.mapping.PropertyReferenceException: No property 'asset' found for type 'AssetVehicle'] Asset Vehicle entity: @NoArgsConstructor @AllArgsConstructor @Getter @Setter @Entity @Table(name = "asset_vehicle",…
Some of my collegues claimed: Postgres use a simple index little bit less than a converted to text one... CREATE INDEX simple_index ON my_table(my_varchar); CREATE INDEX text_index ON my_table((my_varchar::text)); And I wonder that the analyze always convert it to text…
In Polars / pandas I can do a rolling sum where row each row the window is (row - 10 minutes, row]. For example: import polars as pl data = { "timestamp": [ "2023-08-04 10:00:00", "2023-08-04 10:05:00", "2023-08-04 10:10:00", "2023-08-04…
I am trying to implement functionality to automatically apply triggers to any new "items" tables as they are created. I tried to do this using an EVENT TRIGGER, firstly with this function: CREATE OR REPLACE FUNCTION public.apply_trigger_on_item_table_creation() RETURNS event_trigger AS…
I use docker compose to run my application on a VPS server. It consists of a golang backend and PostgreSQL DB. While the backend connected to the DB completely fine on my PC, it fails to do so on the…
I want the jsonb output in row format for each user. If the user has 2 subjects then 2 rows should be created for that user. In some JSON certidate would be present. Where certidate is not present createdOn should…
I have a CSV file with a silly filename (for example): 'test_1111 _2_ABC Hr. Schmidt_2024.csv' postgres@minisforum:~/16/import$ ll insgesamt 1212 drwxrwxr-x 3 postgres postgres 4096 Okt 14 19:16 ./ drwxr-xr-x 5 postgres postgres 4096 Okt 13 15:41 ../ -rw-rw-r-- 1 postgres…
In one of my organization's databases there's a table customerReview. Simplified, it looks like: CREATE TABLE customerReview( customerReviewId SERIAL PRIMARY KEY, dateTimeCreated TIMESTAMP WITHOUT TIME ZONE, dateTimeUpdated TIMESTAMP WITHOUT TIME ZONE, businessID INTEGER, reviewText TEXT, reviewerIP TEXT, isIPv6 BOOLEAN )…
I have a table that stores data about events with id, start_timestamp (timestamp with time zone), end_timestamp (timestamp with time zone) and duration (in seconds): create table my_table( id bigint generated by default as identity primary key , start_timestamp timestamptz…