Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#973 closed defect (fixed)

PostgreSQL provider won't work on PostgresSQL >= 12.0

Reported by: jng Owned by: jng
Priority: major Milestone: 4.1.0
Component: PostgreSQL Provider Version:
Severity: 3 Keywords:
Cc: External ID:

Description

The PostgreSQL provider makes reference to the column pg_attrdef.adsrc here.

This column has been removed in PostgreSQL 12.0, rendering the provider un-usable for this version of PostgreSQL.

The use of d.adsrc can be replaced with pg_get_expr(d.adbin, d.adrelid). For even more safety, do a PG version check to see whether we can use adsrc or its replacement.

Change History (2)

comment:1 by jng, 5 years ago

Resolution: fixed
Status: assignedclosed

In 7962:

Fix PostgreSQL 12 compatibility.

Fixes #973

comment:2 by jng, 5 years ago

In 7964:

Merged revision(s) 7962-7963 from branches/4.1:

Fix PostgreSQL 12 compatibility.
Fixes #973

If CheckReaderString? fails in any of the Expression Engine function tests, lets be at least courteous and record the values being tested that failed expectations.
........

Note: See TracTickets for help on using tickets.