I have a case where I have a table "tab" that stores data (keyed by symbol and time) as well as a second table "summ" that stores the exponential weighted running average of the data in the first table. I…
I am unable to connect my spring boot application to a PostgreSQL database using Spring JPA. Below is my application.yaml file. spring: application: name: jaah datasource: url: jdbc:postgresql://db:5432/taah username: waah password: blah driverClassName: org.postgresql.Driver jpa: database-platform: org.hibernate.dialect.PostgreSQLDialect hibernate: ddl-auto: update…
I have a table partitioned by date-type column ds, with many fields. Not all columns change every day, therefore most rows are just duplicates of the previous rows. I want to create an SCD2 table from the existing one (partitioned)…
I have a very simple two-table set in Postgre 16.0: CREATE TABLE fk_table ( fk_id INT PRIMARY KEY , fk_name VARCHAR(50) ); CREATE TABLE main_table ( id INT PRIMARY KEY , date TIMESTAMP , fk INT REFERENCES fk_table(fk_id) --, tens…
When trying to save a new Product::Group, with many Product::Features, I get the error "Features is invalid" This below gives the error. class Product::ObjectFeature < ApplicationRecord self.table_name = "object_features" belongs_to :feature, class_name: "Product::Feature", foreign_key: :feature_id, inverse_of: :object_features belongs_to :featurable, polymorphic:…
Context To describe the situation I find myself in currently, let's take the 3 tables relevant to this: CREATE TABLE steam_user ( id SERIAL PRIMARY KEY, username TEXT NOT NULL, steam_id TEXT NOT NULL, profile_url TEXT NOT NULL, avatar_url TEXT…
I am using postgresql and have a select statement on mulitple tables CREATE OR REPLACE VIEW group.all AS SELECT 'gmail'::text AS main_source, gmail.id, gmail.from, gmail.to, gmail.user_id FROM first_group.gmail UNION ALL SELECT 'yahoo'::text AS main_source, yahoo.id, yahoo.from, yahoo.to, yahoo.user_id FROM second_group.yahoo…
I'm studying Postgres by reading the docs, and section 3.4 says this: "Keep in mind that either releasing or rolling back to a savepoint will automatically release all savepoints that were defined after it. https://postgresql.org/docs/current/tutorial-transactions.html Surely they mean "will automatically…
I'm looking for assistance with writing a PostgreSQL query in Apache Superset. I have metered consumption data, where the meters have unique IDs. Normally, a meter is read at the start of every hour, and the difference is calculated in…
I'm running a fairly large sql script (aprox 300k insert statements) against a postgres database and I'm getting a 'no space left on device' error. I know this error means there isn't enough disk space for postgres to complete the…