ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
I already have my server application written in Node, PostgreSQL, Sequelize using Fastify. Now I would like to use TypeScript. Can anyone tell me how to begin rewriting my Server application using TypeScript.
When I call max on two timestamps, I get an error : select max(now()::timestamp, to_timestamp('2021-01-01', 'YYYY-MM-DD')::timestamp); -- ERROR: function max(timestamp without time zone, timestamp without time zone) does not exist My actual usage would be in an upsert query, where I would like to write : INSERT ... ON CONFLICT (pk) DO UPDATE SET ts = max(tab
Goal Determine how PostgreSQL handles ambiguous local times during daylight‑saving transitions when using the AT TIME ZONE operator. Constraints PostgreSQL selects the first matching offset for ambiguous timestamps, a behavior that is implementation‑defined and can change when the zoneinfo database is updated. There is no documented flag to choose the second
The documentation doesn't have examples. https://www.postgresql.org/docs/10/datatype-numeric.html#DATATYPE-NUMERIC-TABLE NUMERIC(precision, scale) I want to use the smallest amount of space to save a positive number that will be at most 100 and I need to accept decimal increments of 0.5 What precision and scale should I use in this case?
I am trying to add a generated column to an existing table with this script. alter table Asset_Store add column md5_hash VARCHAR(100) GENERATED ALWAYS AS (CAST(UPPER( case when OR_ID is not null then MD5(cast(OR_ID as varchar(100))) when Asset_ID is not null then MD5(Asset_ID) else null end ) as VARCHAR(100))) STORED ; but I am getting an error: SQL Error [4
Goal: Reduce the operating cost of a low‑traffic PostgreSQL deployment by minimizing idle backend memory consumption through PgBouncer pooling while keeping the application functional. Constraint: Session pooling preserves temporary tables, prepared statements, and session‑level GUCs but allocates a dedicated backend for each pooled connection, increasing me
I am trying to run a Django project with Postgres database. I use Postgres 13.4 installed via postgressapp (UNIVERSAL with all currently supported versions) and python 3.9 (in venv). I work on Mac with Apple M1 chip, macOS Big Sur. I faced the following well-known problem: django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module: dlopen(/Us
Upon rebuilding my Postgresql database from a dump file using pg_restore , my schema file db/schema.rb is now prefixing the gen_random_uuid() function with public . create_table "cars", id: :uuid, default: -> { "public.gen_random_uuid()" } How can I prevent from the schema file from prefixing method calls with public ?
I am trying to update a column of type integer to numeric(2) in postgres ALTER TABLE employee_status ALTER COLUMN status TYPE numeric(2); but getting the error ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view v_employee_details depends on column "status" Without dropping or deleting data, how can i achieve this? is the
fastify
django