Top "Postgresql-10" questions

for PostgreSQL questions specific to version 10

how to use COMMIT and ROLLBACK in a PostgreSQL function

I am using three insert statements, and if there is an error in the third statement, I want to rollback …

postgresql postgresql-10
What is the most suitable hibernate.dialect for postgresql 10.5?

I am looking at hibernate documentation here: https://docs.jboss.org/hibernate/orm/5.0/javadocs/org/hibernate/dialect/package-summary.html to …

postgresql hibernate hibernate-5.x postgresql-10
Postgres Psycopg2 Create Table

i´m new to Postgres and Python. I´m trying to create a simple user table but i don´t …

python database postgresql python-3.6 postgresql-10
PostgreSQL error: set-returning functions are not allowed in CASE

I tried to run this query in PostgreSQL 10: select e.errordescription, CASE WHEN e.reworkempid is not null THEN get_…

sql postgresql set-returning-functions postgresql-10
Postgresql 10 - Parallel configuration

There are 4 configurations to enable the parallel and do the optimization, but the documentation of PostgreSQL doesn't says anything about …

postgresql postgresql-10
How to migrate an existing Postgres Table to partitioned table as transparently as possible?

I have an existing table in a postgres-DB. For the sake of demonstration, this is how it looks like: create …

sql postgresql database-partitioning postgresql-10
PostgreSql : ERROR: relation "sequence" does not exist while restoring from dump file

I get the following error while restoring database from dump file on server: ERROR: relation "table_id_seq" does not …

postgresql postgresql-9.6 pg-dump postgresql-10
How to use scram-sha-256 in Postgres 10 in Debian? Getting "FATAL: password authentication failed"

I edited pg_hba.conf: sudo su postgres nano /etc/postgresql/10/main/pg_hba.conf and added this line: local …

postgresql authentication postgresql-10 sasl-scram
root.crt not found postgresql

I have a postgres docker image that i am using and I am enabling SSL on it. I want it …

linux docker postgresql-10