ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #postgresql
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
I'm trying load a tar file using pgAdmin, but it's failing and all I get is exit code 3221225781. This code seems to indicate a missing dll What is exit code 3221225781 on windows? but I'm not sure why this would be or what dll to look for.
Goal Determine whether a standby server that was initially set up with wal_level=replica must be restarted, reinitialized, or simply have its wal_level parameter changed and reloaded after the primary’s wal_level is switched to logical during a pg_upgrade to PostgreSQL 14, in order to maintain logical replication compatibility. Constraints and Uncertainty Po
I want to UPDATE or INSERT a column in PostgreSQL instead of doing INSERT or UPDATE using INSERT ... ON CONFLICT ... because there will be more updates than more inserts and also I have an auto incrementing id column that's defined using SERIAL so it increments the id column everytime it tries to INSERT or UPDATE and that's not what I want, I want the id col
I am reading about differences between JSON and JSONB datatypes on PostgreSql documentation https://www.postgresql.org/docs/13/datatype-json.html . There is this line The json data type stores an exact copy of the input text, which processing functions must reparse on each execution; while jsonb data is stored in a decomposed binary format that makes it slig
django