HomeSolus

Update PostgreSQL to 14.3

Authored by silke on May 18 2022, 7:30 PM.

Description

Update PostgreSQL to 14.3

Summary: Release notes can be found here.

Test Plan:

psql postgres -c "CREATE DATABASE pagila;"
psql pagila < pagila-schema.sql
psql pagila < pagila-data.sql
psql pagila -c "SELECT title, description FROM film WHERE fulltext @@ to_tsquery('saga&india');"
  • Connect to database using LibreOffice Base.
  • Connect to database using Psycopg2:
python3
import psycopg2
conn = psycopg2.connect("dbname=pagila")
cur = conn.cursor()
cur.execute("SELECT title, description FROM film WHERE fulltext @@ to_tsquery('saga&india');")
for i in cur.fetchall():
    print(f"Title: {i[0]}, description: {i[1]}")

Reviewers: Triage Team, algent

Reviewed By: Triage Team, algent

Subscribers: algent

Differential Revision: https://dev.getsol.us/D13224

Details

Committed
algentMay 18 2022, 7:37 PM
Pushed
algentMay 18 2022, 7:37 PM
Reviewer
Triage Team
Differential Revision
D13224: Update PostgreSQL to 14.3
Parents
R2469:e33a61ff02ae: Update PostgreSQL to 14.2
Branches
Unknown
Tags
Unknown
References
tag: postgresql-14.3-35