Page MenuHomeSolus

Update PostgreSQL to 14.1
ClosedPublic

Authored by silke on Sun, Nov 14, 11:20 AM.

Details

Summary

Release notes can be found here and here.

Note that the update instructions need to be updated first, see help-center-docs#303.

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]}")

Diff Detail

Repository
R2469 postgresql
Lint
Automatic diff as part of commit; lint not applicable.
Unit
Automatic diff as part of commit; unit tests not applicable.

Event Timeline

silke created this revision.Sun, Nov 14, 11:20 AM
silke requested review of this revision.Sun, Nov 14, 11:20 AM
silke updated this revision to Diff 29897.Sun, Nov 14, 11:23 AM

Fix release number

JoshStrobl accepted this revision.Tue, Nov 16, 7:07 AM
JoshStrobl added a subscriber: JoshStrobl.

LGTM, thanks!

This revision is now accepted and ready to land.Tue, Nov 16, 7:07 AM
This revision was automatically updated to reflect the committed changes.