For PostgreSQL questions specific to version 11.
I recently installed Postgresql 11, during the installation, there's no step to put password and username for Postgres. Now in pgAdmin 4, …
postgresql pgadmin-4 postgresql-11I am in CentOS Linux release 7.5.1804 (Core) When I login as postgres and run: bash-4.2$ /usr/pgsql-11/bin/initdb -D /…
postgresql centos7 postgresql-11I am trying to use node-pg-migrate and run migrations to create tables in my node project. When I run migrations …
postgresql postgresql-11PostgreSQL supports stored procedure (not function) since version 11. I created a stored procedure like this: CREATE OR REPLACE PROCEDURE get_…
postgresql postgresql-11According to the documentation (https://www.postgresql.org/docs/current/app-psql.html), even with AUTOCOMMIT set to off, PSQL issues …
postgresql transactions plpgsql commit postgresql-11I am trying to write a base type for PostgreSQL in C (using xcode), and I already installed PostgreSQL 11, but …
c postgresql postgresql-11I created a stored procedure in PostgreSQL 11 to perform CRUD operation, and it works fine for 1. Create 2. Update 3. Delete, but …
postgresql function stored-procedures postgresql-11I have a table partitioned per month (timestamp column). when querying the data, explain shows that all partitions are being …
postgresql database-partitioning postgresql-11In the PostgreSQL 11 Release Notes I found the following improvements to partitioning functionality: Add support for PRIMARY KEY, FOREIGN KEY, …
database-partitioning postgresql-11