I started to dabble with docker. I have a asp .net core application. I can go to my route /health and see my app can connect to my postgres server fine. But the moment I deploy my application to a…
I have a table logs_bl_sj, which is ordered by startdate: bundesland startdate enddate 'Hessen' 2015-02-26 16:22:21 2015-02-26 16:31:31 'Hessen' 2015-10-20 22:34:54 2015-10-20 22:35:03 'Bremen' 2015-10-20 22:35:50 2015-10-20 22:37:03 ... I want to find for each row r, how many rows…
this is my code in postgresql, and it works perfectly fine: select case when cfd.value like '%TryUSI%' then 'TryUSI' when cfd.value like '%Workshop%' then 'Workshop' when cfd.value like '%KOOP%' then 'KOOP' when cfd.value like '%dual%' then 'dual' when cfd.value like…
I have enum in java public enum Day { MONDAY("D1", "X"), TUESDAY("D2", "X"), WEDNESDAY("D3", "X"), THURSDAY("D4", "X"), FRIDAY("D5", "X"), SATURDAY("D6", "X"), SUNDAY("D7", "Y"); private final String value; private final String value2; Day(String value, String value2) { this.value = value; this.value2…
I have a script that runs for a few minutes as a job on the cluster in the production environment. There are between 0 and 100 such jobs, each with 1 script per job, running at the same time on…
Is there a way of safe selecting a column that doesn't exists in a table without geting "invalid identifier" error? Maybe returning null instead? Something like this: select id, non_existant_column as col_name -- return null here instead of rising an…
I have two tables in postgres. CREATE TABLE data ( name VARCHAR(10) PRIMARY KEY ); CREATE TABLE timeseries ( name VARCHAR(10) NOT NULL REFERENCES data(name), time TIMESTAMP NOT NULL, value INTEGER NOT NULL, PRIMARY KEY (name, time) ); How I…
i cant seem to find anything on this anywhere so maybe y'all will have some answers . we have an rds postgres instance on 14.7 recently upgraded from 11 after the upgrade we have had instances where sometimes the aws_s3.table_import_from_s3…
Defining the class: from sqlmodel import Field, SQLModel, create_engine, Session, select, Column,String class person(SQLModel, table=True): id: Optional[int] = Field(default=None, primary_key=True) name: str = Field(max_length=100) nickname: str = Field(max_length=30) sqlmodel creates the table person: CREATE TABLE person( id SERIAL NOT NULL,…
I have a postgres table: CREATE TABLE clicks ( page_id UUID REFERENCES pages (id) ON DELETE CASCADE, status TEXT NOT NULL, click BIGINT NOT NULL, PRIMARY KEY (page_id, status) ); and two execution blocks: code_block_1: BEGIN; LOCK TABLE clicks IN…