Details
Details
- Reviewers
algent - Group Reviewers
Triage Team - Maniphest Tasks
- T10234: Split postgres package into binary and libraries
- Commits
- R2469:a4a490b96e8e: Update PostgreSQL to 14.5 and split libpq
- Import and query the Pagila sample database:
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
Diff Detail
- Repository
- R2469 postgresql
- Branch
- master
- Lint
No Lint Coverage - Unit
No Test Coverage - Build Status
Buildable 4367 Build 4367: arc lint + arc unit
Event Timeline
Comment Actions
Note that all packages that depend on pkgconfig(libpq) will need a rebuild for the dependency to be updated. However, there is no harm in leaving them be, as postgresql itself depends on postgresql-libpq. AFAIK there are no packages depending on postgresql that should depend on pkgconfig(libpq) instead.
Comment Actions
While I am verifying rebuilds. Please add the component for postresql-libpq and maybe a summary too, if you find a good one.
Comment Actions
Not that it matters that much, but shouldn't it be ^libpq? Without the postgres- prefix.